About JSON to CSV
API responses and app exports often come as JSON, but spreadsheets need rows and columns. Paste a JSON array of objects, or open a .json file, and get CSV instantly. Every key across all objects becomes a column, so records with missing fields still line up. Nested objects are flattened into columns such as address.city, and lists are kept as JSON text in one cell. Values with commas, quotes or line breaks are quoted correctly. The download includes a marker that makes Excel show accented characters properly.
How to Use It
- 01
Paste or open JSON
Paste a JSON array into the left box, or press Open file.
- 02
Pick a delimiter
Comma suits most apps. Use semicolon for Excel in many European countries.
- 03
Copy or download
Copy the CSV, or download it and open it in your spreadsheet app.
Questions
What JSON shape does it need?
An array of objects, such as [{"name": "Ann"}, {"name": "Bo"}]. A single object becomes one row, and an array of arrays is written row by row.
How are nested objects handled?
They are flattened into dotted column names, so {"address": {"city": "Pune"}} becomes a column called address.city.
Why do accents look wrong in Excel?
Keep the Excel-friendly download option on. It adds a byte order mark that tells Excel the file is UTF-8.
Is my data uploaded?
No. The conversion runs in your browser.