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
Setup Windows to Open TSV Files
Right click on a TSV file (file with .tsv extension), and select Open With opetion. If you don’t have a TSV ile, just create an empty file with name test.tsv

Click on More apps

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
