Converter

JSON ⇄ CSV

Turn an array of JSON objects into a spreadsheet-ready CSV, or a CSV back into JSON. Nested objects flatten to dot-notation columns and the header is the union of every row’s keys.

Input
Waiting for input.
Output

CSV parsing follows RFC 4180 — quoted fields, escaped quotes and embedded newlines all round-trip. ⌘/Ctrl + Enter runs it again. Everything happens in this browser — nothing is uploaded.

About the JSON ⇄ CSV converter

Spreadsheets are still how most of the world looks at data. This converts an array of JSON objects into a CSV whose header is the union of every row's keys — so a field that only appears in later rows still gets a column — and converts CSV back to JSON, rebuilding nested objects from dot-notation headers. Quoting, escaped quotes and embedded newlines follow RFC 4180 in both directions.

How to use it

  1. Paste a JSON array (or a CSV table — the direction is detected automatically).
  2. Choose the delimiter, and whether nested keys are flattened and CSV values type-inferred.
  3. Copy the output or download it. Tick "Excel BOM" if Excel mangles your accented characters.

Questions

My JSON is nested — what happens to it?

Nested objects flatten to dot-notation columns such as address.city, and convert back into nested objects on the way in. Arrays inside a row are kept as JSON text in the cell.

Will it open correctly in Excel?

Yes. If accented or non-Latin characters look wrong, tick "Excel BOM" — that adds the byte-order mark Excel looks for.

Does it handle commas and quotes inside values?

Yes, in both directions: fields containing a delimiter, quote or newline are quoted and escaped per RFC 4180, and parsed back the same way.