JSON to CSV Converter
Turn a JSON array into a CSV table, or a CSV file into JSON. More data tools
Convert JSON to CSV and CSV to JSON
Paste an array of objects to get CSV that opens in Excel or Google Sheets. Nested objects are flattened into columns such as address.city, and every key that appears in any item becomes a column.
In the other direction, CSV to JSON reads the first row as headers, detects numbers and booleans, and can rebuild nested objects from dotted headers. Choose comma, semicolon, tab or pipe as the delimiter.
Features
- Live: the result updates while you type.
- Clear errors: the line, the reason and, where possible, a one-click fix.
- Open and drop files, copy or download the result, and share your input as a link.
- Send to another tool: pass the result straight to a related tool.
- Private: Everything runs in your browser. Your data is not uploaded to any server.
Related data tools
- JSON to YAML: Convert JSON to YAML or YAML to JSON. Use Swap to go the other way.
- JSON to TOML: Convert JSON to TOML or TOML to JSON.
- XML to JSON: Convert XML to JSON or JSON to XML. Errors show the exact line.
- SQL to JSON: Paste INSERT statements and get JSON rows.
- All DataMint tools
Frequently asked questions
How are nested objects handled?
They are flattened into dotted columns. Turn flattening off to keep them as JSON text in one cell.
Will Excel open it?
Yes. Use the Download button and open the .csv file. Choose semicolon if your Excel uses it as the list separator.
What if some items have extra keys?
Every key becomes a column and missing values are left empty.
Is my data private?
Everything runs in your browser. Your data is not uploaded to any server. You can even use the tool offline once the page has loaded.