JSON to CSV Converter

What is JSON → CSV?

Converting JSON to CSV flattens an array of objects into a spreadsheet-friendly table. It's the fastest way to hand JSON data to non-developers, open API results in Excel or Google Sheets, or bulk-import records into a database. The converter scans every object to build a complete header row, so records with different keys still line up correctly.

How to convert JSON to CSV

1. 1Paste a JSON array of objects (e.g. [{"a":1},{"a":2}]) into the input pane.
2. 2The tool collects all unique keys to form the header row.
3. 3Pick a delimiter — comma, semicolon, tab, or pipe — to match your target program.
4. 4Copy or download the CSV and open it in Excel, Sheets, or your data pipeline.

Use Cases

Code Examples

[
  { "id": 1, "name": "Ada" },
  { "id": 2, "name": "Linus" }
]

id,name
1,Ada
2,Linus

Key Concepts

RFC 4180

The de-facto CSV standard: fields with commas, quotes, or newlines are wrapped in double quotes, and inner quotes are doubled ("").

Delimiter

The character separating fields. Comma is default, but European Excel often expects semicolons because the comma is a decimal separator.

Flattening

CSV is a flat table, so nested objects/arrays are serialized as JSON strings inside a cell. Pre-flatten deep data for clean columns.

Tips & Best Practices

• ▸Excel in some locales expects semicolons, not commas. Switch the delimiter if your columns don't split.
• ▸Nested objects become JSON text in a cell — flatten your data first if you want proper columns.
• ▸Ensure the input is an array of objects; a single object or primitive array won't map to rows cleanly.
• ▸For huge datasets, stream the conversion server-side; browsers slow down past a few hundred thousand rows.