JSON to CSV

Interactive Studio

Convert JSON arrays and nested objects into clean CSV or TSV with deep key flattening, configurable quoting, custom delimiters, and live table preview. Instant feedback with zero server storage.

Samples:

JSON Raw Input

3 records detected

CSV Separator / Delimiter

Field Quoting Policy

Flatten nested keysInclude header row

id,name,email,role,address.city,address.state,address.country,stats.completedTasks,stats.rating,active
usr_101,Elena Rostova,elena@example.com,Lead Engineer,San Francisco,CA,USA,142,4.9,true
usr_102,Marcus Vance,marcus@example.com,Product Designer,London,England,UK,89,4.8,true
usr_103,Sarah Chen,sarah@example.com,Data Scientist,Toronto,ON,Canada,210,5,false

Total Columns

Total Rows

Delimiter

Loading tool…

About JSON to CSV

Converting structured JSON into CSV allows developers and analysts to easily open API responses in Excel, Google Sheets, or business intelligence pipelines. This studio supports deep nested object flattening (`user.address.city`), custom field delimiters, quoting policies, and union column discovery across inconsistent arrays.

How to use JSON to CSV

Paste a JSON array of objects.
Choose the delimiter and quoting style.
Nested objects are flattened into dotted column names, and missing keys across rows get empty cells.
Copy the CSV or download it for Excel or Sheets.

Worked examples

Input: [{"name":"Ada","address":{"city":"Paris"}},{"name":"Lin"}]

Result: Header name,address.city then rows Ada,Paris and Lin, with an empty city for Lin.

Background

CSV is flat while JSON is nested, so the converter flattens nested objects into column names such as address.city. Arrays are harder: they are usually serialized into a single cell or expanded into numbered columns.

The column set is the union of all keys across every row, so rows with fewer fields get blanks. Fields containing the delimiter, quotes or line breaks are quoted so spreadsheets read them correctly.