JSON to CSV
Convert a JSON array into CSV data.
JSON to CSV converts a JSON array of objects into CSV data, using the union of all keys found across the objects as the column headers.
How to use
- Paste a JSON array of objects.
- The CSV result appears automatically below, using the union of all keys as columns.
Common use scenarios
- Converting an API response's JSON array into a spreadsheet-friendly CSV file.
- Turning structured JSON data into a format that's easy to open in Excel or Google Sheets.
- Preparing JSON data for import into a system that only accepts CSV.
- Flattening a simple JSON dataset into a table for quick review.
✓Content & verification reviewed: 2026-08-25
How we verify JSON to CSV
How to confirm the resulting CSV columns and rows match your JSON data correctly.
Input must be a JSON array of objects
The input needs to be an array (starting with "[") containing objects (like [{"a":1}, {"a":2}]) — a single object, or an array of non-object values, will be rejected with an error rather than producing a guessed-at result.
Columns are the union of all keys
If different objects in your array have different sets of keys, the resulting CSV includes a column for every key that appears in any object — rows missing a given key will have an empty cell in that column, rather than causing an error.
Nested values become JSON strings in a cell
If a field's value is itself an object or array (a nested structure), it's converted to a JSON string and placed as text in that CSV cell, rather than being flattened into separate columns — this keeps the conversion predictable but means nested data isn't spread across columns automatically.
Before you rely on the result
- Your input is a JSON array of objects, not a single object or an array of plain values.
- You've checked whether your objects have consistent keys, or if some rows will have empty cells for missing keys.
- If any fields contain nested objects/arrays, you're aware they'll appear as JSON text in a single cell, not spread across columns.
- You've opened the resulting CSV to spot-check that the columns and values line up as expected.
Who this is for
- Developers converting an API response's JSON array into a spreadsheet-friendly file.
- Anyone turning structured JSON data into something easy to open in Excel or Sheets.
- People preparing JSON data for import into a CSV-only system.
- Anyone flattening a simple JSON dataset into a table for a quick review.
Real-world examples
Turning an API response into a spreadsheet
A developer fetches a JSON array of records from an API and converts it to CSV so a non-technical colleague can review the data in a spreadsheet.
Preparing data for a CSV-only import tool
Someone has JSON data that needs to go into a legacy system that only accepts CSV uploads, so they convert it as a bridging step.
Reviewing JSON test data in table form
A developer converts a JSON array of test fixtures to CSV to more easily scan through the values in a spreadsheet, spotting inconsistencies faster than reading raw JSON.
Limitations
- Nested objects/arrays inside a field are converted to a JSON string in that CSV cell.
Frequently asked questions
Why did I get an error saying the input must be an array?
The tool specifically expects a JSON array of objects, like [{"a":1}, {"a":2}] — a single object without the surrounding array brackets, or an array of non-object values, isn't a supported input shape.
What happens if my objects have different sets of fields?
The CSV output includes a column for every key that appears in any object (the union of all keys) — objects missing a particular key simply get an empty cell in that column.
What happens to a field that's itself an object or array?
It's converted to a JSON string and placed as text within that single CSV cell, rather than being split into multiple columns — this keeps nested data intact but not automatically flattened.
Will special characters in my data break the CSV?
The conversion follows standard CSV quoting rules, wrapping values containing commas, quotes, or line breaks in quotes as needed, so the output should open correctly in spreadsheet software.
🔒 Runs in your browser — nothing is uploaded. Results are for reference only; see the disclaimer. Last updated: 2026-08-25
Subscribe for updates
New tools and tips, straight to your inbox. No spam, unsubscribe anytime.