Convert JSON to CSV
Turn a JSON array into a spreadsheet-ready CSV.
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.
Explore Related Workflows & Utilities
More tools in Developer Tools and related problem-solving tools
Direct Workflow Extensions
Convert CSV or spreadsheet data into clean JSON.
Format, validate and explore JSON with precise error reporting.
Open, sort, filter and export CSV files without a spreadsheet.
Convert JSON into readable YAML for configuration files.
Strip whitespace from JSON to make it as small as possible.
Check whether JSON is valid and get the exact error position.
Complementary Utilities across Categories
Topical Deep Dives & Guides
Popular Related Searches for JSON to CSV Converter
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.
CSV Viewer
Open, sort, filter and export CSV files without a spreadsheet.
JSON to YAML Converter
Convert JSON into readable YAML for configuration files.