import from text file to excel not working properly

Question

We have just upgraded microsoft versions and for some reason the import is bringing headings in with it and I don't have the option to select 'PROPERTIES' as I assume the option to deselect headings is in there.

Is there a setting in the OPTIONS I need to change? or what am I doing wrong??

I selected Load To and the following options.

Help!!!

Thanks

Answer 1

You are using Power Query which has a lot more flexibility and options.

Combine data from multiple data sources (Power Query) - Excel

The data is imported into a table always, you can uncheck the header rows after the import.

Also, have a look into this article:
Power Query - How to import a CSV file that does not match your locale - Microsoft Community

Andreas.

Answer 2

Once imported you can hide the header:

Answer 3

You are using Power Query which has a lot more flexibility and options.

Combine data from multiple data sources (Power Query) - Excel

The data is imported into a table always, you can uncheck the header rows after the import.

Also, have a look into this article:
Power Query - How to import a CSV file that does not match your locale - Microsoft Community

Andreas.

Thanks the second part of your answer worked for us:

Long-time users know the text import wizard, it has been removed from the user interface, but is still available.
Here are the steps to get it back and how to use it.

Right click the Quick Access toolbar and choose "Customize the Ribbon"

In the Excel Options window choose the Quick Access toolbar (1) on the left, then "All commands" (2) in the drop down.

Click a command and press an I to jump down the list, scroll a bit and select "Import External Data" (3).

Click the Add button (4) and you get the icon (5) on your QAT. Click Ok (6).

And the icon will appear on your QAT

Answer 4

Please have a closer look into my articles. There is a reference to the Text Import Wizard too. .-)

Text Import Wizard - How to import a CSV file that does not match your - Microsoft Community

Andreas.