TSV vs XLS
A detailed comparison of TSV (Tab-Separated Values) and Excel Spreadsheet (Legacy) — file size, quality, compatibility, and which format to choose for your workflow.
TSV (Tab-Separated Values)
Spreadsheets & DataTSV 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.
About TSV filesExcel Spreadsheet (Legacy)
Spreadsheets & DataXLS is the legacy binary format for Microsoft Excel 97-2003 spreadsheets. While superseded by XLSX, it remains common in archived data and older business systems.
About XLS filesStrengths Comparison
TSV 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.
XLS Strengths
- Universal legacy — every Excel since 1997 opens .xls natively.
- Binary format is compact and loads quickly.
- Full support for formulas, charts, pivots, and VBA macros.
- Deep integration with every accounting and ERP system of the 1990s-2000s.
Limitations
TSV 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.
XLS Limitations
- Row/column limits are ~64× smaller than modern XLSX.
- Macro-enabled variants are a notorious malware vector.
- Binary corruption often means total data loss.
- Cannot represent modern Excel features (dynamic arrays, LAMBDA, structured references).
- Microsoft stopped evolving the format in 2007.
Technical Specifications
| Specification | TSV | XLS |
|---|---|---|
| MIME type | text/tab-separated-values | application/vnd.ms-excel |
| Extensions | .tsv, .tab | — |
| Standard | IANA registration (1993), IETF RFC unofficial | — |
| Delimiter | Tab (ASCII 9) | — |
| Encoding | UTF-8 (convention) | — |
| Max rows | — | 65 536 (Excel 97-2003) |
| Max columns | — | 256 (A to IV) |
| Container | — | OLE Compound File |
| Successor | — | .xlsx (2007) |
Typical File Sizes
TSV
- Small data export 1-50 KB
- Typical database dump 1-500 MB
- Genome annotation file 100 MB - 50 GB
XLS
- Simple budget (1 sheet) 30-60 KB
- Multi-sheet financial model 500 KB - 5 MB
- Data export with 65 000 rows 5-20 MB
Ready to convert?
Convert between TSV and XLS online, free, and without installing anything. Encrypted upload, automatic deletion after 2 hours.
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.
XLS is the legacy Microsoft Excel binary format used from 1987 to 2007, storing worksheets, formulas, charts, and VBA macros. Excel 97 switched XLS to the OLE Compound File container. It was replaced as default by XLSX in Office 2007 but survives in legacy financial systems and older government databases.
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.
XLS files open in every Excel version since 1997, Google Sheets (free), LibreOffice Calc (free), Apple Numbers, and most online viewers. The maximum worksheet size in XLS is 65 536 rows × 256 columns — modern XLSX raises those limits dramatically.
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).