JSON to CSV
Turn JSON records into a CSV file.
When to use it
Use it to bring JSON data into a spreadsheet, a database import or any tool that reads CSV.
How it works
- Choose your files, or drop them onto the box above. You can add several at once.
- Add a .json file holding an array of records. Nested objects become columns such as address.city; check the preview, then convert.
- Press the Convert to CSV button.
- Download the result, or add a next step without downloading.
Supported formats
- Input
- JSON
- Output
- CSV
- Files
- One or several; each file is processed on its own
Several results can be downloaded one by one or together as a ZIP.
Where your file goes
This tool runs in your browser: the file is processed on your device and is not uploaded. The Network tab of your browser's developer tools shows this.
What is kept, and what is not
Every value is written into the CSV. Text that a spreadsheet would run as a formula (starting with = + - @) gets a leading apostrophe; plain numbers are left as they are.
Limits
- Up to 1,000,000 records. CSV holds text only: number formats, several sheets and cell styles do not exist in a CSV file.
- Files up to 512 MB each.
- The work happens in your device's memory, so a phone may fail on a file that a computer handles.
If something goes wrong
Some cells start with an apostrophe
Text that begins with = + - or @ would be run as a formula by a spreadsheet. The apostrophe stops that; plain numbers such as -42 get none.
The page becomes slow with a very large file
Close other tabs, or use a computer instead of a phone.
My file is not accepted
Check the formats listed above. A damaged file, or one with the wrong extension, is refused with a message saying why.
Questions
Which separator is used?
The one your language's Excel expects (a semicolon where the decimal mark is a comma), unless you choose comma, semicolon or tab.
What happens to lists inside a record?
By default a list stays in one cell as JSON text. Choose one column per element to spread it over columns such as tags.0, tags.1.
Continue with the result
The result can go straight into another tool on this page, without downloading it and uploading it again: