Sobre os arquivos TSV
TSV (Valores Separados por Tab)
Variante do CSV usando tabs como separador em vez de vírgulas. Comum em bioinformática e dados científicos onde vírgulas aparecem nos dados.
Família
Spreadsheets & Data
Extensão
.tsv
Tipo MIME
text/tab-separated-values
Pode ser usado como
COMO NASCEU O
FORMATO TSV.
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.
CURIOSIDADES E
FATOS INTERESSANTES.
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.
VANTAGENS E
LIMITAÇÕES.
Vantagens
- 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.
Limitações
- 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.
Tamanhos típicos de arquivo
Small data export
1-50 KB
Typical database dump
1-500 MB
Genome annotation file
100 MB - 50 GB
Especificações técnicas
- MIME type
- text/tab-separated-values
- Extensions
- .tsv, .tab
- Standard
- IANA registration (1993), IETF RFC unofficial
- Delimiter
- Tab (ASCII 9)
- Encoding
- UTF-8 (convention)
CONVERTER A PARTIR DE
TSV
Casos de uso comuns
Scientific data, linguistics, database exports, bioinformatics.
Formatos relacionados
Comparativos populares
TSV vs TXT
Diferenças, tamanho de arquivo e quando escolher cada formato.
TSV vs JSON
Diferenças, tamanho de arquivo e quando escolher cada formato.
TSV vs JPG
Diferenças, tamanho de arquivo e quando escolher cada formato.
TSV vs PNG
Diferenças, tamanho de arquivo e quando escolher cada formato.
TSV vs PDF
Diferenças, tamanho de arquivo e quando escolher cada formato.
TSV vs HTML
Diferenças, tamanho de arquivo e quando escolher cada formato.
Conversões populares de TSV
Os destinos mais procurados ao converter arquivos TSV.
Perguntas frequentes sobre TSV
Perguntas frequentes
TSV (TSV (Tab-Separated Values)) is a spreadsheet formato used to store tabular data in rows e columns, tipicamente com multiple sheets per workbook, cell formatoting, formulas, e optional charts. It is part of the spreadsheets & data family e is the native formato of a specific spreadsheet aplicativo.
Excel, Google Sheets, LibreOffice Calc, e Apple Numbers handle most TSV arquivos com alta fidelity. para simples one-off viewing, Google Sheets e the Office web apps abrir TSV in o navegador sem installing anything. converter to XLSX ou CSV first if your target tool is strict about formatoos.
Upload the TSV to KaijuConverter e pick XLSX, CSV, ODS, TSV, ou PDF. Our LibreOffice-based pipeline reads the sheet data, preserves cell types (numbers, dates, strings), e writes a clean target file. Multi-sheet workbooks come back como um single multi-sheet export ou a ZIP of per-sheet CSVs depending on target.
When convertendo between spreadsheet formatoos that support formulas (XLSX, ODS), formulas transfer com function-name translation. When convertendo to CSV, formulas resolve to their cached evaluated value (open the source in Excel once to force evaluation if you suspect stale cache).