Converting TXT to Excel (Column Headers)

Question

Hi all,

I am trying to convert a text file to excel using the 'Text to Columns' tool, but am unable to convert/keep the column headers as the tool only separates beginning on row 2 by delimiter.  See example below:

Data input

Output below

Any help appreciated!

benakesh · Accepted Answer

@tj3678 ,

Option 1:

Deselect  first row contains field names  and use  dynamic rename  to  change headings (take field names from first row) .

Option 2:

I see you have  \0  ( no delimiter)   for  delimiter  .  You can also use ';'  as delimiter  .