Free tool
JSON to CSV Converter
Turn JSON into a spreadsheet-ready CSV, flattening nested objects into columns.
Paste a JSON array of objects to get a CSV with one row per object. Nested objects are flattened into dotted column names, so {"user":{"name":"Ana"}} becomes a column called user.name. A single object works too and produces one row. Everything runs in your browser tab.
The part that most converters get wrong is quoting. A field containing your delimiter, a double quote or a newline has to be wrapped in quotes, and any quote inside it doubled, or the file will not parse in Excel or anything else. This follows RFC 4180, and you can switch to semicolons or tabs when your spreadsheet expects them.
How to use it
- Paste a JSON array of objects, or a single object.
- Pick your delimiter. Semicolon suits many European locales.
- Choose whether to flatten nested values into dotted columns or keep them as JSON in one cell.
- Copy the CSV, or paste it straight into a spreadsheet.
Frequently asked questions
What happens to nested objects and arrays?
With flattening on, nested objects become dotted columns such as user.address.city, and arrays become indexed columns such as tags.0 and tags.1. With it off, any nested value is written into a single cell as compact JSON, which is better when the shape varies between rows.
What if the objects have different keys?
The header is the union of every key found across all rows, in the order first encountered. Rows missing a key get an empty cell rather than a shifted column.
Why does Excel split my data into the wrong columns?
Usually the delimiter. Excel in many European locales expects a semicolon rather than a comma, so a comma-separated file lands in one column. Switch the delimiter here, or import rather than double-clicking the file.
How are commas and quotes inside values handled?
Per RFC 4180: any field containing the delimiter, a double quote or a line break is wrapped in double quotes, and inner quotes are doubled. That is what makes the output safe to open anywhere.
The desktop version
JSON to CSV Converter in Toolbelt
This page does the job in a browser tab. Toolbelt is the same tool as a native Mac app, plus the things a web page cannot do.
Tools
{
"name": "Holizmi",
"tools": [
"json",
"jwt",
"base64"
],
"live": true
}{
"sub": "12345",
"name": "Henry",
"exp": 1767225600
}019bd4e2-7a10-7c3e-9f21-4a6b8d3e5c07
019bd4e2-7a11-7b8a-8e44-1c2f9a7d6b13
019bd4e2-7a12-7d5f-b0c9-7e3a1f8c2d95 1 1 one
2 2 two
3 + inserted
3 4 three- Convert a folder of JSON files in one run
- Write the CSV straight to disk instead of copying it
- Reorder and drop columns before exporting
- Also converts to YAML, TOML and SQL inserts