How to Open a TSV File on PC or Mac

PDF download Download Article
PDF download Download Article

This wikiHow teaches you how to open and view the contents of a TSV (Tab Separated Values) data file on your computer. A TSV file contains a data table with columns of data and is similar to the CSV (Comma Separated Values) format. To view the data in a TSV file, you can use a desktop spreadsheet program like Microsoft Excel, or a cloud service like Google Sheets.

Things You Should Know

  • If you have access to a spreadsheet program like Microsoft Excel, you can open the TSV file in that application.
  • If you want to use a web browser application, use Google Sheets to open the TSV file.
  • To use Google Sheets, you’ll need a Google account to sign in and create a new sheet.
Method 1
Method 1 of 2:

Using a Desktop Program

PDF download Download Article
  1. Open the folder that contains the TSV file you want to open, and right-click on the file icon to see your options on a drop-down menu.
    • TSV files can be imported into most spreadsheet programs.
    • You can use a spreadsheet program like Microsoft Excel , LibreOffice ( https://www.libreoffice.org ) or Apache OpenOffice ( http://www.openoffice.org ).
    • Alternatively, you can use a basic text editor like Notepad or TextEdit , but this may sometimes distort the data in your TSV file, and only show a scramble of numbers and characters.
  2. A sub-menu will pop up with multiple app options.
    Advertisement
  3. This will import the data stored in your TSV file into Excel, and open it as a spreadsheet.
    • If you don't have Microsoft Excel on your computer, you can browse the available Office packages on Microsoft's product page.
  4. Your TSV's data will be automatically formatted into cells on the Excel spreadsheet. You can view all your columns and data here.
    5. Advertisement
Method 2
Method 2 of 2:

Using Google Sheets

PDF download Download Article
  1. Type or paste https://docs.google.com/spreadsheets into the address bar, and press ↵ Enter or ⏎ Return on your keyboard.
    • If you're not automatically logged in, use your Google account to sign in here.
  2. This icon looks like a colored " + " on a white button in the lower-right corner of your screen. It will create and open a new, blank spreadsheet file.
  3. This button is in the upper-left corner of your spreadsheet. It will open a drop-down menu.
  4. This will open a new pop-up window, and allow you to select the TSV file you want to view.
  5. You can find this option on a tab bar below the "Import file" heading at the top of the window. This tab will allow you to select a file from your computer, and import it to Google Sheets.
    • Alternatively, you can select a file from your Google Drive documents in the My Drive tab.
  6. This will open your file navigator in a pop-up, and prompt you to select your TSV file.
    • Alternatively, you can drag and drop your TSV file from your computer to the Import window here.
  7. Click on your TSV file in the file navigator pop-up, and click the Open button on the bottom-right. This will upload your file to Google Sheets.
    • You'll be prompted to select your data import settings when the upload is finished.
  8. " When this option is selected, your TSV file's data will be copied and pasted as the first sheet in this online workbook.
    • Since you just created a new, blank spreadsheet, this option is the simplest solution.
    • If you're importing TSV data to a different worksheet with more data, you can select Create new spreadsheet here to create a new online file out of your local TSV.
  9. " This will detect the tabs in your TSV file, and arrange your data according to this selection.
    • TSV files use tabs to separate data values.
    • Alternatively, you can select Detect automatically here.
  10. If you want to format all the cells in the same data type as your TSV, make sure to select No here.
    • If you want to convert your data from the TSV file, you can select Yes .
  11. This will import all your data from the selected TSV file, and paste it to your online spreadsheet. You can view your TSV data in Google Sheets here.
    12. Advertisement

Common Questions: Opening TSV Files

How do you open a TSV file in Excel by default?

Go to Start > Settings > Apps > Default apps > Choose default apps by file type . Click the Choose a default button next to .tsv (or the program name, if a default program has already been assigned) and change it to Microsoft Excel. [1]

What other programs can open TSV files?

Any spreadsheet program should be able to open a TSV file. Some alternative programs to Microsoft Excel include LibreOffice Calc and OpenOffice Calc, or the web-based Google Sheets. You can also open TSV files in text editors like Notepad or Notepad++, or in IDEs such as Visual Studio Code and JetBrains.

What is a TSV file used for?

A TSV file is used to store data tables in a plain-text format. It stands for "tab-separated values" because the columns of the table are separated by tabs. [2] TSV files can be used to move tabular data between different applications and is helpful for data analysis using programming languages such as R or Python.

How do I convert a TSV file to Excel?

Open your TSV file in Excel, which will open the Text Import Wizard. On the first step, make sure Delimited is selected. On the second step, make sure the Tab checkbox is selected. For the third step, set the format for each column. Then save your spreadsheet as an XSLX file.

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!
Advertisement

You Might Also Like

How to
Open BIN Files
How to
Install APK Files on Android
How to
Extract a GZ File on Windows, Linux, Mac, & Mobile
How to
Open DLL Files
How to
Open a DAT File
How to
Remove Unneeded & Unused Files in Windows 10 & 11
3 Easy Ways to Protect a Folder With a Password
4 Simple Ways to Scan and Save Documents
How to
Compress Large Files
Quick Ways to Open JPEG Images on Windows, Mac, and Mobile
6 Simple Ways to Play SWF Files Without Adobe Flash Player
How to
Use 7-Zip to Compress Files to the Smallest Size
How to
Open TMP Files
How to
Create a TXT File on Mac
Advertisement

References

  1. ↑ https://support.microsoft.com/en-us/windows/change-default-programs-in-windows-e5d82cad-17d1-c53b-3505-f10a32e1894d#ID0EDD=Windows_10
  2. ↑ https://fileinfo.com/extension/tsv

About This Article

Article Summary X

1. Find and right-click the TSV file.
2. Hover over Open with .
3. Select Microsoft Excel or another spreadsheet program.
4. View your TSV data on the spreadsheet.

Did this summary help you?
In other languages
Thanks to all authors for creating a page that has been read 53,555 times.

Is this article up to date?

Advertisement