Loading tool…
About the JSON to CSV Converter
Paste a JSON array of flat objects (the shape most APIs return for lists of records) to get a CSV with a header row built from the union of all keys — ready to open in Excel, Sheets, or import elsewhere.
How to use the JSON to CSV Converter
- Paste a JSON array of objects, e.g. [{"id":1,"name":"Ada"}, ...].
- Click Convert.
- The header row is built from every key found across all objects.
- Copy or download the CSV.
Step-by-step walkthrough with examples and the errors people hit: How to Convert JSON to CSV.
Example
JSON input
[{"id":1,"name":"Ada"},{"id":2,"name":"Grace"}]
→
id,name 1,Ada 2,Grace
Common errors and how to fix them
Every item must be an object
Arrays of numbers or strings have no keys to build a header from. Wrap each value in an object, for example [{"value": 5}].
Columns shifted in the spreadsheet
A value contained a comma and was not quoted by the source. This converter quotes automatically; if you edited the CSV by hand afterwards, check that row.
More problems and fixes in the tutorial
FAQ
What if objects have different keys?
The header row is the union of every key seen across all objects; a missing value for a given row is left blank.
Does it handle nested objects or arrays?
Nested values are converted to their JSON string representation in the cell, since CSV has no concept of nesting.
What if my top-level JSON isn’t an array?
The tool expects an array of objects. A single object is wrapped into a one-row table automatically.