What is a TSV file?

TSV — Tab-Separated Values

What is it?

TSV is a cousin of CSV, with one key difference: values are separated by tabs rather than commas.

This small change solves the most persistent problem with CSV. A comma appears naturally in text, in a price, in an address; a tab almost never does. The risk of confusion disappears.

History & origin

The format emerged from the same need as CSV, in the same era, and was long favored by scientists and statisticians — for exactly this reason.

It remains the default exchange format for many bioinformatics and data-processing tools.

Why it is useful

No ambiguity about the delimiter, which eliminates the main source of import errors.

It is just as lightweight and universal as CSV.

Limits & drawbacks

Tabs are invisible: there's no way to tell one apart from a run of spaces just by looking, which makes manual correction harder.

Some text editors silently convert tabs into spaces, corrupting the file without warning.

Practical tips

If your data contains commas, choose TSV over CSV: it will save you hours of debugging.

For spreadsheet use, converting to XLSX avoids any delimiter issues, since the structure is explicit.

Convert your TSV in seconds, on our secure servers in France.

Convert a TSV