How to Open a TSV File on PC or Mac

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...
Method 1 of 2:

Using a Desktop App

  1. How to Open a TSV File on PC or Mac Picture 1How to Open a TSV File on PC or Mac Picture 1
    Find and right-click the TSV file on your computer. 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.
    1. TSV files can be imported into most spreadsheet programs.
    2. You can use a spreadsheet program like Microsoft Excel, LibreOffice (https://www.libreoffice.org) or Apache OpenOffice (http://www.openoffice.org).
    3. 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. How to Open a TSV File on PC or Mac Picture 2How to Open a TSV File on PC or Mac Picture 2
    Hover over Open with on the right-click menu. A sub-menu will pop up with multiple app options.
  3. How to Open a TSV File on PC or Mac Picture 3How to Open a TSV File on PC or Mac Picture 3
    Select Microsoft Excel on the "Open with" menu. This will import the data stored in your TSV file into Excel, and open it as a spreadsheet.
    1. If you don't have Microsoft Excel on your computer, you can browse the available Office packages on Microsoft's product page.
  4. How to Open a TSV File on PC or Mac Picture 4How to Open a TSV File on PC or Mac Picture 4
    View your TSV data on the spreadsheet. Your TSV's data will be automatically formatted into cells on the Excel spreadsheet. You can view all your columns and data here.
Method 2 of 2:

Using Google Sheets

  1. How to Open a TSV File on PC or Mac Picture 5How to Open a TSV File on PC or Mac Picture 5
    Open Google Sheets in your internet browser. Type or paste https://docs.google.com/spreadsheets into the address bar, and press Enter or Return on your keyboard.
    1. If you're not automatically logged in, use your Google account to sign in here.
  2. How to Open a TSV File on PC or Mac Picture 6How to Open a TSV File on PC or Mac Picture 6
    Click the + icon on the bottom-right. 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. How to Open a TSV File on PC or Mac Picture 7How to Open a TSV File on PC or Mac Picture 7
    Click the File tab. This button is in the upper-left corner of your spreadsheet. It will open a drop-down menu.
  4. How to Open a TSV File on PC or Mac Picture 8How to Open a TSV File on PC or Mac Picture 8
    Click Import on the "File" menu. This will open a new pop-up window, and allow you to select the TSV file you want to view.
  5. How to Open a TSV File on PC or Mac Picture 9How to Open a TSV File on PC or Mac Picture 9
    Click the Upload tab in the Import window. 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.
    1. Alternatively, you can select a file from your Google Drive documents in the My Drive tab.
  6. How to Open a TSV File on PC or Mac Picture 10How to Open a TSV File on PC or Mac Picture 10
    Click the blue Select a file from your device button. This will open your file navigator in a pop-up, and prompt you to select your TSV file.
    1. Alternatively, you can drag and drop your TSV file from your computer to the Import window here.
  7. How to Open a TSV File on PC or Mac Picture 11How to Open a TSV File on PC or Mac Picture 11
    Select the TSV file you want to view. 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.
    1. You'll be prompted to select your data import settings when the upload is finished.
  8. How to Open a TSV File on PC or Mac Picture 12How to Open a TSV File on PC or Mac Picture 12
    Select Replace spreadsheet under "Import location." When this option is selected, your TSV file's data will be copied and pasted as the first sheet in this online workbook.
    1. Since you just created a new, blank spreadsheet, this option is the simplest solution.
    2. 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. How to Open a TSV File on PC or Mac Picture 13How to Open a TSV File on PC or Mac Picture 13
    Select Tab under "Separator type." This will detect the tabs in your TSV file, and arrange your data according to this selection.
    1. TSV files use tabs to separate data values.
    2. Alternatively, you can select Detect automatically here.
  10. How to Open a TSV File on PC or Mac Picture 14How to Open a TSV File on PC or Mac Picture 14
    Select No under "Convert text to numbers, dates, and formulas" (optional). If you want to format all the cells in the same data type as your TSV, make sure to select No here.
    1. If you want to convert your data from the TSV file, you can select Yes.
  11. How to Open a TSV File on PC or Mac Picture 15How to Open a TSV File on PC or Mac Picture 15
    Click the Import data button. 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.
3.5 ★ | 10 Vote