How to Convert CSV to TSV

By Tammy Clevenger

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.

Things You'll Need

  • Spreadsheet program installed

Step 1

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 2

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

Step 3

Click the "Save As" option. The File Save dialog box opens.

Step 4

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.