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.

 

[shg]

If you do Data > From Text, you have the option of selecting the start row.

 

[plasticinhialeah]

Where is that option on the popup window?

 

[shg]

In the dialog after you select the file to open.

 

[Fluff]

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

 

[plasticinhialeah]

Excel 2019 doesn't have a wizard for this feature. You just click 'transform data' on the import popup window and a query editor opens with all the functions to edit the selection. Here's a screenshot.

Where's the option for selecting the first row in the query editor?

 

[Fluff]

Have a look here
https://support.office.com/en-ie/article/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857

 

[plasticinhialeah]

Where's the "start import at row" option?

 

[plasticinhialeah]

Where is the "start import at row" option in Excel 2019?

 

[Fluff]

Did you follow the instructions in the link I supplied?