What Is TSV? Differences from CSV, Conversion Methods, and When to Use It

You've probably encountered files with a .tsv extension, but didn't quite know what to do with them. TSV (Tab-Separated Values) is one of the most common text-based data formats alongside CSV, and it excels in specific use cases. Understanding how TSV differs from CSV and when to use each format can streamline your data workflows and reduce errors. This guide covers what is TSV, how to open and edit it, conversion techniques, and practical guidance on choosing between the two formats.

Note: Third-party tool specs reflect the state at the time of writing (April 2026). Check each tool's official site for the latest features and limits.

TSV Basics — The Structure of Tab-Separated Text

TSV stands for Tab-Separated Values. It's a plain-text file format where each column is separated by a tab character (\t). Each row represents one record, and when viewed in a monospaced font, columns align vertically.

You've likely encountered CSV (Comma-Separated Values) for similar purposes, but TSV takes a different approach to column separation. The name tells the whole story: everything hinges on using tabs instead of commas as delimiters.

TSV Spec vs. CSV (Comparison Table)

CSV relies on commas, so when your data contains commas, you must wrap those values in double quotes ("). For example, "San Francisco, CA" becomes "San Francisco, CA" in CSV. TSV avoids this entirely—commas in data don't cause any issues because tabs, not commas, separate columns. This single difference reshapes how you handle certain datasets.

Where TSV Shows Up in Practice

Bioinformatics and genomics rely heavily on TSV. UniProt (a major protein database) supports TSV downloads, and NCBI tools frequently output tab-delimited data. The reason: gene names, organism designations, and research annotations often contain commas. Escaping becomes tedious, so TSV sidesteps that friction.

Text analysis and natural language processing projects often work with TSV when processing documents or survey responses. Sentences naturally contain commas and punctuation, so tab separation keeps the data cleaner. It's also easier to debug and verify data quality by eye when tabs are the delimiter—the columns stay visually distinct.

Datasets in Japanese and other languages with native punctuation frequently use TSV to avoid delimiter conflicts.

How to Open and Edit TSV Files

TSV is plain text, so many applications can open it. Your tool choice depends on how much processing you need to do.

Opening in Excel or Google Sheets

Excel auto-detects .tsv files and opens them with correct tab-delimited parsing when you double-click. However, if character encoding issues arise (especially with non-ASCII text), using the explicit import process is safer.

In Excel 365, the recommended method is "Data" > "Get Data" > "From Text/CSV," which lets you verify the delimiter and encoding before importing. Follow these steps:

Excel Opening Steps:

Google Sheets Opening Steps:

Google Sheets is more forgiving and often auto-detects tab delimiters accurately.

Direct Editing in a Text Editor

For simple edits, opening a TSV in a text editor (VS Code, Sublime Text, Notepad, etc.) is the fastest route.

Text editor characteristics for TSV editing:

• Advantages: Full freedom to modify with regex find-and-replace
• Disadvantages: Readability drops with many columns
• Best for: Small files with few columns

Readability drops when you have many columns, so for large datasets, using a spreadsheet application is more practical. A handful of columns is manageable in an editor.

Converting Between TSV and CSV

Data might come as TSV from one system but your partner requires CSV. The reverse scenario—CSV to TSV—also happens. Multiple conversion routes exist; pick the one that fits your setup.

Browser-Based Conversion Tools

Online TSV-to-CSV converters need no installation. The workflow is simple:

The workflow is straightforward and suitable for one-off conversions.

If security is a concern—particularly with sensitive data—prefer local tools that process files entirely on your machine. That way, your data never reaches external servers.

Save-As Conversion in Excel or Google Sheets

If your TSV is already open in Excel, save it as CSV using "Save As":

Excel conversion steps:

Google Sheets conversion:

This approach is the most reliable and error-resistant. The conversion handles the format switch automatically.

Batch Conversion on the Command Line (sed / awk / PowerShell)

For converting dozens or hundreds of TSV files, command-line tools are efficient.

Linux with sed:

sed 's/\t/,/g' input.tsv > output.csv

This replaces all tabs with commas. Reverse the process (CSV to TSV):

sed 's/,/\t/g' input.csv > output.tsv

Using awk:

awk 'BEGIN{OFS=","} {$1=$1; print}' input.tsv > output.csv

Awk is more flexible—you can selectively convert specific columns or apply conditional logic.

PowerShell on Windows:

$tsv = Import-Csv input.tsv -Delimiter "`t"
$tsv | Export-Csv output.csv -NoTypeInformation

Command-line tool comparison:

All three methods scale to batch operations and can be scripted for automation. Note: sed and awk perform naive character replacement—they don't handle quoted CSV fields containing commas or double-quotes. For complex data, use PowerShell's Import-Csv / Export-Csv (which handles RFC 4180 quoting correctly) or convert through Excel.

TSV or CSV — Which One to Pick

Your choice depends on data content and the systems that must consume it.

TSV When Your Data Contains Commas

If your dataset contains addresses like "San Francisco, CA" or names like "Smith, John", commas are everywhere. TSV avoids the need for quoting and escaping—values are stored as-is. Processing becomes simpler.

Format comparison for comma-heavy data:

Text analytics and NLP projects benefit similarly. Sentences contain punctuation, so tab separation maintains clarity without extra escaping overhead.

JSON is another option, but if tab-separated is sufficient, TSV uses less disk space and processes faster.

CSV for Compatibility with Other Systems

CSV is the de facto standard. Almost every system—from accounting software to CRM platforms—expects CSV. When interoperability is a requirement, CSV is the safe default.

System compatibility checklist:

Sales and marketing platforms (HubSpot, Salesforce, etc.) virtually always require CSV imports. Even if your data contains commas, adapting it to CSV format through quoting or data adjustment is worth the interoperability gain.

Think of TSV as "CSV Without the Comma Problem"

TSV is a straightforward plain-text format where tabs separate columns. The tab delimiter is the defining feature, and it solves one specific pain point: handling data that naturally contains commas.

TSV vs CSV decision matrix:

Opening and editing TSV is uncomplicated—Excel, Google Sheets, and text editors all handle it. Conversion is quick, whether through spreadsheet "Save As" dialogs or command-line tools. You don't need proprietary software.

Your decision rule is simple: if your data is comma-heavy and stays internal, choose TSV; if external systems or partners need the data, choose CSV. Either way, you're working with plain text, which is why both formats remain in wide use decades after their creation—simplicity endures.