What it does
This tool converts a JSON array of objects into TSV (tab-separated values). The first line holds the column names and each following line is one object. Because tabs separate the cells, you can copy the output and paste it straight into a spreadsheet.
How to use
- Paste JSON into the Input box, upload a
.jsonfile, or click Sample. - The TSV appears on the right as you type.
- Turn Include header row off to output only the data.
- Copy and paste into Excel or Google Sheets, or download a
.tsvfile.
Example
[
{ "id": 1, "name": "Alice", "address": { "city": "Shanghai" } },
{ "id": 2, "name": "Bob", "address": { "city": "Beijing, China" } }
]becomes (tabs shown as →)
id→name→address.city
1→Alice→Shanghai
2→Bob→Beijing, ChinaNotes
Values that contain a tab, a line break or a double quote are wrapped in quotes so the spreadsheet still reads them as a single cell. null becomes an empty cell, and true/false and numbers are written as they are.
FAQ
› What JSON structure does it expect?
An array of objects works best, one object per row. An object with a single array property, such as {"data": [...]}, is also understood. Any other value becomes a single row.
› How are nested objects and arrays handled?
Nested fields become dotted column names, such as address.city. Arrays of simple values are joined with "; ", and arrays of objects get index paths such as items.0.name.
› What if objects have different keys?
The columns are the union of all keys in the order they first appear. Missing values are left empty.
› Why TSV instead of CSV?
When you paste TSV into Excel or Google Sheets, every value lands in its own cell without an import dialog. Commas inside values need no special handling.