JSON to CSV Converter
Turn a JSON array into a CSV file you can open in Excel or Google Sheets. Nested objects become their own columns.
JSON Input
Paste a JSON array, or load the sample data
CSV Output
One row per record, one column per key
Convert your JSON to see the CSV output
How to use it
Paste, convert, then copy or download.
Paste your JSON
Paste an array of objects into the input box. An object that contains an array works too.
Convert to CSV
Click Convert to CSV. Invalid JSON shows the parser's error message instead.
Download or copy
Download the result as data.csv, or copy it and paste it straight into a spreadsheet.
Features
How the converter maps JSON to rows and columns.
Nested objects
Nested objects are flattened into dot-notation headers, so address.city gets its own column.
Finding the rows
If you paste an object instead of an array, the first array inside it becomes the rows. Arrays within a record are written as JSON text in one cell.
Safe quoting
Every value is wrapped in double quotes and inner quotes are doubled, so commas and line breaks inside values don't break the file. The download includes a UTF-8 marker so Excel shows accented characters correctly.
Columns from every record
Headers are collected from all records, not just the first. A record without a given key gets an empty cell.
FAQ
Common questions about converting JSON to CSV.
What JSON formats are supported?
An array of objects works best. A single object becomes one row, and an object that wraps an array (like { "users": [...] }) uses that array.
How are nested objects handled?
They are flattened with dot notation. For example, { "address": { "city": "New York" } } becomes a column named "address.city".
Is there a limit to the size of JSON I can convert?
There is no fixed limit, but the conversion runs in your browser, so files of several megabytes can be slow. Keeping input under about 5 MB works best.
Is my data secure?
Yes. The conversion runs in your browser. Your JSON is not sent to a server or stored.
Other JSON tools
Convert JSON to a table or XML, format it, compare two files, or query it with JSONPath.
View All Tools