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
