How To Open A TSV File On PC Or Mac - WikiHow

Skip to ContentQuizzes

• PRO Courses Hot Guides Tech Help Pro Expert Videos About wikiHow Pro Upgrade
• QUIZZES All Quizzes Hot Love Quizzes Personality Quizzes Trivia Quizzes Taylor Swift Quizzes
• EDIT Edit this Article
• EXPLORE Tech Help ProAbout UsRandom ArticleQuizzes Request a New ArticleCommunity DashboardTrendingForums Arts and EntertainmentArtworkBooksMoviesComputers and ElectronicsComputersPhone SkillsTechnology HacksHealthMen's HealthMental HealthWomen's HealthRelationshipsDatingLoveRelationship Issues Hobbies and CraftsCraftsDrawingGamesEducation & CommunicationCommunication SkillsPersonal DevelopmentStudyingPersonal Care and StyleFashionHair CarePersonal Hygiene Quizzes Love Quizzes Personality Quizzes Fun Games Arts and EntertainmentFinance and BusinessHome and GardenRelationship Quizzes Cars & Other VehiclesFood and EntertainingPersonal Care and StyleSports and Fitness Computers and ElectronicsHealthPets and AnimalsTravel Education & CommunicationHobbies and CraftsPhilosophy and ReligionWork World Family LifeHolidays and TraditionsRelationshipsYouth
• LOG IN

  Log in

  Social login does not work in incognito and private browsers. Please log in with your username or email to continue. Facebook Google wikiHow Account No account yet? Create an account
• RANDOM

• Home
• Random
• Browse Articles
• TrendingNew
• Quizzes & Games
• All QuizzesHot
• Love Quizzes
• Personality Quizzes
• Fun Games
• Dating Simulator
• Learn Something New
• Forums
• Courses
• Happiness Hub
• Explore More
• Support wikiHow
• About wikiHow

• Log in / Sign up

Terms of Use wikiHow is where trusted research and expert knowledge come together. Learn why people trust wikiHow

• Categories
• Computers and Electronics
• Software
• File Manipulation

How Do I Open a TSV File? Your Easy, Step-by-Step Guide Download Article Quickly open any TSV file with Microsoft Excel or Google Sheets Co-authored by wikiHow Staff

Last Updated: January 11, 2025 Tested

Download Article

• Opening TSV Files on a Desktop Program
|
• Opening TSV Files in Google Sheets
|
• Tips

|Show more |Show less X

This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 59,737 times. Learn more...

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.

Opening a .TSV File

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. In either case, just double-click the file and select “Tab” as the delimiter in the Text Import Wizard.

Steps

Method 1 Method 1 of 2:

Using a Desktop Program

Download Article

1. 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.
   • 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. 2 Hover over Open with on the right-click menu. A sub-menu will pop up with multiple app options. Advertisement
3. 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.
   • If you don't have Microsoft Excel on your computer, you can browse the available Office packages on Microsoft's product page.
4. 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.
Advertisement

Method 2 Method 2 of 2:

Using Google Sheets

Download Article

1. 1 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.
   • If you're not automatically logged in, use your Google account to sign in here.
2. 2 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. 3 Click the File tab. This button is in the upper-left corner of your spreadsheet. It will open a drop-down menu.
4. 4 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. 5 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.
   • Alternatively, you can select a file from your Google Drive documents in the My Drive tab.
6. 6 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.
   • Alternatively, you can drag and drop your TSV file from your computer to the Import window here.
7. 7 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.
   • You'll be prompted to select your data import settings when the upload is finished.
8. 8 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.
   • 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. 9 Select Tab under "Separator type." 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. 10 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.
    • If you want to convert your data from the TSV file, you can select Yes.
11. 11 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.
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

