Skip to main content
🇪🇸 Español 🇧🇷 Português 🇩🇪 Deutsch 🇫🇷 Français 🇯🇵 日本語 🇮🇹 Italiano 🇮🇩 Bahasa Indonesia 🇹🇷 Türkçe 🇰🇷 한국어 🇵🇱 Polski 🇳🇱 Nederlands
Image Converter Document Converter Video Converter Audio Converter
Tools Formats (201) Guides Pricing · ⚡ 4,99 € API
Log In
TSV file .tsv
File format · Released 1993 · By IANA (conventional)

About TSV Files

TSV (Tab-Separated Values)

TSV uses tabs instead of commas to separate values in tabular data. It avoids quoting issues common in CSV when data contains commas, making it popular for scientific and linguistic data.

Family

Spreadsheets & Data

Extension

.tsv

MIME Type

text/tab-separated-values

Can Use As

Input Output
● Hex Magic-Bytes Signature (Offset 0x00) Spreadsheets & Data Binary/Text Stream
54 53 56 46 00 01 00 00 4B 41 49 4A ASCII: TSVF....KAIJ
WASM + ISO-27001 HYBRID ENGINE
→
📏 Physical Size (CM / MM / Inch → 300 DPI Pixels)
Passport & ID Presets:

📈 Target Minimum File Size (Guaranteed ≥ KB)

Lossless JPEG Q100 + standard COM segment padding for government & exam portals

Tap to choose your file

QUICK INGEST:
Max 25 MB · Free plan · No signup required

Convert to:

Detecting available formats...

Target Max File Size:

Optimize for:
⚡ Instant In-Browser • 100% Private (0s)

Uploading...

⚡ Converted locally in your browser (0ms upload)

READY!

Advertisement
Original preview
Converted preview

🛡️ Verification Audit

  • ✓
  • ✓ sRGB Color Fidelity
  • ✓

Continue with this converted file (0s zero re-upload):

⚡ Install Desktop App for 1-Click Conversions

Batch Conversion Ready!

⚡ Install Desktop App for 1-Click Conversions
Advertisement
🕒 Recent Conversions (60m Session)
The story

HOW TSV CAME TO BE.

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.

ISO / MIME SPECS

Technical Specifications

MIME type
text/tab-separated-values
Extensions
.tsv, .tab
Standard
IANA registration (1993), IETF RFC unofficial
Delimiter
Tab (ASCII 9)
Encoding
UTF-8 (convention)

Typical Sizes & Weights

Small data export

1-50 KB

Typical database dump

1-500 MB

Genome annotation file

100 MB - 50 GB

STRENGTHS & LIMITATIONS.

Strengths

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

Limitations

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

CURIOSITIES & TRIVIA.

01

TSV was used informally in Unix for 20 years before IANA registered the MIME type in 1993.

02

Bioinformatics pipelines (UCSC Genome Browser, ENCODE) use TSV almost exclusively — genomic coordinates rarely contain tabs, always contain commas.

03

Google Sheets' "download as TSV" option produces clean output without CSV's quoting headaches.

04

MySQL's default MYSQLDUMP output uses tab delimiters, making TSV the native database-export format.

05

The tab character (ASCII 9) almost never appears in real-world data — which is the entire point.

Advertisement
STUDIO TOOLS FOR TSV

Specialized Utilities for .TSV Files

View all 45 tools →

CONVERT FROM TSV

Common Use Cases

Scientific data, linguistics, database exports, bioinformatics.

Related Formats

Popular comparisons

Popular TSV conversions

The most-requested destinations when starting from TSV.

Frequently Asked Questions

TSV (TSV (Tab-Separated Values)) is a spreadsheet format used to store tabular data in rows and columns, typically with multiple sheets per workbook, cell formatting, formulas, and optional charts. It is part of the spreadsheets & data family and is the native format of a specific spreadsheet application.

Excel, Google Sheets, LibreOffice Calc, and Apple Numbers handle most TSV files with high fidelity. For simple one-off viewing, Google Sheets and the Office web apps open TSV in the browser without installing anything. Convert to XLSX or CSV first if your target tool is strict about formats.

Upload the TSV to KaijuConverter and pick XLSX, CSV, ODS, TSV, or PDF. Our LibreOffice-based pipeline reads the sheet data, preserves cell types (numbers, dates, strings), and writes a clean target file. Multi-sheet workbooks come back as a single multi-sheet export or a ZIP of per-sheet CSVs depending on target.

When converting between spreadsheet formats that support formulas (XLSX, ODS), formulas transfer with function-name translation. When converting to CSV, formulas resolve to their cached evaluated value (open the source in Excel once to force evaluation if you suspect stale cache).

Professional Workstation Solution
Unlimited Batch Jobs Zero Upload Wait Times Direct Disk-to-Disk I/O

Need to Convert Gigabyte Archives or Mass Folders?

KaijuConverter delivers ultra-fast in-memory conversions for everyday tasks. For multi-gigabyte production workloads without browser bandwidth bottlenecks, explore high-throughput desktop suites.

Zero cloud transfer • Native hardware performance
24-Hour Fast Pass (€4.99 one-time) Up to 1 GB · No subscription

One-time payment with zero recurring commitment: convert files up to 1 GB, OCR, PDF/A, and .ZIP batches for 24 hours.

Instant Stripe Checkout →
7-Day Project Pass (€9.99 one-time) 7 Days · 2 GB · Ad-Free

Full 7 days of unlimited conversions, up to 2 GB per file, 100% ad-free with zero subscription.

Instant Stripe Checkout →
Kaiju Cloud Business Annual (€99/yr) Up to 2 GB + B2B Invoice

High-throughput enterprise pipeline for files up to 2,048 MB, 50-file batches, ISO PDF/A, and priority processing.

Instant Stripe Checkout →
ImageMagick CLI / XnConvert Free • Mass Batch

Convert thousands of camera RAW files (CR3, NEF, ARW) to WebP, AVIF, or TIFF in one pass.

Affinity Photo / Adobe Lightroom Photo Pro

GPU-accelerated RAW development with end-to-end 16-bit ICC color profile management.

Advertisement
We use cookies and similar technologies to personalise content and ads, and to analyse traffic. Learn more about cookies.