Convert a JSON array of objects into CSV that opens cleanly in Excel, Google Sheets, or Numbers. Keys become column headers; values are quoted and escaped correctly.
JSON to CSV
Paste a JSON array of objects and get CSV you can open in Excel or Google Sheets. Keys become columns; nested values are kept as JSON strings. Conversion runs in your browser.
How to use JSON to CSV
- Paste a JSON array of objects (an API response, an export, a log dump).
- Click convert to build the CSV with a header row.
- Copy the CSV or download it as data.csv.
Example: [{"name":"Ada","hours":32}] becomes a two-line CSV with name and hours columns.
Frequently asked questions
- What happens to nested objects and arrays?
- Nested values are kept as JSON strings inside their cell, so no data is lost. If you need nested fields as separate columns, flatten the objects before converting.
- Why do some cells have quotes around them?
- CSV requires quoting when a value contains a comma, quote, or line break. Inner quotes are doubled, per the CSV standard—Excel and Sheets read this correctly.
- Do objects need identical keys?
- No. Columns are the union of all keys in the array; objects missing a key get an empty cell in that column.