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.