• To view Microsoft Office products, go to https://products.office.com/en-us/compare-all-microsoft-office-products?&OCID=AID679471_OO_DLC_Q4refresh&activetab=tab%3aprimaryr1 in your internet browser. Thanks Helpful 0 Not Helpful 0

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 View, Open, and Edit a .CSV on Windows or Mac How to Convert Text & CSV Files to Excel: 2 Easy Methods 4 Easy Ways to Make a CSV File on a PC, Mac, or Chromebook How to Open Excel Files: Complete Beginner's Tutorial How to Convert Notepad to Excel: Complete Step-by-Step Guide How toOpen XML 2 Easy Ways to Import and Convert XML in Microsoft Excel How toCopy Paste Tab Delimited Text Into Excel How to Use Google Sheets: The Ultimate Guide for Getting Started How toCreate a Database from an Excel Spreadsheet View and Edit SQL Files: MySQL Workbench, Excel, & More The Easy Way to Convert an Excel File to a .DAT File How toOpen a PPT File on PC or Mac New to Excel? Here's Super Easy Tricks to Get You Started 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

Co-authored by: wikiHow Staff wikiHow Staff Writer This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 59,737 times. How helpful is this? Co-authors: 6 Updated: January 11, 2025 Views: 59,737 Categories: File Manipulation Article SummaryX

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?YesNo

In other languagesSpanish

• Print
• Send fan mail to authors

Thanks to all authors for creating a page that has been read 59,737 times.

Is this article up to date?

Yes No Advertisement Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Co-authored by: wikiHow Staff wikiHow Staff Writer Click a star to vote Co-authors: 6 Updated: January 11, 2025 Views: 59,737

Quizzes & Games

Greek Alphabet QuizTake QuizGuess the Language QuizTake QuizIQ Test For KidsTake QuizMusic Notes & Symbols TestTake Quiz

You Might Also Like

How to View, Open, and Edit a .CSV on Windows or MacHow to Convert Text & CSV Files to Excel: 2 Easy Methods4 Easy Ways to Make a CSV File on a PC, Mac, or ChromebookHow to Open Excel Files: Complete Beginner's Tutorial

Trending Articles

Psychopath TestWhat Female Body Shape Are You? How to Identify YoursWhat Kind of Cat Am I QuizIf I Were A... Quiz

Trending Articles

Do You Agree with These "Hear Me Out" Character Hot Takes?Do I Have Main Character Energy?Can Your Finger Length Tell Your Personality?What Are Narrow Clavicles? Plus, How to Build Shoulder Width with Exercises

Take the Quiz Everyone Is Talking About

Am I Gay QuizWhat Animal Am I QuizWhat Is My Mental Age QuizHow Well Do I Know My Best Friend Quiz

You've Seen These All Over Your Feed

10+ Scary Phone Numbers to Call360 of the Best Borg Names for Your Next Party: Unique, Historical & MoreWhat Every Domain Expansion Hand Sign Means In Jujutsu KaisenThe Ultimate List of Truth or Drink Questions

Featured Videos

How toPlay Dice (2 Dice Gambling Games)How toPersuade a Girl over TextHow toGive Someone the Silent TreatmentHow toMake Hibiscus Tea

Hot Takes 🔥 🔥 🔥

Do You Agree with These Crazy Hot Takes?Do You Agree with These Pop Culture Hot Takes?Do You Agree With These Fashion Hot Takes?Do You Agree With These Board Game Hot Takes?

Your Daily Dose of Fun!

When Will I Get My First Period QuizAm I a Bruh Girl?Which My Little Pony Am I QuizAm I Cool Quiz

• Categories
• Computers and Electronics
• Software
• File Manipulation

wikiHow Newsletter You're all set! Helpful how-tos delivered toyour inbox every week! Sign me up! By signing up you are agreeing to receive emails according to our privacy policy.

• Home
• About wikiHow
• Experts
• Jobs
• Contact Us
• Site Map
• Terms of Use
• Privacy Policy
• Do Not Sell or Share My Info
• Not Selling Info
• Contribute

Follow Us

×

wikiHow Tech Help:

Tech troubles got you down? We've got the tips you need

Subscribe You're all set! X --398