JSON to CSV Converter Online — Free & Instant

OpenFormatter's converter infers headers from the union of every key in every row — so no field is silently dropped when later objects have extra properties. Values containing commas, double-quotes, or newlines are escaped per RFC 4180. Nested objects are stringified into their cell as JSON; if you need full flattening, pre-process with jq before pasting.

How to convert JSON to CSV online — 4 steps

1. Paste a JSON array. Copy an API response, database export, or log batch into the Input panel. The top level must be an array — wrap a single object in [ ] if needed.
2. Click Convert. The tool parses the array, computes the header as the union of all keys, and writes RFC 4180 CSV in your browser.
3. Inspect the rows. Row 1 is the header. Each subsequent row maps values in the same column order — empty cells appear where a row was missing that key.
4. Paste into Excel or Sheets. Click Copy and paste into row A1 of a spreadsheet, or save the output as data.csv and double-click to open it.

Sample JSON and CSV output

[
  { "id": 1, "name": "Alice Chen", "email": "alice@example.com", "city": "London" },
  { "id": 2, "name": "Bob Smith", "email": "bob@example.com", "city": "Berlin, DE" },
  { "id": 3, "name": "Carol \"Caz\" Lee", "email": "carol@example.com", "city": "Tokyo" }
]

id,name,email,city
1,Alice Chen,alice@example.com,London
2,Bob Smith,bob@example.com,"Berlin, DE"
3,"Carol ""Caz"" Lee",carol@example.com,Tokyo

Common use cases

• check_circleExporting REST API responses to Excel, Google Sheets, or Numbers for analysis by non-developers
• check_circleBulk-loading JSON records into PostgreSQL, MySQL, or BigQuery via COPY / LOAD DATA from CSV
• check_circleFeeding JSON event logs into BI tools (Tableau, Power BI, Looker) that expect flat tables
• check_circleGenerating CSV fixtures from JSON test data for spreadsheet-based QA workflows
• check_circleProducing CSV deliverables for finance, operations, and customer-success teams from API queries
• check_circleConverting MongoDB aggregation results to CSV for ad-hoc reporting and email distribution
• check_circlePreparing CSV for ML pipelines (pandas, scikit-learn, R) that ingest tabular data more naturally than JSON
• check_circleMigrating data between SaaS platforms whose import/export formats are CSV-only (Mailchimp, HubSpot, Stripe)

CSV vs TSV: which delimiter should you pick?

CSV is the universal default — every spreadsheet, database, and analytics tool reads it. The trade-off is escaping: any value containing a comma must be wrapped in quotes, and any internal quotes must be doubled. If your data is full of free-text fields with commas (addresses, descriptions, product names), TSV — using tab as the delimiter — produces a cleaner, smaller file because tabs almost never appear inside values. For pandas users, both work; pd.read_csv(sep='\\t') reads TSV. Use the JSON to TSV converter if your downstream consumer prefers tabs.