TSV and XLS explained
TSV is CSV with tab characters as separators. Because tabs almost never appear inside data fields, it sidesteps most of CSV's quoting problems.
The pre-2007 Excel format is a binary structure limited to 65,536 rows and 256 columns — limits modern datasets routinely exceed.
- Where TSV files come from
- Bioinformatics, data pipelines and anywhere fields contain commas.
- Where XLS is used
- Spreadsheets from Excel 2003 or earlier, and some legacy export systems.