How to use the JSON to CSV Converter
Paste a JSON array of objects, such as data exported from an API, and copy the CSV output. Every field is quoted so commas and line breaks inside values stay safe.
How the conversion works
The converter reads every object in the array, collects all the keys it finds and uses them as the header row. Each object then becomes one row, with its values placed under the matching columns. If an object is missing a key, that cell is left empty.
Nested data
CSV is flat, so it cannot hold objects inside objects. When a value is itself an object or an array, it is written into the cell as a JSON string. If you need separate columns for nested fields, flatten the JSON first, for example turning address.city into its own key.
How it works
Array of objects → CSV
Examples
- With the default values
name,role Ada,Engineer Lin,Designer
Limitations and assumptions
Nested object values are serialized as JSON strings. Input must be an array of objects.
Frequently asked questions
What JSON shape does it accept?
An array of objects, like [{"name":"Ana","age":31},{"name":"Ben","age":28}].
Can I open the result in Excel?
Yes. Save it as a .csv file, or paste it into a sheet and split the text into columns.
Is my data uploaded?
No. Everything is converted in your browser.