A TSV file is a plain-text spreadsheet that opens in any spreadsheet program or text editor

TSV stands for tab-separated values. It is a spreadsheet format where each column is separated by a tab character instead of a comma. You can open a TSV file in Microsoft Excel, Google Sheets, Apple Numbers, or any text editor like Notepad. The file will look like a table with rows and columns, and you can edit it just like a regular spreadsheet.

The simplest route depends on what you want to do with the file. If you need to view it quickly, a text editor works. If you need to sort, filter, or do calculations, a spreadsheet program is better. TSV files are common in data science and research because they handle text that contains commas better than CSV files do.

Key Takeaways

  • TSV files open in any spreadsheet program — Excel, Google Sheets, Numbers — or in any text editor like Notepad.
  • Double-clicking a TSV file usually opens it in your default spreadsheet program, but you can right-click and choose a different program.
  • Google Sheets can open TSV files directly from your computer without installing anything.
  • If the columns do not line up when you open the file, your program may not recognize the tab separators — try opening it as a text file first to check.

Opening a TSV file in Excel or Google Sheets

On Windows, double-click the TSV file. Excel will usually open it automatically and display the data in columns. If it does not, right-click the file, select "Open with", and choose Microsoft Excel from the list.

On Mac, double-click the TSV file. Numbers or Excel will open it if either is installed. If neither opens it, right-click (or Control-click), select "Open With", and choose your spreadsheet program.

Google Sheets works on any computer with a web browser. Go to sheets.google.com, click "File", then "Open", and upload your TSV file. Google Sheets will automatically recognize the tab separators and arrange the data into columns. This is the fastest route if you do not have Excel or Numbers installed.

Opening a TSV file in a text editor

If you want to see the raw data or check whether the file is actually tab-separated, open it in a text editor. On Windows, right-click the file, select "Open with", and choose Notepad. On Mac, right-click, select "Open With", and choose TextEdit. On Linux, use gedit, nano, or vim from the command line.

In a text editor, you will see each row on a new line, with columns separated by whitespace (the tab character). This view is useful for checking whether the file is corrupted or whether the separators are actually tabs or spaces. If you see data bunched together with no clear columns, the file may use spaces instead of tabs.

Fixing columns that do not line up

Sometimes a TSV file opens in a spreadsheet program but the columns do not separate correctly — all the data appears in one column instead of spreading across multiple columns. This usually means your program did not recognize the tab character as a separator.

In Excel, select all the data, go to the "Data" tab, and click "Text to Columns". Choose "Delimited", then check the "Tab" box and uncheck "Space" and "Comma". Click "Finish" and the data will split into the correct columns.

In Google Sheets, the file usually imports correctly, but if it does not, you can paste the data into a new sheet and use the "Split text to columns" feature under the "Data" menu. Select the column, click "Data", then "Split text to columns", and choose "Tab" as the separator.

Converting a TSV file to another format

If you need to send the file to someone who cannot open TSV files, you can convert it to CSV or Excel format. Open the file in your spreadsheet program, go to "File", click "Save As", and choose a different format from the dropdown — .xlsx for Excel, .csv for comma-separated values, or .ods for OpenDocument Spreadsheet.

Google Sheets can also export to these formats. Open the file, click "File", select "Download", and choose your format. This creates a copy in the new format without changing the original TSV file.

TSV vs. CSV and when to use each

TSV and CSV files both store spreadsheet data as plain text, but they use different separators. CSV uses commas, TSV uses tabs. The main difference matters when your data contains commas — a CSV file with commas in the text can become misaligned, but a TSV file stays clean because tabs are less common in regular text.

If you are working with data that has addresses, names with suffixes, or any text that naturally includes commas, TSV is more reliable. If you are sharing data with non-technical people or older systems, CSV is more widely recognized. Most spreadsheet programs handle both equally well, so the choice usually depends on what format the data came in.

Frequently Asked Questions

Can I edit a TSV file and save it?

Yes. Open it in any spreadsheet program, make your changes, and save it. If you save it as a TSV file, the tab separators stay the same. If you save it as Excel or CSV, it converts to that format.

What if my TSV file opens with all data in one column?

Your program did not recognize the tab separator. Open it in a text editor first to confirm the columns are separated by tabs, not spaces. Then use the "Text to Columns" feature in Excel or "Split text to columns" in Google Sheets to fix it.

Is TSV the same as a spreadsheet file?

TSV is a plain-text format that spreadsheet programs can read, but it is not the same as Excel or Numbers files. TSV files are smaller and simpler, but they do not store formatting, formulas, or multiple sheets the way Excel files do.

Can I open a TSV file on my phone?

Yes, if you have a spreadsheet app installed. Google Sheets works on Android and iPhone. Microsoft Excel and Apple Numbers also have mobile versions. Upload or open the TSV file in the app and it will display as a table.