JSON to CSV converter
To convert JSON to CSV, drop your JSON file in the box below. It converts straight away; press Download to save the CSV. It all happens in your browser, so your file stays on your device.
Convert to
Converted on this device, never uploaded
What changes
| JSON to CSV | What happens |
|---|---|
| Shape | An array of objects (or one object, or an array of arrays) |
| Nested objects | Flattened into dotted columns, like address.city |
| Arrays inside a record | Kept as JSON text in one cell |
| Columns | Every key from every record, in the order first seen |
| Large numbers | Kept digit for digit in Chrome and Edge |
How to convert JSON to CSV
- Add your JSON. Drop the file in the box, or click to choose it. It becomes CSV straight away.
- Check the result. Look at the preview. The delimiter and value types are set for you; change them if needed.
- Download. Press Download to save the CSV.
Why CSV
Open JSON data in Excel or Google Sheets: each object becomes a row and each key a column.
Questions
They become dotted columns: {"address": {"city": "Lisbon"}} gives a column address.city.
Turn on “Excel-friendly” before downloading. It adds a UTF-8 mark so Excel reads accents correctly.
Your Excel expects semicolons (common in Europe). Choose “Semicolon” under “Separate columns with”.
Yes. A file with one JSON object per line is read as a list.
No. The conversion happens right in your browser, so your file stays on your device. There is no account to make, either.