TSV and ODS 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.
ODS is the OpenDocument spreadsheet format, the open-standard counterpart to XLSX used by LibreOffice Calc.
- Where TSV files come from
- Bioinformatics, data pipelines and anywhere fields contain commas.
- Where ODS is used
- LibreOffice Calc and open-standards environments.