How to use the JSON to CSV Converter tool
- Paste a JSON array of objects, for example an API response.
- Choose the delimiter (semicolon for Excel in many European locales).
- Copy the CSV or download it as a file.
How nested data is handled
Spreadsheets are flat, JSON is not. Nested objects are flattened with dot notation, so {"address": {"city": "Berlin"}} becomes a column named address.city. Arrays are written as JSON text in a single cell. Columns are the union of all keys, so objects with missing fields simply get empty cells.
Opening the file in Excel
- The downloaded file includes a UTF-8 byte order mark, so Excel shows accented letters and non-Latin scripts correctly.
- If all data lands in one column, your Excel expects a different delimiter. Choose semicolon and download again.
- For large exports, Data → From Text/CSV in Excel lets you set column types and avoids it converting IDs into numbers or dates.
Privacy
Everything runs in your browser. Nothing you type is sent to our server or stored.
Frequently asked questions
Can I convert a single JSON object?
Yes. It becomes a CSV with one data row.
What happens to arrays inside objects?
They are kept as JSON text in one cell, for example ["a","b"].
Is there a row limit?
No fixed limit. Tens of thousands of rows work in a modern browser.
Can I convert CSV back to JSON?
Yes, with the CSV to JSON converter.