JSON to CSV

Convert a JSON array of objects to CSV. Nested objects are flattened via dotted keys (user.address.city). Configurable delimiter and quote handling. Runs in your browser.

How to use the JSON to CSV

Paste an array of JSON objects. The tool builds the header row from the union of all object keys, then writes one row per object. Nested objects flatten via dotted keys; arrays become JSON-encoded string fields. The delimiter and quoting follow RFC 4180.

Converting a JSON array to CSV

Hand a non-developer a JSON array and they are stuck; hand them a CSV and it opens in any spreadsheet. The catch is that JSON is hierarchical and CSV is flat, so a nested object or an embedded array has no obvious home in a grid of rows and columns.

This converts an array of JSON objects to CSV, flattening nested objects into dotted-key columns like user.address.city and quoting fields per RFC 4180 so the result imports cleanly. For the reverse trip the CSV to JSON converter parses CSV back into objects; when you need to choose, reorder, or rename the columns rather than emit them all, the JSON array to CSV tool adds that control.

Common use cases

  • Open in a spreadsheet — turn an API array into a file Excel or Sheets can read.
  • Share with non-devs — hand over data without exposing raw JSON.
  • Flatten nesting — spread nested objects across dotted-key columns.
  • Bulk import — prepare a CSV for a tool that ingests tabular data.
  • Report data — convert query output into a CSV for a report.

Frequently asked questions

How are nested objects handled?
They are flattened into columns with dotted keys such as user.address.city; embedded arrays become JSON-encoded string fields.

How is the header row built?
From the union of all keys across the objects, so a field missing on some rows still gets a column.

Does it follow a CSV standard?
Yes — quoting and escaping follow RFC 4180, and the delimiter is configurable.

Can I pick which columns to export?
For column selection, reordering, and renaming use the JSON array to CSV tool.
Embed this tool on your site

Free to embed, no attribution required (but appreciated). Paste this where you want the tool to appear: