Convert JSON to CSV
Turn a JSON array into a spreadsheet-ready CSV.
JSON to CSV Converter
Developer tool running locally in browser
What does JSON to CSV Converter do?
Convert an array of JSON objects into CSV, flattening nested objects into dotted column names. You choose the delimiter, quoting style and which columns to include, and the output opens cleanly in Excel and Google Sheets.
How to Use JSON to CSV Converter
- 1Paste a JSON arrayAn array of objects is the expected shape.
- 2Review the detected columnsDeselect any you do not want.
- 3Choose a delimiterSemicolon suits locales where the comma is a decimal point.
- 4Download the CSVIt opens directly in Excel or Sheets.
Key Features
- Nested objects flattened into dotted column names
- Arrays joined with a separator you choose, or expanded into numbered columns
- Comma, semicolon, tab or pipe delimiter
- Column picker so you export only what you need
- UTF-8 BOM added on download so Excel reads accents correctly
- Live preview table before you export
Frequently Asked Questions
How are nested objects handled?
They are flattened using dot notation, so {"user":{"name":"Ada"}} becomes a column called user.name. Nesting of any depth is supported.
What happens to arrays inside my objects?
By default they are joined into one cell with a separator. You can switch to expansion mode, which creates numbered columns such as tags.0 and tags.1.
Why do accented characters look wrong in Excel?
Excel assumes the system codepage unless the file starts with a UTF-8 byte order mark. The download includes one, so accents display correctly.
Do objects need identical keys?
No. Every key found anywhere in the array becomes a column, and objects missing that key get an empty cell.
Input is processed in your browser and never transmitted. That said, treat any web page as untrusted for live production secrets — rotate anything you paste anywhere.
Related Tools
CSV to JSON Converter
Convert CSV or spreadsheet data into clean JSON.
JSON Formatter
Format, validate and explore JSON with precise error reporting.
JSON to YAML Converter
Convert JSON into readable YAML for configuration files.
JSON Minifier
Strip whitespace from JSON to make it as small as possible.