JSON to TSV
Flatten JSON or NDJSON to TSV in your browser. Nested objects become columns. Nothing is uploaded.
Paste, then convert.
How to use the JSON to TSV
- Paste JSON or NDJSON.
- Click Convert to TSV. Nested fields become dotted columns.
- Download data.tsv for Sheets, BigQuery, or a tab-delimited import.
Why TSV
Tabs survive commas inside addresses and notes without as much quoting noise. Flattening matches JSON to CSV: nested objects use dots, arrays of objects expand rows, scalar arrays stay in one cell joined with semicolons.
Nothing is uploaded
Conversion is local. 1.5 MB, 10,000 rows, 200 columns. UTF-8 BOM on the download for Excel.
JSON to TSV FAQ
JSON array vs object?
A root array of records becomes rows. A single wrapper object with one array field unwraps that array.
NDJSON?
One object per line is accepted, same as JSON to CSV.
Need commas instead?
Use JSON to CSV.