What happens to arrays inside my objects?

An array of simple values is joined into one cell, separated by semicolons — `["a","b"]` becomes `a; b`. Arrays of objects get one column per index, like `items[0].name`. Exploding a scalar array into separate columns would make the column set depend on whichever record happens to have the most items.

Why do some rows have empty cells?

Because JSON objects in an array don't all have to carry the same keys, but a CSV row does. Any object missing a field gets an empty cell for it. That's the correct translation — the alternative is dropping the column, which loses the data from the objects that do have it.

Will Excel open the result correctly?

Yes for comma-separated files in most locales. If your Excel is set to a locale that uses the comma as a decimal separator — much of Europe — choose semicolon instead, or Excel will put the whole row in one cell.

JSON to CSV Converter

Turn a JSON array into a CSV you can open in a spreadsheet. Nested objects are flattened into dotted column names — `address.city` rather than a column full of unreadable JSON — and columns are collected from every object in the array, not just the first, so a field that only appears halfway down the file still gets a column instead of being silently dropped.

Your text

Delimiter

Include a header row

Result

Nothing is uploaded — this tool runs inside your browser, so your files never leave your device.

Help us improve

Why use this tool

Flattens nested objects into dotted column names
Collects columns from every object, not only the first one
Quotes and escapes any value containing a comma, quote or line break
Comma, semicolon, tab or pipe output

How it works

1Paste a JSON array — or a single object, which becomes one row.
2Pick the delimiter your spreadsheet expects.
3Copy or download the CSV.

JSON to CSV Converter — frequently asked questions

By flattening them into dotted paths, so `{"address":{"city":"London"}}` becomes a column called `address.city`. CSV is a flat format and there is no honest way around that — the alternative, dumping raw JSON into a cell, produces a spreadsheet nobody can filter or sort.

More developer tools

Text → Base64 Base64 → Text URL Encoder URL Decoder JSON Formatter JSON Minifier

Looking for something else? Browse all developer tools

Explore the other tools

Same deal everywhere on the site — free, no sign-up, and no watermark on anything you download.

QR Code Tools Barcode Tools PDF Tools Image Tools SEO Tools Text Tools Calculators Unit Converters Color Tools File Tools Business Tools AI Tools Utilities

Or see every tool on one page.