JSON to CSV

Paste a JSON array of objects. Get clean CSV with proper quoting. Nested objects become JSON-encoded cells.

Runs in your browser. Nothing is uploaded.
JSON in
CSV out

JSONYard's online JSON to CSV converter turns a JSON array of objects into a flat CSV table with RFC 4180-compliant quoting. It preserves first-seen key order, handles missing keys with empty cells, and runs entirely in your browser.

How it works

The converter expects either a single object or an array of objects. It collects every key (in the order they first appear), uses those as the header row, and writes one row per object. Nested objects and arrays are stored as JSON-encoded strings — CSV is flat by design, so true nested CSV doesn't exist.

Picking a wire format for your service? See JSON vs YAML vs XML: when to use which for the practical tradeoffs.

String values that contain commas, quotes, or newlines are wrapped in double quotes and internal quotes are doubled, per RFC 4180.

Convert JSON to a spreadsheet or Excel file

CSV is the universal handshake between web APIs and spreadsheets. Once you've converted JSON to CSV, you can open the file in Excel, Google Sheets, Numbers, or any data tool that imports tabular data. If your JSON is deeply nested, see the longer walkthrough on converting JSON to CSV without losing nested data — there are four strategies and only one is right for any given dataset.

FAQ

What if my objects have different keys?
The header includes every key that appears in any object. Rows that don't have a key get an empty cell.
How are nested objects handled?
They become JSON-encoded strings in their cell. Flattening nested objects to dot-delimited columns is on the roadmap.
Does this open in Excel correctly?
Yes — comma-delimited, double-quote escaped. If Excel reads it as a single column, your regional separator may be semicolon — open it via "From Text/CSV" and pick comma.
How do I convert JSON to CSV online without uploading?
That's how this converter works. Paste your JSON and conversion happens in your browser — no server, no logging, no signup.
Can I go back from CSV to JSON?
Yes — use the CSV to JSON converter. It infers types (numbers, booleans, null) and follows RFC 4180.

Related conversion tools

CSV to JSON

Round-trip back: turn CSV rows into a JSON array of objects with type inference.

JSON to XML

Convert JSON to XML using @attribute and #text conventions for legacy systems.

JSON Formatter & Viewer

Pretty-print and explore your JSON before flattening it to a spreadsheet.