What is JSON to CSV?
JSON to CSV takes a JSON array of objects and converts it to a CSV file with each object as a row and each key as a column header. Nested objects can be flattened and you can pick exactly which columns to include.
Your JSON data is processed entirely in the browser. Nothing is uploaded to any server.
Handling Nested Data
Flat Objects
Direct key-value pairs become columns directly — no special handling needed.
Nested Objects
Toggle flattening to expand nested objects into columns with dot notation: address.city, address.zip.
Array Values
Arrays inside objects can be serialized as JSON strings in the cell, or each item output as separate rows.
How to Use JSON to CSV
Paste JSON
Paste your JSON array into the input. Syntax errors are highlighted immediately.
Set options
Toggle nested object flattening and select your preferred CSV delimiter.
Pick columns
Deselect any columns you don't want in the output using the column picker.
Download or copy
Click Download to save the .csv file, or Copy to grab the CSV text.
Example Conversion
Input JSON:
[
{ "name": "Alice", "age": 28, "address": { "city": "Mumbai" } },
{ "name": "Bob", "age": 34, "address": { "city": "Delhi" } }
]Output CSV (with flattening):
name,age,address.city
Alice,28,Mumbai
Bob,34,DelhiTips & Common Mistakes
Excel in some regions uses semicolons. If you open the CSV in Excel and see all data in one column, switch the delimiter to semicolon — common in German, French, and other European locales.
Inconsistent keys across objects cause empty cells. If some objects have more keys than others, missing values become empty cells in the output. This is expected CSV behavior.
Related Tools
- CSV to JSON — reverse conversion
- JSON Formatter — beautify source JSON first
- JSON Validator — validate before converting