input
output
Convert a JSON array of objects to CSV, or paste CSV to convert it back to JSON.

Related

Guides for JSON to CSV

All guides →

Convert JSON to CSV and CSV to JSON

Paste a JSON array of objects and click To CSV to get a spreadsheet-ready table — the header row is the union of every object's keys, and nested objects or arrays are written into the cell as compact JSON. Paste CSV and click To JSON to turn each row into an object keyed by the header. Everything runs in your browser; no data is sent to any server.

Whether you call it json format to csv, convert json into csv, a json-to-csv converter, a csv to json converter, or simply CSV export, both directions are covered in one tool.

How the conversion handles edge cases

  • Quoting — values containing commas, quotes, or newlines are wrapped in double quotes, and embedded quotes are doubled, per the usual CSV rules
  • Missing keys — when objects have different keys, every key becomes a column and absent values are left blank
  • Nested data — objects and arrays inside a field are serialised as JSON text in the cell
  • Type coercion — going CSV → JSON, unambiguous numbers, true/false, and null are converted; everything else stays a string

If your JSON has syntax errors, the tool repairs common mistakes before converting. For a full walkthrough see How to Convert JSON to CSV (and Back), or use JSON Fix to clean the JSON first.

FAQ

How are nested JSON objects represented in CSV?

Each nested object or array is serialised as JSON text inside its cell. CSV is flat, so this keeps the conversion reversible. The header is the union of all object keys, so records with extra or missing fields still line up.