Import Text files into Excel [5 Methods]

No video

Import Text files into Excel [5 Methods]

Рет қаралды 66,895

4 жыл бұрын

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

Пікірлер: 22

@jagan1991 3 жыл бұрын

Thank you. Your video saved me tons of time

@AjayAnandXLnCAD 3 жыл бұрын

You're welcome!

@Benjamiranda 3 жыл бұрын

Thanks for sharing your knowledge. Greetings from Mexico!

@AjayAnandXLnCAD 3 жыл бұрын

Glad it was helpful!

@MagicalStoriess 2 жыл бұрын

Thank you Sir for saving my time.

@dhruwalbhimani648 2 жыл бұрын

Thanks man! You saved my time and effort

@shrishdev1396 11 ай бұрын

Very help full video

@pattabhiyvv 4 жыл бұрын

Your efforts and knowledge sharing is commendable. Best wishes

@AjayAnandXLnCAD 4 жыл бұрын

Thank you Sir 😀 3 out of the 5 methods explained here, I learned it from you.

@CaelestsFilius 2 жыл бұрын

Who's ever seen a txt file that clean?

@Mileisha_Lyann 2 жыл бұрын

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?

@johnpaolocaintic6714 3 жыл бұрын

Thanks, Anand Viswanathan

@user-ik4je8uh2w 2 жыл бұрын

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

@maxw5296 3 жыл бұрын

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!

@OwenFenech 3 жыл бұрын

Have you by any chance found a solution to this problem?

@MrWnw 3 жыл бұрын

@@OwenFenech I am in a need too

@Mileisha_Lyann 2 жыл бұрын

Need this info!

@arshiyakhan4401 3 жыл бұрын

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

@AjayAnandXLnCAD 3 жыл бұрын

You cannot load 17 lac Rows of data into Excel, but if you are looking to analyse that data, Power Pivot or Power Query in Excel can be of help. Power Pivot in Excel is designed to analyse millions of Rows of data from different data sources.