Free Online JSON to CSV Converter
Flatten nested JSON into a clean CSV spreadsheet ready for Excel or Google Sheets.
About the JSON to CSV Converter
This converter turns JSON data into a CSV table that opens cleanly in Excel, Google Sheets, or Numbers. Nested objects can be flattened into dotted column names, arrays can be joined into a single cell, and the result is quoted so commas and quotation marks survive the trip. It is useful when an API returns JSON but the person who needs the data works in a spreadsheet.
How to use it
- Paste a JSON array, or a single JSON object, into the input box.
- Choose a delimiter: comma, semicolon, or tab.
- Leave Flatten nested keys ticked to turn nested objects into dotted columns.
- Click Convert to CSV, or wait briefly after typing for the automatic conversion.
- Check the row and column badge, then click Copy CSV or Download .csv.
A practical example
The built-in sample contains two people, each with a name, age, a nested address, and a tags array. With
flattening on, the address becomes address.city and address.country, while the tags
become one cell such as math | code. A single top-level object is treated as one row, and a plain
array of values becomes a single "value" column, so you do not need to wrap everything in an array yourself.
Format rules, limits, and privacy
The input must be valid JSON; syntax errors stop the conversion and report the parser message. Flattening applies to nested objects only. Arrays are joined with a vertical bar, and objects inside an array are stringified rather than expanded into columns. Every field is wrapped in double quotes, with internal quotes doubled, which keeps commas safe but means numbers and dates are exported as text. Column order follows the first time each key appears, and rows that lack a key simply get an empty cell. Everything runs in the page.
Frequently asked questions
What happens to nested arrays?
They are joined into one cell using " | " as a separator. Objects inside the array are converted to JSON text so no data is silently dropped.
Why are all values wrapped in quotes?
Quoting every field is a simple way to protect commas, line breaks, and existing quotes, so the file parses correctly in any spreadsheet app.
Can I convert deeply nested JSON?
Yes, object nesting is flattened to dotted paths. Note that a literal key containing a dot will look the same as a flattened path, so avoid that pattern if it matters.
Related tools: JSON to YAML Converter, SQL Formatter, XML Formatter.