Import tab delimited text file into excel 2019

Describes how to import a tab-delimited text file into Excel 2019. Shows how to treat column headings properly, and create an excel table with column headings.

[@nigelfearn3121]

This sounds great, what a star this fella is ! ! It's something I've been trying to figure out for years.Thank you.

[@whocarse1999]

You're a life saver man.

[@talek77]

Thanks so much.

[@mufazahd2782]

thanks, I didn't know how to do that before

[@caxter618]

I am not getting any interface after I select a .txt file and click on "Get Data". Nothing happens. Can you please help.

[@prashanthkondaparthi9778]

I am getting only 2 columns how can I get 3colums while importing text file from Cochrane

[@daviman4290]

Great

[@nikhilbhosale8279]

1:00

[@marcel106]

And how can I just remove the Header and import only the files?

[@nikhilbhosale8279]

0:07

[@huyenngo534]

hi, i don't want to get data to new sheet, I want to get data from the text file and fix it on a sheet. how to do it?

[@phongtranquoc7557]

bạn làm đc chưa chỉ mình với

[@nikhilbhosale8279]

1.00

[@nealwright5630]

Microsoft is such a joke!! Excel copies and pastes in TSV!!! Yet it doesn't recognize a TSV file and forces you to convert it when opened!!

[@nikhilbhosale8279]

0:42