How to Convert CSV to TSV

Comma Separated Value files are often used to import data in a generic format into applications. Value data in the CSV file format is separated by a comma. The Tab/Text Separated Value file is another data file type, but with the TSV file type, value data is separated by tabs. Using your spreadsheet program, such as Microsoft Excel, you can easily convert CSV files to the TSV format.

Step

Right-click on the CSV file and click “Open With” from the context menu. Select your spreadsheet program from the list of available programs. For example, click “Microsoft Excel" to open the file in Excel. The CSV file opens in the spreadsheet program.

Step

Click the “File” option on the top navigation bar. In Microsoft Excel 2007, click the “Microsoft Office” button.

Step

Click the “Save As” option. The File Save dialog box opens.

Step

Click the “Save as Type” drop-down box in the File Save dialog window. Select the "Text (Tab delimited) (*.txt)" file type option, and then click “Save.” The CSV file saves as a tab delimited data file with a TXT file extension.