JSON to CSV Converter

Convert structured JSON arrays or nested object lists into clean, RFC 4180 compliant CSV tables with interactive grid previews.

Delimiter:

Flatten Nested Objects (dot notation)Force QuotesInclude Header Row

Samples:

Source JSON Arrayjson

[
  {
    "id": 101,
    "name": "Sarah Connor",
    "email": "sarah@cyberdyne.org",
    "department": "Security Ops",
    "role": "Lead Architect",
    "active": true,
    "salary": 165000,
    "address": {
      "city": "Los Angeles",
      "state": "CA",
      "zip": "90001"
    }
  },
  {
    "id": 102,
    "name": "John Reese",
    "email": "john.reese@fbi-covert.gov",
    "department": "Field Intelligence",
    "role": "Specialist",
    "active": true,
    "salary": 142000,
    "address": {
      "city": "New York",
      "state": "NY",
      "zip": "10007"
    }
  },
  {
    "id": 103,
    "name": "Harold Finch",
    "email": "h.finch@ift.net",
    "department": "Software Engineering",
    "role": "Founder",
    "active": false,
    "salary": 220000,
    "address": {
      "city": "New York",
      "state": "NY",
      "zip": "10014"
    }
  },
  {
    "id": 104,
    "name": "Root Grove",
    "email": "root@analog-interface.io",
    "department": "Security Ops",
    "role": "Adversarial Tester",
    "active": true,
    "salary": 185000,
    "address": {
      "city": "Chicago",
      "state": "IL",
      "zip": "60601"
    }
  }
]

58 lines1155 chars1.1 KB

Ready•json

Generated CSV Outputcsv

id,name,email,department,role,active,salary,address.city,address.state,address.zip
101,Sarah Connor,sarah@cyberdyne.org,Security Ops,Lead Architect,true,165000,Los Angeles,CA,90001
102,John Reese,john.reese@fbi-covert.gov,Field Intelligence,Specialist,true,142000,New York,NY,10007
103,Harold Finch,h.finch@ift.net,Software Engineering,Founder,false,220000,New York,NY,10014
104,Root Grove,root@analog-interface.io,Security Ops,Adversarial Tester,true,185000,Chicago,IL,60601

5 lines475 chars475 B

Ready•csv

Live CSV Table Preview4 records (10 columns)

#	id	name	email	department	role	active	salary	address.city	address.state	address.zip
1	101	Sarah Connor	sarah@cyberdyne.org	Security Ops	Lead Architect	true	165000	Los Angeles	CA	90001
2	102	John Reese	john.reese@fbi-covert.gov	Field Intelligence	Specialist	true	142000	New York	NY	10007
3	103	Harold Finch	h.finch@ift.net	Software Engineering	Founder	false	220000	New York	NY	10014
4	104	Root Grove	root@analog-interface.io	Security Ops	Adversarial Tester	true	185000	Chicago	IL	60601

Showing 1 - 4 of 4 preview rows

Page 1 of 1

How JSON to CSV Flattening Works

Dot Notation Key Flattening

Nested properties like "user": { "city": "SF" } are recursively normalized into flat spreadsheet headers like user.city for seamless Excel and pandas analysis.

RFC 4180 Escaping Compliance

Cells containing commas, double quotes, or embedded line breaks are automatically wrapped in double quotes with quote-doubling escape sequences, preventing corrupted row shifts in downstream parsers.

Flexible Delimiters

Easily switch between standard commas, European semicolons (;), tab-separated values (TSV), and custom pipe characters (|).