Developer tool
JSON to CSV converter
Turn a list of JSON records into a spreadsheet. Download the .csv and open it in Excel or Google Sheets. Need the other way? Use CSV to JSON.
Advertisement
CSV
Advertisement
How JSON becomes CSV
- Each object in the array becomes one row, and every key becomes a column. Records with missing keys get empty cells.
- Nested objects become columns joined with dots, like
address.city. Lists stay as JSON text in one cell. - If you paste a single object, or an object with one list inside (like an API response with
"data": [ … ]), the list is used. - Values with commas, quotes or line breaks are put in quotes, so spreadsheets read them correctly.
Excel shows strange characters like é.
The downloaded file includes a marker that tells Excel it's UTF-8, so accents and the ₹ sign show correctly. If you copy and paste instead, use the download.
Excel puts everything in one column.
In some countries Excel expects semicolons. Choose Semicolon and download again.
Advertisement