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.

 

[doo_doo]

I find it comical that there are a lot of comments on here but NO-ONE is giving a viable answer.

Just below The "Delimited" & "Fixed width" options on the first page of the wizard.

there is nothing there that has anything to do with excluding headers from the import.

 

[Fluff]

there is nothing there that has anything to do with excluding headers from the import.

Actually there is

 

[SpillerBD]

The missing part in #7 may have been pointing the link to the "newer" versions section of the web page.
Legacy Import Wizards NEWER Versions
The Legacy data import methods still have a valid use despite the better ETL of PowerQuery.
There was a lot of frustration obviously for both the OP and contributors on this thread.