JSON to TSV Converter
Convert a JSON array, a single object, or NDJSON to tab-separated values. The Tab delimiter is preselected, nested keys flatten into documented dot and bracket headers, and the result pastes cleanly into Excel or Google Sheets. Nothing you paste leaves your browser.
Worked example
[{"id":1,"name":"Ada"},{"id":2,"name":"Grace"}]becomes
id name 1 Ada 2 Grace
Each top-level key becomes a column and cells are separated by tab characters. Spreadsheets split tab-separated text into columns on paste, which is why TSV is the clipboard format they use.
Frequently asked questions
Why use TSV instead of CSV?
Tab-separated values are what spreadsheets read from and write to the clipboard, so TSV pastes straight into Excel or Google Sheets with the columns already split. Values containing commas also need no quoting in TSV; only a literal tab does.
How do I paste JSON data into Excel or Google Sheets?
Convert the JSON here with the Tab delimiter, copy the output, and paste it into the sheet; each tab starts a new column and each line a new row. You can also download the result as a .tsv file and open it.