What is a TSV

TSV (Tab Separated values) is a sister format of CSV (Comma  Separated Values) files. TSV files can be opened up using Excel, just like you can open CSV. There are two ways to open TSV files in Excel.

• Open Excel, and just drag and drop the TSV file into Excel

• Setup Windows to open TSV files

Right click on a TSV file (file with .tsv extension), and select Open With option. If you don’t have a TSV file, just create an empty file with name test.tsv

Open

Click on More apps

Open

Click on Look for another app on this PC

In the file select dialog box, search for excel. In the search results, select EXCEL

After this all your TSV files can be directly opened with Excel, just by double-clicking on the file

Saving TSV Files using Excel

In Excel, select Save As. In the drop down shown for selecting a file format, select Text (Tab delimited) (*.txt). You may choose to rename the file with .tsv extension. E.g. sales.tsv