2 min read
By HappyCSV Team

Convert TSV to CSV (Tab-Separated to Comma-Separated)

Convert TSV files to standard CSV format. Free online converter for tab-delimited data. Works with Excel exports.

Convert TSV to CSV

TSV (Tab-Separated Values) files use tabs instead of commas as delimiters. While similar to CSV, many applications prefer standard CSV format.

What's the Difference?

TSV (Tab-Separated):

Name	Email	Phone
John	john@email.com	555-1234
Jane	jane@email.com	555-5678

CSV (Comma-Separated):

Name,Email,Phone
John,john@email.com,555-1234
Jane,jane@email.com,555-5678

The only difference is the delimiter character.

Quick Conversion

-> Convert TSV to CSV

Upload your TSV file and get standard CSV output instantly.

When You'll Encounter TSV

  • Database exports - MySQL, PostgreSQL tab exports
  • Excel Copy/Paste - Copying cells creates tab-separated data
  • Unix tools - Many command-line tools output TSV
  • Bioinformatics - Gene data files often use TSV

Why Convert to CSV?

  • Better compatibility - More apps support CSV
  • Easier to edit - Visible commas are clearer than invisible tabs
  • Import requirements - Some services only accept CSV
  • Excel handling - CSV opens correctly in Excel, TSV may not

Handling Edge Cases

If your data contains commas, the converter properly quotes those fields:

TSV Input:

Product	Price	Description
Widget	$9.99	Small, portable device

CSV Output:

Product,Price,Description
Widget,$9.99,"Small, portable device"

Command Line Method

# Using sed
sed 's/\t/,/g' file.tsv > file.csv

# Using awk
awk -F'\t' '{print $1","$2","$3}' file.tsv > file.csv

Note: These simple methods don't handle commas in data. Use a proper parser for complex files.


Tab to comma in seconds. HappyCSV converts TSV to CSV with proper quoting.

Need to handle CSV files?

HappyCSV is the free, secure way to merge, split, and clean your data — all in your browser.