Direct answer
To convert JSON to CSV, paste a JSON array of objects below. Each object becomes one row; the keys of the first object define the column headers.
Ad
JSON input
CSV output
About JSON → CSV
CSV (Comma-Separated Values) is the universal exchange format for tabular data. Spreadsheet apps (Excel, Google Sheets, Numbers), databases, and BI tools all import CSV. Converting from JSON is necessary when piping API responses into spreadsheets, generating reports for non-developers, or feeding data into older systems.
JSON vs CSV
| JSON | CSV | |
|---|---|---|
| Structure | Hierarchical (nested objects, arrays) | Flat (rows × columns only) |
| Type info | Numbers, booleans, null distinct from strings | Everything is text |
| Headers | Implicit from object keys | First row, by convention |
| Best for | APIs, structured data | Spreadsheets, exports, ETL |
Ad
Frequently asked questions
What if my JSON has nested objects?
Nested values get serialized to a string in that cell (e.g. JSON.stringify-style). For deeply nested data, flatten it first or use a tabular schema.
How are special characters handled?
Values containing commas, quotes, or newlines are wrapped in double quotes per RFC 4180. Quotes inside values are escaped by doubling them.
Can I get TSV (tab-separated) instead?
Not in this tool — but find-replace any commas with tabs, or use a spreadsheet app that exports TSV directly.