Import Text files into Excel [5 Methods]

5 different methods to import text files into Excel are explained in this video.
Topics discussed
- 2 simple methods to open text files in Excel
- Import Single as well as Multiple Text files into Excel using Power Query
- Import Text file into Excel using Power Pivot
- Macro to Import Text file into Excel

#ImportTextFileintoExcel #ImportTextFilePowerPivot

[jagan]

Thank you. Your video saved me tons of time

[dhruwalbhimani]

Thanks man! You saved my time and effort

[Benjamiranda]

Thanks for sharing your knowledge.
Greetings from Mexico!

[pattabhiyvv]

Your efforts and knowledge sharing is commendable. Best wishes

[Mileisha_Lyann]

What if I would like to separate each Point into a different column? They all have the same x values but different Y values. How would I do that?

[CaelestsFilius]

Who's ever seen a txt file that clean?

[vru]

I am facing issue for decimal values like 1.00/0.00 its coming as 0/1 in excel

[ikjeuhw]

I have a exported report and when I do all are imported to a single column and I needed to do the text to column ... Any solution

[maxw]

Thanks for the nice vid! I have one question though...Do you know how i can put the text-files next to each other? So when I import multiple files with PowerQuery each file gets the next like 3 columns.
Greetings from Germany!

[arshiyakhan]

What if i have 17lakhs data in notepad i want to convert that data in excel excel contains only 10lakhs number each column.pls reply