DataFormatter

JSON to CSV Converter

Convert an array of JSON objects into clean CSV. Paste your data above and it converts instantly — one header column per key, quoted and escaped cells, empty cells for missing fields. Ready to copy into Excel, Airtable or BigQuery, all processed entirely in your browser.

About this tool

What is it?
DataFormatter JSON to CSV Converter is a free online tool that flattens an array of JSON objects into clean CSV with one header column per key, quoted cells and empty cells for missing fields.
Who is it for?
Developers and analysts exporting JSON API data for Excel, BigQuery or spreadsheet workflows.
What makes DataFormatter's tool different?
Conversion runs entirely in the browser — nothing is uploaded — and output is ready to paste into a spreadsheet.

Input

Paste or type JSON, Base64, or plain text…

Paste or click a sample above — it will be detected automatically.

Quick start

  1. Paste an array of JSON objects (for example an API response) into the editor — it converts to CSV automatically.
  2. Check the header row: one column per key found across your objects.
  3. Use Copy to grab the CSV, or Download to save it as a .csv file.
  4. Open it in Excel, Airtable or your database's import tool.

What converts cleanly

  • The top-level value must be an array of objects — single objects or nested structures are rejected with a clear message.
  • One header column per unique key, gathered from every object in the array.
  • Missing keys become empty cells, keeping every row the same width.
  • Strings with commas, quotes or newlines are quoted and escaped per RFC 4180.
  • Objects and arrays inside a cell are kept as compact JSON text so no data is lost.

JSON to CSV example

JSON input
[{ "name": "Ada", "city": "London", "tags": "admin" }, { "name": "Grace", "city": "New York", "tags": "dev" }]
CSV output
name,city,tags
Ada,London,admin
Grace,New York,dev

Handy for

Migrating API data into a spreadsheet

Export a project list, an order history or a user dump from an endpoint, paste it here, and hand the resulting CSV to a stakeholder who lives in Excel.

Importing into Airtable, BigQuery or Postgres

Database and BI tools love CSV. Flatten your JSON response to rectangles and import it with COPY, the BigQuery web UI, or Airtable's importer.

Building fixtures for data pipelines

Mock pipelines read CSV tables. Generate a stable, rectangular table from your real JSON so your loader has realistic input during development.

CSV surprises

JSON to table requires the top-level value to be an array of objects

Why: You pasted a single object (or a nested structure) instead of a flat array of records.

Fix: Wrap the object in brackets — or extract the array field from the response before converting.

Some rows are missing values

Why: Not every object has every key, so the union header produces blank cells.

Fix: If a strict importer rejects blanks, add the missing keys (set to null) so the table is rectangular.

A value shows up quoted in a strange way

Why: The cell needed escaping because it contains a comma, quote or line break.

Fix: That is correct RFC 4180 behavior — Excel and most importers unquote it transparently.

Pro tips

  • Keep your objects shallow for the cleanest tables — deeply nested values stay readable but appear as JSON text in the cell.
  • Compare CSV and TSV in the same converter hub when a tool complains about one delimiter.
  • Use the JSON Converters hub for Excel-ready HTML, XML and key/value text variants of the same data.
  • Nothing you convert here is sent anywhere, so real customer data is safe to use.

Frequently asked questions

How does this tool turn JSON into CSV?

It collects the keys from every object in your array, builds one header column per key, then emits one row per object. Values that need it are quoted and internal quotes are doubled, so the result parses cleanly in Excel, Airtable and BigQuery.

What JSON can it convert?

The top-level value must be an array of objects — for example an API response array or an exported collection. Single objects and deep nested structures produce a clear error instead of garbage output.

What happens to nested objects and arrays inside a row?

A cell that isn't a plain string, number or boolean is embedded as compact JSON text. This preserves the full value while keeping the table shape simple.

Are missing fields dropped or left blank?

Left blank. Columns are the union of all keys across your objects, so a row missing a key simply has an empty cell — this is what most import tools expect.

Is my data uploaded anywhere?

No. The conversion runs entirely in your browser — the JSON you paste never leaves this page.

What about CSV and TSV files with unusual escaping?

Proper CSV escaping (commas, quotes and newlines inside quoted cells) is handled automatically. If you need tab-separated output instead, switch to the same converter's TSV mode in the JSON Converters hub.

Related tools