JSON to CSV Converter

Paste a JSON array and download a clean CSV file ready for spreadsheets.

Convert a JSON array of objects or arrays into a CSV file. Pick the delimiter and whether to include a header row. Handles unioned keys across rows so no column is silently dropped.

How it works

  1. Paste your JSON array into the editor.
  2. Pick the delimiter and whether to include a header row.
  3. Unlock the result and download the .csv file.

Use cases

  • Turn an API JSON response into a CSV for a spreadsheet.
  • Export a JSON dataset as CSV for a business analyst.
  • Convert MongoDB or Firebase output to CSV for Excel.
  • Prep a JSON list for import into a CRM that expects CSV.

Frequently asked questions

What JSON shape do I need?

A top-level JSON array. Each item can be an object (keys become column headers) or an array (positional values). Mixed objects/arrays in one input aren't supported.

What if my objects have different keys?

We take the union of all keys across the array, so a column that only appears in later objects still becomes a CSV column. Empty cells are written for rows that don't have that key.

Are special characters quoted correctly?

Yes. Values containing the delimiter, quotes, or line breaks are wrapped in quotes and internal quotes are doubled (the standard RFC 4180 behaviour).

Is there a size limit?

Up to 2 MB of JSON per conversion, plenty for most real-world exports.

How long is the result kept?

The .csv file is auto-deleted after 7 days. Re-download is available during that window via the secure link.

Related tools

ToolsForOneToolsForOne