About TSV Files
TSV (Tab-Separated Values)
TSV uses tabs instead of commas to separate values in tabular data. It avoids quoting issues common in CSV when data contains commas, making it popular for scientific and linguistic data.
Family
Spreadsheets & Data
Extension
.tsv
MIME Type
text/tab-separated-values
Can Use As
HOW TSV
CAME TO BE.
TSV — Tab-Separated Values — is CSV’s simpler cousin. The convention predates any formal spec: Unix tools in the 1970s already used tabs as delimiters because tabs virtually never appear inside data, while commas frequently do (in names, addresses, prices). IANA registered `text/tab-separated-values` as an official MIME type in 1993, codifying a habit that had existed for two decades.
TSV is the default of choice when data might contain commas. It’s the standard output format of database dumps (`SELECT ... INTO OUTFILE ... FIELDS TERMINATED BY '\t'` in MySQL), UCSC genomics data, and most bioinformatics pipelines. Excel and Google Sheets open TSV cleanly without the quoting ambiguity that plagues CSV.
CURIOSITIES &
TRIVIA.
TSV was used informally in Unix for 20 years before IANA registered the MIME type in 1993.
Bioinformatics pipelines (UCSC Genome Browser, ENCODE) use TSV almost exclusively — genomic coordinates rarely contain tabs, always contain commas.
Google Sheets' "download as TSV" option produces clean output without CSV's quoting headaches.
MySQL's default MYSQLDUMP output uses tab delimiters, making TSV the native database-export format.
The tab character (ASCII 9) almost never appears in real-world data — which is the entire point.
STRENGTHS &
LIMITATIONS.
Strengths
- No quoting needed — tabs in data are astronomically rare.
- Simpler parser than CSV.
- Preferred by databases, bioinformatics, and scientific pipelines.
- Opens cleanly in every spreadsheet app.
- Plain text, grep-friendly, diffable.
Limitations
- Tabs can be invisibly replaced with spaces by text editors.
- Carriage returns inside fields require escaping conventions.
- Less ubiquitous than CSV in business/consumer workflows.
- No metadata, no schema, no type information.
Typical Sizes & Weights
Small data export
1-50 KB
Typical database dump
1-500 MB
Genome annotation file
100 MB - 50 GB
Technical Specifications
- MIME type
- text/tab-separated-values
- Extensions
- .tsv, .tab
- Standard
- IANA registration (1993), IETF RFC unofficial
- Delimiter
- Tab (ASCII 9)
- Encoding
- UTF-8 (convention)
CONVERT FROM
TSV
Common Use Cases
Scientific data, linguistics, database exports, bioinformatics.
Related Formats
Popular comparisons
TSV vs TXT
Differences, file size, and when to choose each format.
TSV vs JSON
Differences, file size, and when to choose each format.
TSV vs JPG
Differences, file size, and when to choose each format.
TSV vs PNG
Differences, file size, and when to choose each format.
TSV vs PDF
Differences, file size, and when to choose each format.
TSV vs HTML
Differences, file size, and when to choose each format.
Popular TSV conversions
The most-requested destinations when starting from TSV.
Frequently Asked Questions about TSV
Frequently Asked Questions
TSV (TSV (Tab-Separated Values)) is a spreadsheet format used to store tabular data in rows and columns, typically with multiple sheets per workbook, cell formatting, formulas, and optional charts. It is part of the spreadsheets & data family and is the native format of a specific spreadsheet application.
Excel, Google Sheets, LibreOffice Calc, and Apple Numbers handle most TSV files with high fidelity. For simple one-off viewing, Google Sheets and the Office web apps open TSV in the browser without installing anything. Convert to XLSX or CSV first if your target tool is strict about formats.
Upload the TSV to KaijuConverter and pick XLSX, CSV, ODS, TSV, or PDF. Our LibreOffice-based pipeline reads the sheet data, preserves cell types (numbers, dates, strings), and writes a clean target file. Multi-sheet workbooks come back as a single multi-sheet export or a ZIP of per-sheet CSVs depending on target.
When converting between spreadsheet formats that support formulas (XLSX, ODS), formulas transfer with function-name translation. When converting to CSV, formulas resolve to their cached evaluated value (open the source in Excel once to force evaluation if you suspect stale cache).