JSON to TSV
Convert JSON to tab-separated values.
JSON to TSV Converter Online
The JSON to TSV converter turns JSON arrays into tab-separated values — the easiest format for pasting data straight into Excel, Google Sheets, or LibreOffice Calc. Copy the output, click a cell in your spreadsheet, paste, and every field lands in its own column.
Why TSV?
Tab-separated values avoid the biggest headache of CSV: commas inside the data. Product names like "USB-C Hub, 7-in-1", addresses, and descriptions are full of commas, which forces CSV to quote fields and confuses some importers. Tabs almost never appear in real values, so TSV stays simple, readable, and unambiguous. It's also what spreadsheets put on the clipboard when you copy cells, which is why pasting TSV feels seamless.
How the conversion works
- The records are found automatically: a top-level array, a single object, or an object wrapping one array such as
{"products": [...]}. - Columns are the union of all keys, in the order they first appear.
- Nested objects are flattened into dot-notation columns (
specs.layout); arrays of simple values are joined with commas. - Tabs and line breaks inside values are replaced with spaces so the table stays intact.
Options
- Header row – include or skip the first line with column names.
- Flatten nested objects – dot-notation columns, or nested data as JSON text.
Typical uses
Moving API results into a spreadsheet for quick analysis, preparing bulk imports for tools that accept TSV (such as many bioinformatics and ad platforms), and sharing tabular data in chat or tickets.
Related tools
For comma-separated output, use JSON to CSV; for a native spreadsheet file, JSON to Excel. To inspect the source first, open it in the JSON Viewer.
Frequently Asked Questions
What is the difference between TSV and CSV?
Both are plain-text tables. CSV separates fields with commas and needs quoting when values contain commas; TSV separates fields with tab characters, which rarely appear in data, so values can be written as-is without quotes.
How do I get the TSV into a spreadsheet?
Click Copy and paste into Excel or Google Sheets — tab-separated text is split into columns automatically. You can also download it as a .tsv file and open or import it.
What happens to tabs and line breaks inside values?
They're replaced with spaces, because TSV has no escaping mechanism and a tab or newline inside a value would break the table. All other characters are kept exactly.
Can it handle nested JSON?
Yes. Nested objects become dot-notation columns such as specs.layout, and arrays of simple values are joined with commas. Turn flattening off to keep nested data as JSON text in one column.