How to Open TSV Files (Tab-Separated Values)

A .tsv file is one of those formats that looks simple until you double-click it. The data is right there in plain text, yet it opens in the wrong app, or every row collapses into a single unreadable line. The fix is straightforward once you understand what a tab-separated file actually is and what tool to point at it.

What a TSV file is

TSV stands for tab-separated values. It's a plain-text table: each row is a line, and within each line the columns are separated by a single Tab character. That's the only real difference from a CSV — CSV uses commas as the delimiter, TSV uses tabs.

TSV is popular wherever the data itself contains commas. Addresses, descriptions, and numbers with thousands separators all use commas, so a tab delimiter sidesteps a lot of quoting and escaping. You'll see .tsv files exported from databases, bioinformatics tools, analytics platforms, and plenty of command-line utilities. Closely related are .tab files (also tab-delimited) and .psv files, which use the pipe character | instead.

Why double-clicking opens the wrong app

When you double-click a .tsv file, your operating system hands it to whatever program is registered for that extension. That's often a generic text editor, or nothing at all — in which case you get an "Open with..." prompt and a guess.

Even when a spreadsheet program grabs it, the result is frequently wrong. Some tools assume comma delimiters regardless of the file's real structure, so a tab-separated file lands entirely in column A. Others run an import wizard you have to click through every single time. None of that is what you want when you just need to look at the data.

The cleaner solution is to set a proper default app for delimited files so the right tool opens them every time. We cover that in setting your default CSV app, and the same approach applies to .tsv and .tab.

Why tabs are invisible in a text editor

Here's the part that trips people up. Open a TSV in Notepad or another plain text editor and it can look like one long, jumbled line per row, with columns smashed together or scattered at random widths.

That's because a Tab is whitespace. The editor renders it as a stretch of blank space, the same way it would render the space bar — there's no visible marker telling you "a new column starts here." The structure is in the file, but a plain text editor has no concept of columns, so it can't line anything up. You're seeing the raw characters with none of the table they describe.

This is exactly why a grid view matters. A tool that understands the tab delimiter splits each line at every Tab and drops the values into real, aligned columns. Suddenly the same file reads like the table it always was.

How to open and view a TSV the right way

The reliable approach is a viewer that auto-detects the delimiter and shows your data in a grid. CEESVEE does this: it's a free, open-source, fully local CSV and delimited-file viewer for Windows, macOS, and Linux, and it reads .csv, .tsv, .tab, and .psv files.

Step by step

1. Download CEESVEE and install it. It runs entirely on your machine — nothing is uploaded, and there are no accounts.
2. Open your TSV file from within the app, or drag it onto the window. CEESVEE auto-detects the tab delimiter and the file's encoding, so columns appear correctly without any import wizard.
3. Read the data in the grid. The header row freezes as you scroll, and live stats show row and column counts so you can confirm everything parsed as expected.
4. If detection is ever wrong, override the delimiter manually from the dropdown. The grid re-parses instantly, so you can see the right result immediately. (More on how delimiters work in CSV delimiters explained.)

Because the underlying engine is built in Rust with a virtualized grid, large exports are not a problem — files with up to 1,000,000 rows and well past 100 MB open without choking.

Editing a TSV file

Viewing is only half the job. CEESVEE lets you edit cells directly, sort by multiple columns, and run find & replace with plain text or regular expressions. You can keep several files open in tabs and reopen recent ones quickly. None of it requires a comma-versus-tab decision up front, because the format is detected for you.

Converting TSV to CSV (or back)

Sometimes another tool insists on commas. Converting is a one-step export:

1. Open the .tsv file in CEESVEE.
2. Choose Save As.
3. Set the export delimiter to a comma, pick your encoding and line endings if needed, and save.

The file is rewritten as a clean CSV with no data loss. The reverse — CSV to TSV — works the same way by choosing a tab on export. There's a fuller walkthrough in converting between CSV and TSV.

The bottom line

A TSV file is just a table that uses tabs instead of commas. It opens in the wrong app because the extension defaults are wrong, and it looks broken in a text editor because tabs are invisible whitespace. Point a delimiter-aware grid at it and the table appears exactly as intended.

Download CEESVEE for free — it auto-detects the tab delimiter and opens your TSV files in a proper grid, no import wizard required.