How To Open TSV Files On Windows 10 - AddictiveTips

We’re all familiar with CSV files i.e., Comma Separated Values. It’s a type of file format which imports and opens easily in most common spreadsheet apps. The values that appear to be separated by commas are separated into columns and rows. TSV files are similar but far less commonly supports.

TSV files on Windows

TSV files are tab separated values where ‘tab’ is the space that’s entered when you tap the Tab key on your keyboard. The file has the TXT file extension and not a TSV file extension which is just one more way it differs from a CSV file. A single data set will all be on the same line but it will be divided by a ‘tab’ value.

Open TSV files on Windows 10

Technically, opening a TSV file on Windows 10 is easy since it is a text file. You can use any basic text editor like Notepad to open it.

1. Right-click the TSV file and select Open With
2. Select Notepad.
3. The file will open.

This method works but the data is not easy to read. A text editor has no column and row grid that displays the data in an easy to read format. This is why you essentially need a spreadsheet tool to open it and make sense of it.

1. TSV files – Microsoft Excel

Excel can open a TSV file but you must define the delimiter character for the TSV file when you open it in Excel.

1. Open Microsoft Excel.
2. Go to File>Open.
3. From the File Type dropdown, select All Files.
4. Select the TSV file.
5. When prompted to, select Tab as the delimiter value.
6. The TSV file will open.

2. TSV files – OpenOffice

Microsoft Excel isn’t a free app. You need to buy a subscription to Microsoft 365 in order to use. The web version of Outlook is free but it does not support TSV files. For a free solution, use OpenOffice.

1. Download OpenOffice.
2. Choose Calc during installation (unless you want to install the full productivity suite).
3. Open Calc.
4. Go to File>Open.
5. Select the TSV file.
6. Choose Tab as the delimiter character and uncheck all others.
7. The TSV file will open.

Conclusion

There is surprisingly little support for TSV files. Google Sheets does not support it. Instead, it opens the file as a document. You might find TSV file viewers online i.e., apps that can display the contents of the file in rows and columns but if you want to be able to edit the file, you will have to use either Excel or Calc.

Get daily tips in your inbox Newsletter Join 35,000+ other readers ← How to compress an MOV file → How to set up high-refresh rate monitors on Linux Read Full Bio Fatima Wahab

Fatima has been writing for AddictiveTips for six years. She began as a junior writer and has been working as the Editor in Chief since 2014. Fatima gets an adrenaline rush from figuring out how technology works, and how to manipulate it. A well-designed app, something that solves a common everyday problem and looks

Latest from Author How to Get and Make Sticks in Minecraft Quickly Everything to Know About Windows Startup Folder