jsonecho

JSON to CSV

Turn an array of JSON objects into CSV rows with one column per field, ready for Excel or Google Sheets.

Loading the tool...

How to use JSON to CSV

Paste a JSON array of objects, or an object that contains one.
Choose the delimiter. Semicolon is the right pick for Excel in many European locales.
Copy the CSV or download it.

About JSON to CSV

CSV is a flat table. JSON is a tree. To bridge the two, this tool finds the list of records in your JSON, then writes one row per record and one column per key. Nested objects are flattened using dots, so {"address":{"city":"Hamburg"}} becomes a column named address.city. Arrays inside a record get indexed columns such as items[0].sku.

If your document is an object with a single array inside, like {"users":[...]}, the array is used automatically. Columns are collected across all records, so a field that only shows up in some of them still gets its own column and the missing cells stay empty.

Frequently asked questions

Which delimiter should I choose for Excel?

It depends on the language settings of the computer. In Germany, Turkey and much of Europe, Excel expects semicolons. In the US and UK it expects commas. If the whole row lands in one column, switch the delimiter.

What if my JSON is an object, not an array?

A single object becomes a table with one row. If the object holds exactly one array, we use that array as the rows instead.

What does "Flatten nested data" do?

When it is on, nested objects and arrays are spread across several columns with dotted names. When it is off, nested values are kept as JSON text inside a single cell.

Will commas and line breaks inside values break the CSV?

No. Fields that contain the delimiter, quotes or line breaks are wrapped in double quotes, with inner quotes doubled, as the CSV standard requires.

Can I get an Excel file instead?

Yes. The JSON to Excel tool produces a real .xlsx file with a bold header row.

More in Converters

All tools →

JSON to XMLConvert JSON to indented XML with a custom root element.Convert JSON to StringConvert JSON into an escaped string for code and configs.Convert String to JSONUnescape a JSON string and format it as readable JSON.Convert JSON to Markdown TableConvert JSON into a neatly aligned Markdown table.Convert XML to JSONConvert XML to JSON, keeping attributes and repeated elements.Convert XML to CSVConvert repeating XML elements to CSV rows.Convert XML to YAMLConvert XML to readable YAML.Convert XML to StringConvert XML into an escaped single-line string.Convert