.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 typeTabular
Human readabilityHigh
Nesting supportNo
LLM token efficiencyHigh
File extension.tsv
MIME typetext/tab-separated-values
Best forClipboard 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

Related Formats

All 24 formats

TSV 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.