Convert JSON to CSV
Convert an array of JSON objects to a CSV table, ready to open in Excel, Google Sheets or any spreadsheet.
Processed on your device. Nothing is sent to any server.
Detects the objects' keys as columns and generates one row per array item, correctly escaping commas and quotes within values.
Use cases
- Exporting API data to a spreadsheet.
- Converting a JSON array to a format you can easily share.
- Preparing data to import into another tool that only accepts CSV.
How it works
- 1
Paste your JSON
An array of objects with the same keys, e.g. [{"name":"Ana"}].
- 2
Convert it
Click Convert and copy or download the resulting CSV.
Technical details
- Columns are the union of the keys of every object, in order of appearance; if a row lacks a field, that cell is left empty.
- Nested objects and arrays aren't flattened: they're written as JSON inside their cell (for example {"city":"Madrid"}).
- It uses a comma separator and double quotes when a value contains commas, quotes or line breaks. If Excel in your region expects semicolons, import the file and choose comma as the separator.
Frequently asked questions
What if I pass a single object instead of an array?
It's treated as a one-item array and generates a single-row table with its keys as columns.