What if the JSON has nested objects?

Flattened by default with dot-notation headers (`user.address.city`). Toggle 'top-level only' to keep nested objects as JSON-stringified cell values.

How are arrays handled?

Arrays of objects produce one row per element. Arrays of primitives get joined by a configurable separator (`;` or `|`) into a single cell.

Does it add a header row?

Yes by default — collected from all unique keys across records. Toggle off for headerless output when feeding a system that provides its own column definitions.

What about quoted values?

Strings containing commas, quotes, or newlines are automatically quoted and inner quotes doubled per RFC 4180. Safe to use with Excel, Google Sheets, and any spec-compliant parser.

JSON to CSV | DevTools Surf

DevTools Surf

Example: JSON to CSV

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

[{"name":"Alice","email":"alice@example.com","age":30},{"name":"Bob","email":"bob@example.com","age":25},{"name":"Charlie","email":"charlie@example.com","age":35}]

Output

name,email,age
Alice,alice@example.com,30
Bob,bob@example.com,25
Charlie,charlie@example.com,35

About JSON to CSV

Convert JSON array to CSV format. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

Use Cases

Data analysts converting JSON API data for Excel analysis
Business users transforming JSON reports into spreadsheet format
Data scientists preparing JSON datasets for CSV-based ML tools
Marketing teams converting JSON analytics exports for pivot tables

Tips

Flatten nested JSON objects before conversion for best results
Check that array values are properly delimited in CSV cells
Verify that commas within string values are properly escaped

Fun Facts

CSV is one of the oldest data formats still in use, with its origins tracing back to IBM Fortran in 1972.
Despite its simplicity, CSV has no universal standard; RFC 4180 (2005) is the closest thing to an official specification.
Excel can import CSV files with up to 1,048,576 rows and 16,384 columns, matching its worksheet limits.

FAQ

What if the JSON has nested objects?: Flattened by default with dot-notation headers (`user.address.city`). Toggle 'top-level only' to keep nested objects as JSON-stringified cell values.
How are arrays handled?: Arrays of objects produce one row per element. Arrays of primitives get joined by a configurable separator (`;` or `|`) into a single cell.
Does it add a header row?: Yes by default — collected from all unique keys across records. Toggle off for headerless output when feeding a system that provides its own column definitions.
What about quoted values?: Strings containing commas, quotes, or newlines are automatically quoted and inner quotes doubled per RFC 4180. Safe to use with Excel, Google Sheets, and any spec-compliant parser.

Related Converters Tools

JSON to XML JSON to YAML JSON to TSV JSON to String XML to JSON XML to CSV XML to String XML to YAML