JSON to CSV Converter — CSV to JSON

input

[
  { "id": 1, "name": "Ada Lovelace", "active": true },
  { "id": 2, "name": "Bob Khan", "active": false },
  { "id": 3, "name": "Carol Diaz", "active": true }
]

output

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

Guides for JSON to CSV

All guides →

Guide

JSON Interop: YAML, CSV, XML, JWT, Schema

JSON rarely lives alone. Convert between JSON and YAML/CSV/XML, decode JWTs, generate types, and validate against JSON Schema — every step staying in the browser.

Guide

Convert JSON to CSV: Flatten an Array of Objects

A JSON array of objects maps to a CSV table — one row per object, columns from the union of keys. The real work is quoting and handling nested values.

Guide

Fix Trailing Comma in JSON

A trailing comma after the last object property or array item is valid in some JavaScript contexts, but it is not valid JSON.

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.