JSON to CSV Converter - Free Online Tool

A JSON to CSV converter turns JSON data into a CSV table you can paste into Excel, Google Sheets, or other tools that expect rows and columns. It is most useful for API responses and exports where you have an array of objects and you want a quick spreadsheet view. Conversion runs locally in your browser, so your JSON is not uploaded for processing.

1. Paste JSON: Add a JSON array of objects (common) or a single JSON object.
2. Choose options: Set delimiter, headers, and whether to flatten nested objects.
3. Copy the CSV: Copy the output into a spreadsheet or download it for later use.

• Spreadsheet-ready: Move structured JSON into rows and columns quickly.
• Control the output: Choose delimiter, include headers, and flatten nested keys when needed.
• Private conversion: Parsing and conversion happen on your device in the browser.

CSV is tabular, but JSON can be many shapes. This converter is designed to handle the most common cases you will encounter:

• Array of objects: The best input for CSV. Each object becomes a row, and keys become column headers.
• Single object: Converted into a one-row CSV.
• Array of values or arrays: Converted into a simple CSV with a value column when needed.

If your objects contain nested objects, you can flatten them into dot-notation columns (for example, user.profile.name). This makes the output easier to sort and filter in spreadsheets.

Different tools expect different separators:

• Use comma for most CSV workflows.
• Use semicolon when your spreadsheet locale uses commas as decimal separators.
• Use tab when you want to copy and paste cleanly into spreadsheets without comma conflicts.
• Turn on Always quote fields when you want consistent quoting or when your data contains lots of commas.

Use case 1: Review API data in a spreadsheet

Paste a JSON response from a REST endpoint, convert it to CSV, then filter and sort it in Sheets to spot anomalies.

Use case 2: Prepare exports for non-technical teams

Convert JSON exports into CSV so teammates can open and edit data without a developer toolchain.

Use case 3: Clean data for quick analysis

Flatten nested objects into dot-notation columns so you can pivot, chart, or check duplicates in a table.

Basic example (array of objects)

Input:

[
  { "name": "Asha Patel", "email": "asha@example.com", "plan": "Pro" },
  { "name": "Luis Gomez", "email": "luis@example.com", "plan": "Starter" }
]

Output (CSV):

name,email,plan
Asha Patel,asha@example.com,Pro
Luis Gomez,luis@example.com,Starter

Advanced example (flatten nested objects)

Input:

[
  {
    "user": { "id": 7, "profile": { "name": "Asha Patel" } },
    "active": true,
    "tags": ["trial", "b2b"]
  }
]

Settings: Flatten nested objects: On; Arrays: Join values; Array join delimiter: |
Output (CSV):

user.id,user.profile.name,active,tags
7,Asha Patel,true,trial|b2b

Invalid JSON

JSON is strict. Trailing commas, unquoted keys, or single quotes will cause errors. If your input fails, format and validate it first using the JSON formatter.

Mixed shapes across rows

If one object has extra keys, CSV rows will contain empty cells for missing fields in other objects. This is normal because CSV is a fixed-column format.

Nested arrays and objects look "weird" in CSV

CSV is flat. Nested objects can be flattened into dot-notation columns, and arrays can be joined into a single cell or stringified as JSON. Pick the option that matches how you plan to use the output.

Output looks wrong after pasting into Excel or Sheets

If columns are not splitting correctly, the delimiter likely does not match your spreadsheet settings. Try switching delimiter to semicolon or tab and paste again.

• Use the right delimiter for your locale: Some spreadsheet setups expect semicolons. Switch delimiter to avoid broken columns.
• Flatten for spreadsheets: Turn on flattening when you want columns like user.profile.name instead of JSON blobs inside cells.
• Round-trip carefully: If you need to convert back later, keep complex structures as JSON strings or export JSON separately. CSV cannot always reconstruct nested data.
• Validate before converting: If you are copying JSON from logs or web pages, run it through the JSON formatter first to catch hidden syntax issues.

• Convert the other direction with the CSV to JSON converter.
• Clean messy pasted CSV with the CSV cleaner & validator.
• Fix invalid input quickly with the JSON formatter or shrink payloads with the JSON minifier.

JSON to CSV conversion runs locally in your browser. Your data is not uploaded to a server for processing. If you are converting sensitive exports, clear the input after copying the CSV.