What shape does my JSON need to be?

An array of objects, where each object is a row. A single object produces one row. Deeply irregular data converts, but the result is a wide table with many empty cells.

What happens to nested objects and arrays?

Nested objects are flattened into dotted column names. Arrays cannot become columns without inventing a structure, so they are written into a single cell — which is honest, if not always useful.

Why do my leading zeros disappear?

The spreadsheet removed them, not the converter. Import the file rather than opening it, and set that column to text.

No. The conversion runs in your browser, which matters given how often this is used on exported customer data.

JSON to CSV Converter

Turns an array of JSON objects into a spreadsheet-ready CSV, flattening nested fields and quoting anything that would otherwise break the columns.

Runs in your browser — nothing is uploaded

JSON

CSV

Your result appears here. Everything runs in your browser.

Need this as an API?

Why use it

Built to be genuinely useful

Quoting done properly

A value containing a comma, a quote or a newline is escaped so the columns survive. This is where hand-rolled conversions usually fail, and the failure is silent.

Nested objects are flattened

A nested address becomes address.city and address.postcode rather than being dropped or stringified into one unreadable cell.

Every key becomes a column

Objects that do not all share the same keys still produce a complete table, with blanks where a record had nothing.

Nothing is uploaded

It runs in your browser. Tokens, keys and customer data routinely end up in these tools, and none of it should have to cross a network to be decoded.

How it works

Three steps

1
Paste an array of JSON objects.
2
Convert.
3
Download the CSV and open it in a spreadsheet.

The escaping that separates a working CSV from a broken one

CSV looks trivial until a value contains a comma. The convention is to wrap such a value in double quotes; a value containing a double quote escapes it by doubling it; a value containing a newline must be quoted or the row splits in two. Get any of those wrong and the file still opens — with the columns shifted from that row onward.

This is the reason to convert with a tool rather than a template string. The failure mode is not an error message, it is a spreadsheet where one customer's address has pushed every subsequent column one place to the right, and nobody notices until a report is wrong.

What a spreadsheet will do to your data

Excel and Google Sheets both interpret cell contents on open. A value like 1-2 may become a date. A long number may be shown in scientific notation. A leading zero on a postcode or a phone number is dropped, because the value looks numeric.

None of this is caused by the CSV — the file is correct — but it is worth knowing before concluding the conversion went wrong. If the values must survive exactly, importing the file rather than opening it lets you set each column's type.

FAQ

Questions people ask

API access

Need JSON to CSV Converter Conversion in Your Application?

Integrate JSON to CSV converter conversion directly into your application, backend or build pipeline through API access.

Tell us what you are building, how you plan to use it and the volume you expect. We will come back to you with availability, integration details and a quote for your usage.

Related tools

More developer tools

Available tools are linked; the rest are in development.

JSON Formatter JSON Validator JSON Minifier CSV → JSON AI Writer AI Summarizer AI Paraphraser AI Humanizer AI Grammar Checker AI Rewriter AI Translator AI PDF Summarizer

All Developer Tools

Need a tool like this for your business?

We build internal tools, dashboards and automation that fit how your team works.

See Our Services