To convert JSON to CSV, paste a flat array of JSON objects into the converter and choose JSON to CSV; to go back, paste CSV and choose CSV to JSON. The tool works for flat data, where every object has simple values rather than nested objects.
Follow along with the free JSON ↔ CSV Converter, which runs in your browser, or browse more tools in this category.
How to use the JSON ↔ CSV Converter
- Paste a JSON array of objects, or CSV text with a header row.
- Choose the direction of conversion.
- Review the output and check the columns.
- Copy it or use it in a spreadsheet.
Worked example
[{“name”:”Ada”,”age”:36},{“name”:”Alan”,”age”:41}] becomes a header line name,age followed by rows Ada,36 and Alan,41.
Tips and common mistakes
- Nested objects and arrays do not fit into flat CSV cells, so flatten them first.
- The first CSV row is treated as the header that names each key.
- Values containing commas or quotes are wrapped in quotes so the CSV stays valid.
Frequently asked questions
Can it convert nested JSON?
It is designed for flat arrays of objects. Nested values need to be flattened first.
Which row becomes the keys?
The first row of the CSV is used as the header.
Is the data uploaded?
No. Conversion runs in your browser.