JSON to CSV Converter
Convert a JSON array of objects to CSV, with nested fields flattened automatically
What is JSON to CSV Converter?
This JSON to CSV converter turns an array of objects into tabular text: nested objects are flattened into dotted column names such as a.b, and array values are serialized as JSON strings. Comma, semicolon, and tab delimiters are all supported, and the conversion runs locally in your browser.
How to use JSON to CSV Converter
- 1Paste an array of objects. A single top-level object is treated as one row.
- 2Pick a delimiter. Comma is the safest choice if the file is headed for Excel.
- 3Turn off "Output header" when you want raw data rows with no header line.
- 4Copy the result and save it as a .csv file to open it in any spreadsheet app.
Common errors and how to fix them
| Symptom | Cause | Fix |
|---|---|---|
| Non-ASCII characters look garbled when the file is opened in Excel | Excel reads CSV files using the system locale encoding, but the output is UTF-8. | Add a UTF-8 BOM at the start of the file when you save it, or import it through Data → From Text/CSV in Excel and select UTF-8 explicitly. |
| A column is filled with [object Object] | That field holds a nested object that was never flattened. | This tool flattens nested objects into a.b column names automatically. If you still see it, the value is a function or a circular reference, so clean up the data first. |
Frequently asked questions
What happens when the objects have different sets of fields?+
The tool scans every object first and uses the union of all keys as the full column set, leaving a blank cell wherever a row is missing a field. Ragged data therefore still produces a well-formed table with no misaligned columns.
Will leading zeros be stripped from numbers?+
Not by the converter, which writes every value out exactly as it appears. Spreadsheet software is the usual culprit: it often reads 007 as a number on import and drops the zeros. Set that column to Text in the import dialog to keep them.
Related tools
All toolsJSON to YAML Converter
Convert JSON to YAML while preserving the nesting
YAML to JSON Converter
Convert YAML to JSON, multi-document files included
CSV to JSON Converter
Convert CSV to JSON with automatic header and delimiter handling
JSON to TypeScript
Infer TypeScript type definitions from JSON
JSON to Go Struct
Convert JSON to Go structs with json tags filled in
JSON to Python Dataclass
Convert JSON to Python dataclasses or Pydantic models