.tsv · text/tab-separated-values
TSV: Tab-Separated Values
TSV separates columns using literal tab characters (U+0009), avoiding delimiter conflicts with commas in prose, prices, and addresses.
Quick Answer: TSV separates columns using literal tab characters (U+0009), avoiding delimiter conflicts with commas in prose, prices, and addresses. Clipboard copy-paste from spreadsheets, bioinformatics datasets, and comma-heavy text columns.
| Structure type | Tabular |
|---|---|
| Human readability | High |
| Nesting support | No |
| LLM token efficiency | High |
| File extension | .tsv |
| MIME type | text/tab-separated-values |
| Best for | Clipboard copy-paste from spreadsheets, bioinformatics datasets, and comma-heavy text columns. |
Strengths
- Directly matches spreadsheet copy-paste clipboard structure
- Avoids quoting overhead when values contain frequent commas
- Simple to split cleanly in shell pipelines, awk, and Python
Trade-offs
- Tabs inside values are disallowed by strict IANA TSV rules
- Invisible tab spacing looks ambiguous in plain text editors
- Fewer consumer apps register .tsv compared to .csv
References
Convert & clean TSV locally
Related engineering guides
- Merging & Splitting Large CSV Files Locally Without Crashing ExcelCombine multi-file CSV exports by column header name or split oversized sheets into clean chunks with repeated headers and ZIP export locally.
- TXT, TSV & CSV to SQL: Clean Database Import WorkflowTurn whitespace or pipe-delimited TXT and TSV logs into RFC 4180 CSV, infer SQL column types, and generate batched PostgreSQL, MySQL, or SQLite SQL.
Related Formats
All 24 formatsTSV frequently asked questions
When is TSV better than CSV?
TSV shines when copying ranges from Excel or working with currency strings and addresses full of commas, where CSV requires heavy double-quote escaping.
How do I convert copied spreadsheet cells to a Markdown table?
Copying cells from Excel or Google Sheets puts TSV text on your clipboard. Paste it directly into Markdown Table Generator or Excel to Markdown.
What is the official MIME type for TSV?
The IANA registered MIME type is text/tab-separated-values with the .tsv file extension.