JSON to CSV Converter Online — Free & Private

Flatten objects into dotted CSV columns, following the long-standing FastMinify conversion rules. Nested structures become headings like parent.child.quantity.

Loading…
JSON → CSV flattening rules
Explains how nested objects and arrays are flattened into columns.

Developer notes

Only objects, or arrays of objects, flatten predictably. A wrapper with a single key, such as `{ "orders": [ {...} ] }`, is unwrapped to an array of rows automatically. A primitive at the top level or an array of mixed shapes triggers a hint to reshape the data first. On the French, German and Spanish pages, CSV uses `;` between columns by default, as European spreadsheets expect (Numbers, Excel). Split very large exports offline before you convert them in the browser.

Use cases

QA teams merging webhook payloads into spreadsheets. Revenue operations matching CRM JSON with CSV templates. Support teams pairing tickets with summarized exports.

About these options

For CSV output, choose the delimiter, how fields are quoted, the line endings and whether to write a header row. Auto uses a comma in English and a semicolon in French, German and Spanish, as Excel expects. For CSV input, the delimiter is detected on the first line (comma, semicolon, tab or pipe). You choose whether that line holds the column names. JSON output can use 2 or 4 spaces or a single line, with an optional recursive key sort. XML output can be pretty-printed with a chosen indent width. YAML output takes an indent width and a quoting mode for strings. XML comments are dropped, because the conversion goes through a JSON tree.

Examples

Accounts with nested fields

Input

[ { "id": 701, "account": {"name": "Nova", "tier": "enterprise"}, "active": true, "sessions": null }, { "id": 702, "account": {"name": "Pixel", "tier": "trial"}, "active": false, "sessions": 3 } ]

Output

id,active,sessions,account.name,account.tier 701,true,,Nova,enterprise 702,false,3,Pixel,trial

Nested configuration with dotted headers

Input

{ "package": { "name": "fastminify", "version": "2.1.0", "edition": "2021", "authors": ["FastMinify Team"] }, "dependencies": { "serde": { "version": "1.0", "features": ["derive"] }, "tokio": "1.35" }, "features": { "default": ["cli"], "cli": [] } }

Output

package.name,package.version,package.edition,package.authors,dependencies.serde.version,dependencies.serde.features,dependencies.tokio,features.default,features.cli fastminify,2.1.0,2021,FastMinify Team,1.0,derive,1.35,cli,

Related tools

Validate exports with the JSON validator, inspect rows in the JSON tree viewer, or reduce the payload size with our JSON minifier. For other formats, see JSON → YAML or JSON → XML.

JSON → CSV FAQ

Privacy and usage

What does “CSV conversion only supports objects or arrays of objects” mean?

A primitive at the top level has no columns. Wrap it in an object with a key.

What happens to commas inside strings?

Fields are quoted as RFC 4180 describes when needed.

Is there a row limit?

Browsers struggle with very large CSV files, so split heavy workloads before converting.

Can I automate this through an API?

Not through FastMinify. Reuse the logic of json-converter.ts locally in your pipelines.

Convert JSON to YAML, XML, CSV, TOML, TSV, SQL, HTML, Properties and INI. Every converter runs in your browser.