About the JSON to TSV Converter
Tab-separated values are the format spreadsheets use on the clipboard. If you copy TSV and paste into Excel, Google Sheets or Numbers, each tab becomes a column and each line a row, with no import wizard. That makes TSV the quickest way to get JSON data into a spreadsheet for a one-off look.
The conversion uses the same rules as the JSON to CSV tool: an array of objects becomes rows, the header is the union of keys in first-seen order, and nested objects are flattened into dotted column names. Because tabs rarely appear in data, quoting is only applied when a value actually contains a tab, quote or line break.
If you need a file rather than clipboard text, use Download; the file has a .tsv extension which most spreadsheet apps open directly.
How to use
- Paste a JSON array on the left.
- Click Copy, switch to your spreadsheet, select a cell and paste.
- Or click Download for a .tsv file.
Common questions
- What is the difference between TSV and CSV?
- Only the delimiter: a tab instead of a comma. TSV needs quoting far less often because tabs are rare inside data, and it pastes into spreadsheets directly.
- Can I convert TSV back to JSON?
- Yes, with the TSV to JSON converter. The Swap button opens it with your output.
- Are nested objects supported?
- They are flattened into dotted column names, the same way as in the CSV converter.