What's different from CSV?

Tabs as delimiter instead of commas. TSV is simpler — tabs almost never appear in text, so no quoting/escaping rules are needed.

Which tools prefer TSV?

Excel imports it cleanly, Bash pipelines handle it with `awk`/`cut`, and data-science tools (pandas, R) read it slightly faster than CSV.

Replaced with spaces by default. Toggle 'preserve tabs with escape' to use `\t` — but most tools won't unescape them.

TSV doesn't have a newline-escape standard. Multi-line values break TSV parsing; the tool warns and offers newline-replacement options.

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

[{"product":"Laptop","price":999,"qty":5},{"product":"Mouse","price":29,"qty":100},{"product":"Keyboard","price":79,"qty":50}]

Output

product	price	qty
Laptop	999	5
Mouse	29	100
Keyboard	79	50

Convert JSON array to Tab-Separated Values. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

TSV is preferred over CSV in bioinformatics because biological data rarely contains tabs but often contains commas.
The IANA registered the text/tab-separated-values MIME type in 1993, making TSV one of the earliest registered text formats.
TSV files are directly pasteable into spreadsheet applications, as tabs naturally align with cell boundaries.

What's different from CSV?: Tabs as delimiter instead of commas. TSV is simpler — tabs almost never appear in text, so no quoting/escaping rules are needed.
Which tools prefer TSV?: Excel imports it cleanly, Bash pipelines handle it with `awk`/`cut`, and data-science tools (pandas, R) read it slightly faster than CSV.
How does it handle tabs in values?: Replaced with spaces by default. Toggle 'preserve tabs with escape' to use `\t` — but most tools won't unescape them.
What about multi-line values?: TSV doesn't have a newline-escape standard. Multi-line values break TSV parsing; the tool warns and offers newline-replacement options.

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

[{"product":"Laptop","price":999,"qty":5},{"product":"Mouse","price":29,"qty":100},{"product":"Keyboard","price":79,"qty":50}]

Output

product	price	qty
Laptop	999	5
Mouse	29	100
Keyboard	79	50

Convert JSON array to Tab-Separated Values. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

TSV is preferred over CSV in bioinformatics because biological data rarely contains tabs but often contains commas.
The IANA registered the text/tab-separated-values MIME type in 1993, making TSV one of the earliest registered text formats.
TSV files are directly pasteable into spreadsheet applications, as tabs naturally align with cell boundaries.

What's different from CSV?: Tabs as delimiter instead of commas. TSV is simpler — tabs almost never appear in text, so no quoting/escaping rules are needed.
Which tools prefer TSV?: Excel imports it cleanly, Bash pipelines handle it with `awk`/`cut`, and data-science tools (pandas, R) read it slightly faster than CSV.
How does it handle tabs in values?: Replaced with spaces by default. Toggle 'preserve tabs with escape' to use `\t` — but most tools won't unescape them.
What about multi-line values?: TSV doesn't have a newline-escape standard. Multi-line values break TSV parsing; the tool warns and offers newline-replacement options.