JSON to TSV Converter
Produce tab-separated output you can paste straight into a spreadsheet — no import wizard, no delimiter guessing.
Your data stays on your device
Input — JSON
- characters
- 0
- lines
- 0
- size
- 0 B
Output — TSV
- characters
- 0
- lines
- 0
- size
- 0 B
Options
Needed for Excel to open non-ASCII text correctly.
About this tool
TSV solves the most common CSV annoyance: text containing commas. Tab characters almost never appear inside data, so fields rarely need quoting and the file stays readable. Spreadsheets also treat tab-separated clipboard content as columns automatically.
The conversion follows the same flattening rules as the CSV tool — the union of keys becomes the header, nested objects flatten to dotted names — but emits tabs and escapes any literal tab or newline inside a value.
How to use this tool
- Paste a JSON array of objects, or upload a .json file.
- Choose how nested objects and arrays are flattened.
- Press Convert.
- Copy the output and paste it directly into a spreadsheet cell, or download it as .tsv.
Key features
- Header row from the union of all keys
- Dotted flattening for nested objects
- Literal tabs and newlines inside values escaped so columns stay aligned
- Pastes into Excel and Google Sheets without an import step
- Optional UTF-8 BOM for legacy spreadsheet software
- Copy and download as .tsv
Example
Input — JSON
[{"sku":"A1","qty":3},{"sku":"B2","qty":7}]Output — TSV
sku qty
A1 3
B2 7Good to know
- Values that genuinely contain tab characters are escaped, so a strict byte-for-byte round trip is not guaranteed.
- Like CSV, TSV carries no type information; everything is text.
- The input must be array-shaped to produce more than one row.
Frequently asked questions
TSV or CSV?
TSV when you are pasting into a spreadsheet or your data contains commas. CSV when a downstream system explicitly expects it, which is still the more common requirement.
Do I need quoting in TSV?
Almost never, which is the point. This converter escapes the rare embedded tab or newline rather than introducing quotes.
Will it paste into Google Sheets correctly?
Yes. Sheets and Excel both split pasted clipboard text on tabs automatically, so the columns land in place.
How are nested arrays handled?
They are joined into a single cell using a separator you choose, keeping the output rectangular.
Your data stays on your device
Your data is processed locally in your browser and is not uploaded to our server. This page keeps working after you go offline, because there is nothing to send.