26th November 2019


What is a tab delimited text file?

A tab-separated values (TSV) file is a simple text format for storing data in a tabular structure, e.g., database table or spreadsheet data, and a way of exchanging information between databases. Each record in the table is one line of the text file.

Also, what is a delimited text file?

Most database and spreadsheet programs are able to read or save data in a delimited format. A delimited text file is a text file used to store data, in which each line represents a single book, company, or other thing, and each line has fields separated by the delimiter.

How do I open a tab delimited file in Excel?

Open tab-delimited TXT or CSV file in Excel or Open Office Calc
  1. Start Open Office Calc.
  2. Go to File > Open.
  3. In the Files of type: drop-down menu, choose Text CSV (*.csv; *.txt), which is in the section that begins with ODF Spreadsheet (*.ods)
  4. Select the file and click Open.
  5. In the Text Import dialog, choose the following settings and click OK.

What is a comma delimited text file?

A comma delimited file is one where each value in the file is separated by a comma. Also known as a Comma Separated Value file, a comma delimited file is a standard file type that a number of different data-manipulation programs can read and understand, including Microsoft Excel.
Write Your Answer


100% people found this answer useful, click to cast your vote.

5 / 5 based on 2 votes.


Press Ctrl + D to add this site to your favorites!