Hi You have an option in Excel to import the Tab Delimited txt file and show its content in Excel.

Tab separated text file format. Often you need to import data to the Excel spreadsheet from a text file. Two examples will be shown. I could do it for a ASC textfile by setting FILETYPE ASC but I couldnt do it for a tab-delimited textfile by setting FILETYPE DAT.

How To Use Tab Separated Value TSV Files. The tab character separates fields the carriage return character separates records. Comma separated values text files csv in which the comma character typically separates each field of text.

This allows you to make any change to it from Excel and save it which is kind of. Microsoft Excel offers a Text Import Wizard to import data from different text file formats. This will download the currently selected sheet as a tab-separatedTSV.

Choose Text CSV csv in the Filter selections and check the box Edit filter settings If you want the file extension to betxt uncheck Automatically select filename extension csv and add the extension to the filename you are going to save to. Save an excel worksheet automatically as a tab delimited text format. This document specifies the tsv file format.

PDelimiter As String to. Some feeds use comma as the delimiter or separator. Delimited text files txt in which the TAB character ASCII character code 009 typically separates each field of text.

Tabs in fields are converted to spaces. This video shows how to covert a text file that is delimited by tabs to a excel file with the values separated into columns. The field separator is t tab The record separator is n newline A field is any string not containing tab or newline characters tn.