🔁 Formats · 7 min read

Convert TSV to CSV: Tab-Separated Files, Done in a Minute (2026)

Yes, converting TSV to CSV takes about a minute and needs nothing installed. Open the .tsv in Google Sheets, let it split into columns, then pick File → Download → Comma-separated values. That single route covers most one-off files. When fields contain commas, when the conversion repeats weekly, or when the file has millions of rows, use Excel's text import, a terminal one-liner, or Python's csv module instead. What you should not do is a blanket find-and-replace of tabs with commas, because the moment one field contains a comma, your columns quietly shift and every row after that point is wrong.

TSV vs CSV: The Same Idea, a Different Separator

TSV and CSV are both plain-text tables. CSV separates columns with commas and quotes fields that contain commas; TSV separates columns with a tab character and rarely needs quoting at all, since tabs inside a field are far less common than commas. The formats also differ in how strictly they are defined. CSV has an actual grammar, RFC 4180, published in 2005, which spells out quoting and line-break rules. TSV has a registered media type (text/tab-separated-values) but no equivalent RFC, which is why exporters handle edge cases differently and why converting through a real parser beats guessing.

Tab-separated files usually come from exports where commas would collide with content, such as Google Analytics or MySQL dumps. The flip side is that almost every downstream tool prefers commas: Excel, Google Sheets, and most BI tools treat .csv as the default import format, while .tsv files make them ask questions.

Method 1: Google Sheets (Fastest, Nothing to Install)

1. Go to sheets.new and drag the .tsv file onto the browser tab.
2. Sheets detects the tab delimiter and splits the columns for you. Check the first rows.
3. Open File → Download → Comma-separated values (.csv).

That is the whole method. Sheets applies the same approach to pasted text: copy TSV content, paste it into a sheet, and tabs become columns automatically. This route also sidesteps Excel's row ceiling, since Google documents a spreadsheet limit of 10 million cells or 18,278 columns, which comfortably holds exports Excel refuses to open past 1,048,576 rows.

Method 2: Excel's Text Import (When You Want Control)

Excel does not always open a .tsv cleanly on double-click. Use the import dialog instead:

1. In Excel, open Data → From Text/CSV and pick the .tsv file.
2. In the preview, confirm the delimiter is Tab and the encoding is UTF-8.
3. Load the data, then File → Save As → CSV UTF-8.

Since Excel 2016, Microsoft routes text imports through Get & Transform (Power Query), and the preview pane shows exactly where each column will break, which helps when a file mixes tabs and other delimiters. On the save side, pick CSV UTF-8 rather than plain CSV, because the older format drops characters such as é or ü to the system's default encoding. If accents come out garbled later, our guide on fixing garbled CSV in Excel covers the rescue.

Method 3: The Terminal (Repeatable, Handles Huge Files)

When the file is too large for a spreadsheet, or the conversion happens every week, one command does the job on macOS and Linux. A plain find-and-replace at the shell level has the same comma problem as everywhere else, so the safe terminal route pipes through a parser. Python ships with the csv module, which includes a built-in dialect for tab-separated data, so two lines convert any size file correctly:

python3 -c "
import csv, sys
rows = csv.reader(sys.stdin, dialect='excel-tab')
csv.writer(sys.stdout).writerows(rows)
" < data.tsv > data.csv

On Windows PowerShell the equivalent is Import-Csv -Delimiter "`t" | Export-Csv, which does the quoting work for you. These routes never break on commas inside fields because they parse the file rather than blind-replace it.

Method 4: Python for Messy Exports (Full Control)

Exports that mix tabs and commas, or that contain quote characters, deserve the same parser with explicit handling. The example above already quotes fields correctly, but you can add cleaning while converting, for instance dropping empty rows or normalizing a column, because each row arrives as a list you can inspect before writing it out.

Which Method Should You Pick?

Three Conversion Mistakes Worth Avoiding

1. Blanket tab-to-comma replacement. If any field contains a comma, columns shift and data silently lands in the wrong cells. After any conversion, check that every row has the same number of commas, or run the file through a validator.
2. Saving as legacy CSV. Older Excel "CSV" saves can garble accented characters. Use the CSV UTF-8 option.
3. Ignoring stray tabs. Some exports pad rows with trailing tabs, which creates phantom empty columns. Open the converted file and confirm the last column looks right.

When the file is messy before conversion, duplicates and mixed date formats included, run it through our cleaning guide first. And if the target is a live spreadsheet rather than a file, importing CSV into Google Sheets covers that workflow.

Frequently Asked Questions

What is the difference between TSV and CSV?

The separator. CSV uses commas and quotes fields that contain commas, defined by RFC 4180 from 2005. TSV uses tab characters and has no equivalent formal spec, only a registered media type. Practically, TSV comes from exports that expect commas in the data, and CSV is what almost every tool prefers as input.

How do I convert a TSV file to CSV in Excel?

Open Excel and use Data → From Text/CSV, confirm the delimiter is Tab, then load and save as CSV UTF-8. Double-clicking a .tsv usually opens it in Notepad or dumps it into a single column, so the import dialog is the reliable path.

Why does my TSV file open as one long column?

Because nothing told Excel where columns end. Use Data → From Text/CSV and set the delimiter to Tab, or paste the content into Google Sheets, which detects tabs automatically. In the older Text Import Wizard the same option sits on step 2.

Can Google Sheets convert TSV to CSV?

Yes. Drag the .tsv into sheets.new, confirm the columns split correctly, then File → Download → CSV. Sheets also fetches live TSV data from a public URL with the =IMPORTDATA() function when the source updates on its own.

Can I just replace tabs with commas?

Only if you are certain no field contains a comma. A file of names and cities converts fine; a file with address lines or product descriptions usually breaks. When in doubt, parse instead of replace, and verify the column count per row afterwards.

Will converting TSV to CSV change my data?

Values stay the same, but two things can shift: fields containing commas or quotes gain CSV-style quoting, and saving through Excel can reformat long numbers past 15 digits. Keep the original file until the converted one has been checked.