Between JSON and spreadsheets
Paste an array of JSON objects and get CSV with a header row built from every key that appears, not just the first object's. Nested objects are flattened into dotted columns (address.city), simple arrays are joined with semicolons, and values containing commas, quotes or line breaks are escaped exactly as Excel and Google Sheets expect. If your JSON wraps the array in an object like {"data": [...]}, the converter finds it automatically.
Switch direction to convert CSV to JSON: the delimiter is detected automatically, numbers and true/false become real JSON types, and dotted column names can be turned back into nested objects. Choose comma, semicolon or tab delimiters, preview the first rows as a table, and download a UTF-8 file that opens correctly in Excel.
How to convert JSON to CSV
- 1
Paste your JSON
An array of objects, or an object containing one.
- 2
Choose the delimiter
Comma, semicolon or tab.
- 3
Check the preview
See the first rows as a table.
- 4
Download or copy
Use the Excel-friendly download for spreadsheets.
Key features
Nested data flattened
Dotted column names for nested objects.
All keys included
Columns come from every row, in order.
Two-way conversion
CSV to JSON with type detection.
Excel-ready
Proper quoting and a UTF-8 byte-order mark.
Common uses
- Exporting API data: Open API results in Excel or Google Sheets.
- Importing spreadsheets: Turn a CSV export into JSON for an app or script.
- Reporting: Share database JSON exports with non-developers.
Tips and good to know
- European versions of Excel expect semicolons; choose the semicolon delimiter if all your data ends up in one column.
- Clean up the JSON first with the JSON Formatter if it won't parse.