Skip to the tool
GigaJSON

JSON to CSV

All tools
Format and check
View and query
Convert
JSON to code
Encode and decode
Sample files
Guides Open GigaJSON
Input JSON
Output CSV

The CSV output appears here as you type.

Ready Runs in your browser

Turn a list of JSON objects into a CSV table for Excel, Google Sheets or Numbers. Each key becomes a column. Nested objects become dotted columns such as address.city, and a list inside a row is kept as JSON text. For an .xlsx file, use JSON to Excel. The reverse is CSV to JSON.

How to use it

  1. Paste a JSON array (or an object that holds one), or open a file.
  2. A CSV preview appears with the number of rows and columns.
  3. Download the .csv file or copy it.

Read more: How to open a JSON file on Windows, Mac, a phone or in Excel · Convert JSON to CSV: nested objects, arrays and Excel gotchas

Private, and made for big files

This tool runs in your browser, in a background worker: nothing you paste or open is uploaded, and nothing is kept after you leave. JSON and XML input can be up to 1 GB, depending on available memory. Processing runs in a background worker; large analyses can take a minute or more. Already loaded features keep working if your connection drops. Loading another tool or jq for the first time needs a connection. When one tool isn't enough, GigaJSON opens your data with a tree, a table, JSONPath/JMESPath/jq queries, transforms, diff and history.

Turn nested fields into columns

Try [{"id":"001","customer":{"name":"Ada","city":"Pune"},"total":149},{"id":"002","customer":{"name":"Sam","city":"Oslo"},"total":89}]. Each object becomes a row; nested customer fields become columns. Review the header and the two records before downloading.

A quoted JSON ID does not force Excel to treat a CSV cell as text. Import that column as Text to keep 001 intact. Arrays and missing values also need a deliberate export choice. The nested JSON-to-CSV guide explains these cases with examples.

GigaJSON converting nested customer objects to CSV columns with two example recordsGigaJSON converting nested customer objects to CSV columns with two example records (dark theme)
Nested fields become columns. Review the generated CSV before importing it into a spreadsheet. Screenshots follow the page theme. Click to view full size.

Questions

What JSON can be converted?

A list of objects works best. If you give it an object with one list inside, that list becomes the rows. Anything else becomes a single row.

How are nested objects handled?

They are flattened into dotted column names: {"address": {"city": "Lima"}} gives a column called address.city. Lists inside a row are written as JSON text.

Is my data uploaded?

No. The tool runs in your browser, in a background worker. Nothing you paste or open goes to a server, and nothing is kept after you leave the page.

How large a file can it handle?

JSON, XML and CSV input can be up to 1 GB, depending on memory. YAML input and JSON repair are limited to 128 MB. Conversion runs in a background worker. jq, text editing and text-based exports have separate limits, shown when you use them.

All tools