How to convert JSON to CSV
- Paste a JSON array of objects into the input box (an API response, a database export, anything).
- The CSV appears live — the header row is built from the union of all object keys.
- Copy it, or click Download .csv and open it straight in Excel or Google Sheets.
Why convert JSON to CSV?
JSON is how machines exchange data; spreadsheets are how everyone else reads it. Whenever you need to hand an API export to a colleague, analyze data in Excel, or import records into a CRM, CSV is the lingua franca. This converter handles the annoying edge cases correctly: objects with different keys merge into one consistent column set, values containing commas or quotes are escaped per the CSV standard, and nested structures are preserved as JSON strings rather than silently dropped.
Frequently asked questions
What JSON shape can be converted?
The classic shape is an array of objects — each object becomes a row and each key becomes a column. A single object works too (one row), and objects with different keys are merged into the full column set.
How do I open the result in Excel?
Click Download .csv and open the file in Excel, Google Sheets or Numbers. Values containing commas, quotes or line breaks are quoted correctly so columns line up.
What happens to nested objects and arrays?
Nested values are embedded as JSON strings in their cell, so no data is lost. For fully flat columns, flatten the structure before converting.
Is my JSON data uploaded to a server?
No. The conversion runs entirely in your browser — API responses and exports never leave your machine.