RividTechJSON to TSV
Convert a JSON array of objects (or a single object) into TSV format.
Drop a file or click to browse
or paste data below
How JSON to TSV works
Why TSV instead of CSV
The quickest way to get JSON into a spreadsheet is often not a file at all: copy tab-separated text and paste it into a cell. Excel, Google Sheets, and Numbers split pasted TSV into columns without an import dialog. Commas inside values, such as Desk lamp, brass, need no quoting, so the output is easier to read in a text editor too.
TSV is also simpler to process with line-oriented command-line tools. cut -f2 or awk -F'\t' work on it directly, without a CSV-aware parser.
How the rows are built
Every key found in any object becomes a column, in the order it first appears. Records that lack a key get an empty cell. Nested objects and arrays are written as compact JSON text, and null becomes an empty cell. This is the same mapping as JSON to CSV; only the separator differs.
Values are written as text exactly as they appear in the JSON. When pasted into a spreadsheet, though, the spreadsheet may reformat them: 00142 can become 142, and long IDs can turn into scientific notation. To keep such columns as text, format them as Plain text before pasting, or use JSON to Excel, which stores every cell as text.
Quoting rules
A field is quoted only when it contains a tab, a double quote, or a line break. Nested JSON contains double quotes, so those cells are quoted with inner quotes doubled. Lines end with CRLF.
Example
The comma in the title needs no quoting in TSV, and the first record gets an empty discontinued cell.
[
{ "sku": "00142", "title": "Desk lamp, brass", "stock": 12 },
{ "sku": "00977", "title": "Notebook", "stock": 0, "discontinued": true }
]sku title stock discontinued
00142 Desk lamp, brass 12
00977 Notebook 0 trueHow to use JSON to TSV
- 1
Paste a JSON array of objects or drop a .json file.
- 2
Check the columns in the TSV output.
- 3
Copy it and paste into a spreadsheet, or download converted.tsv.
When to use it
Quick look in a spreadsheet
Paste API output into a sheet to sort, filter, or chart it without saving a file.
Shell pipelines
Feed JSON records to cut, sort, or uniq when jq is not available.
JSON to TSV questions
Why did my leading zeros disappear after pasting?
The TSV keeps them; the spreadsheet removes them when it reads the pasted cells as numbers. Format the target column as text before pasting, or download an Excel file instead.
Does it accept a single object?
Yes. A single object becomes one row, with one column per top-level key.
Can I flatten nested fields?
Use Flatten JSON first to get dotted columns such as user.email, then convert the CSV with CSV to TSV if you need tabs.
Questions about privacy, file size, or accounts are answered on the FAQ page.
More converters
Other tools in the same category
JSON to CSV
Convert a JSON array of objects into CSV, with one column for every key found
JSON to Excel
Turn a JSON array of objects into a single-sheet .xlsx workbook
Flatten JSON
Flatten nested JSON into CSV columns with dotted names, or nest dotted columns back into JSON
TSV to CSV
Convert tab-separated data, including ranges copied from a spreadsheet, into standard CSV