Developer tools
JSON to CSV Converter (and CSV to JSON)
Free, no sign-up, works in your browser. Convert a JSON array into a CSV file you can open in Excel or Google Sheets, or turn CSV back into JSON. Nested objects become columns like user.name, and nothing you paste leaves your device.
Paste an array of objects. Each object becomes a row and each key a column.
Your data stays on your device.
How to use the JSON to CSV Converter
- Choose JSON to CSV or CSV to JSON.
- Paste your data or open a file.
- Check the preview, then copy or download the result.
Frequently asked questions
- What JSON can be converted?
- An array of objects works best: each object becomes a row and each key a column. A single object, or an object holding one array (like an API response), works too.
- What happens to nested objects and lists?
- Nested objects become columns joined with dots, such as address.city. Lists of simple values are joined with commas in one cell; anything more complex is kept as JSON text.
- Excel puts everything in one column. Why?
- In some countries Excel expects semicolons instead of commas. Choose the semicolon separator and open the file again.
- Are numbers kept as numbers when converting CSV to JSON?
- Yes, by default 42 becomes a number and true becomes true. Values with leading zeros, like zip codes, stay as text so nothing is lost.
- Is my data uploaded?
- No. The conversion happens on your device.
- Is the JSON to CSV Converter free?
- Yes. It's free to use, with no sign-up and nothing to install.
Related tools
- CSV to TSV ConverterSwitch delimited data between comma-separated (CSV) and tab-separated (TSV) in one step. Quoted values, commas inside values and line breaks are handled correctly, so no column shifts.
- JSON FormatterPaste JSON to check that it's valid, then format it with clear indentation or minify it to one line. If something is wrong, you see the line and column of the mistake. Your data stays on your device.
- JSON to XML ConverterConvert JSON to well-formed XML, or XML to JSON, with attributes, repeated elements and text kept intact. Errors point to the line that needs fixing.
- YAML to JSON ConverterConvert YAML to JSON or JSON to YAML as you type, with clear errors when the YAML isn't valid. Anchors, multi-line strings and multiple documents are supported.