JSON to CSV Converter
Convert JSON arrays to CSV with delimiter and flattening options.
How it works
- 1
Paste JSON
Paste a JSON array of objects into the input area.
- 2
Configure options
Choose your delimiter, toggle headers, and enable nested object flattening.
- 3
Convert and export
Click Convert and copy or download the CSV result.
Common use cases
Simple array
[{"name":"Alice","age":30},{"name":"Bob","age":25}]
Nested objects
[{"user":{"name":"Alice"},"score":95}]
About This Tool
Paste a JSON array of objects and convert it to CSV (or TSV, semicolon-separated, or pipe-delimited) format. The converter automatically detects all unique keys across objects, handles missing fields gracefully, and can flatten nested objects into dot-notation columns (e.g., address.city).
Array values within objects are serialized as JSON strings in the CSV cell. All CSV values are properly escaped -- fields containing the delimiter, quotes, or newlines are wrapped in double quotes with internal quotes doubled.
Options include: choose delimiter (comma, semicolon, tab, pipe), toggle column headers, and enable/disable nested object flattening. Copy the result or download as a .csv file.
Distinct from the JSON Formatter: the formatter validates and beautifies JSON structure, while this tool transforms JSON data into a tabular CSV format for use in spreadsheets, databases, and data pipelines.
More examples
Examples
Simple array
Input
[{"name":"Alice","age":30},{"name":"Bob","age":25}]Output
name,age Alice,30 Bob,25
Nested objects
Input
[{"user":{"name":"Alice"},"score":95}]Output
user.name,score Alice,95
Frequently Asked Questions
- What JSON structure is supported?
- An array of objects: [{"key":"value"}, ...]. A single object is automatically wrapped in an array. Nested objects are flattened with dot notation (e.g., user.name). Primitive arrays are serialized as JSON strings.
- How are missing fields handled?
- If an object is missing a key that other objects have, the CSV cell is left empty. All unique keys across all objects become columns.
- How is this different from the JSON Formatter?
- The JSON Formatter validates and prettifies JSON. This tool transforms JSON arrays into CSV for spreadsheet import, database loading, or data pipeline processing.
- Can I use this for TSV (tab-separated) output?
- Yes. Select "Tab" as the delimiter to generate TSV output compatible with Excel and Google Sheets paste operations.