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

  1. Choose your files, or drop them onto the box above. You can add several at once.
  2. Add a .json file holding an array of records. Nested objects become columns such as address.city; check the preview, then convert.
  3. Press the Convert to CSV button.
  4. 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:

Related tools