How to Convert CSV to TSV

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

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.

Video of the Day

Step 2

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

Advertisement

Step 3

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

Advertisement

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.

Video of the Day

Advertisement

Advertisement

references