JSON to CSV
Convert JSON or NDJSON to CSV in your browser. Nested objects become columns. Arrays of objects become rows. Nothing is uploaded.
Paste JSON, then Convert to CSV.
How to convert JSON to CSV
- Paste JSON or NDJSON, or open a
.json/.ndjsonfile. - Click Convert to CSV. Nested fields become dotted columns such as
customer.email. - Download
data.csvor copy the CSV for Excel, Google Sheets, or a database import.
Flatten nested JSON into columns
CSV is a table. A nested object cannot sit in one cell without turning into [object Object] or a JSON blob. This converter flattens objects with dot notation: customer.name and customer.email become two columns. That is the JSON-to-CSV conversion people need for Stripe, GitHub, and other API dumps.
Arrays of objects become rows
An array of records — orders, events, users — becomes one CSV row each. Nested arrays of objects (line items on an order) expand into extra rows, with the parent fields repeated. Arrays of tags or IDs stay in one cell, joined with semicolons, so the table does not explode sideways.
NDJSON to CSV
Newline-delimited JSON (JSON Lines) is common in logs and exports: one object per line, not one giant array. If the paste is not a single JSON value, this tool parses each line and converts those records to CSV the same way.
Nothing is uploaded
Conversion runs in this tab. Your JSON is not posted to Geek University. Typical payloads up to 1.5 MB, 10,000 rows, and 200 columns are supported. The download includes a UTF-8 BOM so Excel opens the file without mangling non-English text.
Need pretty-print instead? Use the JSON formatter. Trailing commas or comments? Use the JSON fixer. Messy spreadsheets go to the CSV cleaner. More utilities live on tools.
JSON to CSV FAQ
Does this JSON to CSV converter upload my file?
No. Flattening and CSV encoding run in your browser. The JSON never leaves your machine.
How do you flatten nested JSON?
Nested objects become dotted column names such as user.email. Arrays of objects become extra rows. Arrays of strings or numbers stay in one cell, separated by semicolons.
Can I convert NDJSON or JSON Lines to CSV?
Yes. If the text is not a single JSON document, each non-empty line is parsed as its own object and written as a row.
Will Excel open the CSV correctly?
The download is UTF-8 with a BOM, which Excel expects for international characters. Values that look like formulas are quoted so they stay text.
Is JSON to CSV free?
Yes. There is no account. Use it for API responses, config exports, and log extracts within the size limits above.