JSON to TSV Converter
This JSON to TSV converter turns an array of objects into tab-separated values, the format spreadsheet applications accept directly from the clipboard. Pasting TSV fills the cells immediately, whereas pasting CSV usually dumps everything into one column until you run a text-to-columns wizard. Tabs almost never appear inside real data, so the output rarely needs quoting and stays readable even when values are full of commas. Nested objects and arrays are expanded into dot and index columns so no value is lost, and the whole conversion runs in your browser.
How it works
Same conversion as JSON to CSV, but columns are separated by tab characters. TSV is what spreadsheet apps expect when you paste directly into a sheet, and it avoids quoting entirely for values that contain commas.
Nested objects and arrays become dot and index columns (address.city, tags[0]) so nothing is lost. Turn off expansion to keep each nested value in a single cell as compact JSON.
The conversion runs entirely in your browser — nothing you paste or upload is sent to a server.
How to convert JSON to TSV
- Paste your JSON into the input on the left.
- The tab-separated result appears on the right, with a header row from the object keys.
- Copy it and paste straight into a spreadsheet — the columns land in the right cells without an import step.
TSV or CSV?
Both carry the same table; they differ in the separator. Tabs almost never appear inside real data, so TSV rarely needs quoting and stays readable even when values contain commas, semicolons or apostrophes. That also makes it the format spreadsheet applications accept directly from the clipboard — pasting TSV fills the cells, whereas pasting CSV usually dumps everything into one column until you run the text-to-columns wizard.
Choose CSV when a system explicitly asks for it, and TSV when the destination is a spreadsheet, a quick paste, or data that is full of commas.
Common use cases
- Pasting API results directly into Excel, Numbers or Google Sheets.
- Feeding a script that splits on tabs.
- Exporting data whose values contain commas, without fighting quoting rules.
Frequently asked questions
What is TSV and how does it differ from CSV?
TSV separates columns with tab characters instead of commas. Because tabs almost never appear inside real data, values rarely need quoting, so the file stays readable even when it is full of commas, semicolons and apostrophes.
Why paste TSV into a spreadsheet instead of CSV?
Spreadsheet applications treat tab-separated text from the clipboard as columns automatically. Pasting CSV usually drops the whole row into a single cell until you run the text-to-columns wizard, so TSV skips a step.
How do I convert JSON to TSV?
Paste your JSON into the left panel. The tab-separated result appears on the right with a header row from your object keys, ready to copy straight into a sheet.
What happens if a value contains a tab?
It is quoted using the same rules as CSV, so the row still parses correctly. This is rare in practice, which is exactly why tab-separated output usually needs no quoting at all.
Can I convert nested JSON to TSV?
Yes. Nested objects become dot-separated columns and array items become indexed columns, so every value gets its own column rather than being flattened away.
Is my data sent anywhere?
No. The conversion happens entirely in your browser, so nothing you paste leaves your device.
Related tools
JSON to CSV Converter
This JSON to CSV converter turns an array of objects into spreadsheet-ready rows and columns.
CSV to JSON Converter
This CSV to JSON converter turns CSV rows into a JSON array, keyed automatically by the header row.
JSON Formatter & Beautifier
This JSON formatter beautifies minified or messy JSON online with clean indentation, line numbers, and code folding.