JSON to CSV converter
Turn a JSON array into a spreadsheet-ready CSV, entirely on your device.
Convert JSON to CSV for Excel and Google Sheets
The usual path is an API response or a database export that someone needs in a spreadsheet. Paste the JSON array and you get CSV with a header row built from the object keys, ready to open in Excel, Numbers or Google Sheets. The data stays in your browser — which matters, because API responses tend to be full of user records.
Getting the shape right
- Start from an array of objects. If your JSON wraps the list —
{"data": [...]}— paste only the array. - CSV is flat. A nested object or array is written into a single cell as JSON text rather than spread across columns. Flatten nested fields first if you need them separately.
- Rows don't need identical keys. Every key that appears in any object becomes a column, and rows without it get an empty cell.
- Values with commas, quotes or line breaks are quoted correctly, so they survive the trip into a spreadsheet intact.
Other conversions with this tool
How to convert JSON to CSV
- 1
Paste a JSON array of objects.
- 2
Check the columns in the preview table.
- 3
Copy the CSV into a .csv file or a spreadsheet.
JSON to CSV — frequently asked questions
Is my JSON uploaded anywhere?
No. The conversion runs in your browser, and this site has no server that could receive your JSON. A Content-Security-Policy blocks requests to other domains; you can confirm in DevTools → Network or by going offline.
What JSON shape does it expect?
An array of objects, such as an API list response. Each object becomes a row and the keys become the header row.
What happens to nested objects?
CSV is flat, so a nested object or array is written into a single cell as JSON text. Flatten the data first if you need each nested field in its own column. Objects with different keys are fine: every key found becomes a column.