Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

Download Excel Files:

See how to use Power Query (Get & Transform) to import multiple Excel Workbook Files with Multiple Excel Sheets into a single Excel File in two different situations:
1. (00:18) Introduction to Append Multiple Workbooks and Merge Multiple Workbooks
2. (01:58) Append Multiple Workbooks into a single table from Multiple Excel Files, and build PivotTable using Power Query From Folder feature. See how to extract File Name and Sheet Tab and incorportate them into the Data Set.
3. (16:10) Build PivotTable
4. (19:30) Add new files to folder and PivotTable updates.
4. (20:36) Merge Multiple Workbooks into a single table from Multiple Excel Files using Power Query From File feature.
5. (24:38) Create Formula Helper Column in Power Query and learn about Number.Round Power Query Function
6. (29:18) Summary

How to create a PivotTable from two separate data sources? How to create a PivotTable from two separate excel workbooks?

[AliouneMNdiaye]

I cannot tell you how many times you have saved my life...Keep up the good work!

[geraldsullivan]

You may not believe this but I came across this video earlier this week and yesterday I was asked "Is there any easy way we can append several files into a single file without having to copy and paste the data?" I gave a wry smile and said "Yes there is." Thanks a million for this and all the other great videos.

[wzguitar]

I was almost ready to use python to export and combine multiple excel file into one, and here comes your video. save my life...thanks a bunch

[waverider]

I love watching you go through the steps one by one with your awesome commentary. Even though I've been using power query for a few years now and I've been combining files for a little while, I learned three new things: shift clicking columns before removing other columns results in columns in the selected order (AWESOME - eliminates a reorder columns step), Excel files can't use the double drop down combine binaries (I never understood that until now), and row labels in pivot tables can be changed to actual row names via show tabular format. Just awesome!

[gaylecox]

You are making my life so much easier with your wonderful clear informative videos :) I love your clear explanations and the fast pace. Thank you so much for sharing your knowledge I come back to them again and again :)

[nagizadeorxan]

Very clear, easy and informative explanation. Thank you for all your efforts.

[deninsrmic]

Great tutrorial video Mike, combine and merge of tables in one go its brilliant. Your revenue calculation with Number.Round "Number.Round(([Units]*[Price])*(1-[Discount]), 2)" brings back memories on your excelent Excel tutorials. Thanks and stay safe.

[lickablelisel]

Thank you so much for your very informative video. I was able to use this at work.It made me the hero for the day!!!

[nathannakamoto]

this...I need to test it, but this may have solved a problem I've been experiencing for a long time. Thank you so much

[hiteshraja]

the Excel.workbook formula has worked wonders for me

[rkeithchampion]

Very good presentation. I like the fact that you keep moving. Many YouTubers will repeat or expand on the explanation forgetting that if we missed a key detail, we can pause and rewind to see the steps again. I've been looking for how to append and learn more about Power Query. Two birds with one stone.

[rochdi]

NICE VOICE IN PLUS THE KNOWLEDGE VERY NICE
BESS YOU

[HammerHeid]

I have watched many videos from your series and channel amongst others. I can say that your content, format, instructions and production quality is second to none, well done absolutely tremendous, if you are not a YouTube millionaire then there is something wrong...

[mailinh]

cac vid cua ad thuc su dinh qua a, nhieu kien thuc bgio em moi biet do a ma giong noi cua ad rat de nghe va hay nua nen la rat thich xem vid cua ad a em gan hoc xong vid nay roi

[ahmedal-dossary]

Just looking for PQ solution and saw your video explaining this in an extremely amazing way.

Thanks a lot Mike

[NoShadowOfDoubt]

Power query, pivot and data modeling are a lot more fun and useful to learn and better than learning some of the reporting tools that come with some ERP systems. I love your work.

[johnwong]

Again and again always found something useful from ExcellsFun! thanks.

[ambiel]

What an amazing video. I've watched this video at least 10 times. Thank you.

[ennykraft]

Another fantastic video! Thank you so much! When it comes to Excel, you're the best!!!!

[jasonm]

Thanks. I have been trying to figure out how to have the repeated file name in a column for the longest time.
Good work.