Import data from text/CSV without headers?

[plasticinhialeah]

I use Excel 2019 and I'm trying to import some data from text/CSV, but the data I'm importing has headers, and I don't want them. Is there a way I can remove the headers and their formatting from the text before importing? I don't want to just delete the row with the headers after I import the text.

 

[sandy666]

I'm not sure about 2019 but...

 

[plasticinhialeah]

Yeah, I don't think 2019 has that Wizard. It just has a Query Editor that has all the "Transform Data" options in different tabs.

 

[sandy666]

did you try Alt+A+FT ?

 

[plasticinhialeah]

You know, for the purposes of this thread, I think it would be easier if I just got an answer from someone who uses Excel 2019, since it seems the process is much different in 2019 than in previous versions.

 

[sandy666]

first try then type

 

[plasticinhialeah]

On which menu do I press the shortcut?

 

[sandy666]

doesn't matter, just use it

or try

Click on “File” –> “Options” –> “Data” and set the corresponding checkmarks for reactivating the “Text Import Wizard” in Excel. Start the text import by clicking on “Data” –>”Get Data” –> “Legacy Wizards” –> “From Text (Legacy)”.

 

[plasticinhialeah]

The shortcut only seems to function similarly to selecting the "from text/CSV" option, and there are no legacy wizards in that menu as far as I checked.

 

[sandy666]

if you don't know where is it in Options:

edit:
maybe Excel should be restarted

btw. I uninstalled Office 2019 because it was useless for me and I will wait for 2020

 

[SpillerBD]

Sandy's post #19 has the additional information needed to reactivate the legacy Wizards in the menu. The Get and Transform method is better (in most cases) once past the learning curve.
Once the Legacy Wizards are activated through the application's options, an additional sub-menu will be available for the various Legacy wizards activated in the options.