Powerful trick to combine all Excel files in a folder AUTOMATICALLY

Need to automatically combine all files in a folder to One Excel workbook? You are going to love this *completely* automatic way. This simple but insanely time saving trick uses Power Query to combine files in a folder.

In this video ⏱👇
==============
0:00 - Introduction to the combine files problem
0:36 - A quick look at the folder & one of the files
1:10 - Combining the files with "Get Data → Folder" option in Excel
2:36 - Cleaning up the file data with Power Query rules
5:32 - Loading the data to Excel
5:55 - What happens when you add files to the folder
7:08 - How to learn Power Query

Sample files 📂
============

Watch next 📽👉
==============

Credits:
======

Have an awesome day 🌞🌼😀

[briandelaney]

Wow that's synchronistic. I was looking for exactly this yesterday evening for a project. Thank you Chandoo 😁😁

[saipranityellajosyula]

This video just saved my day from combining data from 53 excel folders data into 1 file. Thanks a lot _/\__/\_

[minimalist]

Hi Chandoo. I had a side project at work lying around for literally 1 year. Your super concise video was a Eureka moment for ne. Happy I watched your PowerBI & PowerQuery vids and stumbled across this huge gem! Thank you, Chandoo!

[awesome_uk]

Another great tip. Thank you Chandoo. This will actually help me combine my monthly close down data with less effort. This is really awesome! Never thought about it. More I say thank you less it will be for your effort in teaching Excel.

[sounduniverse]

You people are real heroes. Many institutions are charges thousands of rupees for this. And i don't think Youtube pays similarly, but you choose this option. you literally own me

[shristeekashyap]

You have made it so easy to understand. Thanks a lot😊

[wayneedmondson]

Hi Chandoo. Another great tutorial! Love everything related to Power Query. Thanks also for providing the sample data to follow along.. very helpful! Thumbs up!!

[livefognik]

Thank you so much. Have to combine over half a year's worth of data in files for each month. All from a customer that sends in 1, 2 or sometimes even 3 files a day. Will take me hour to make the invoices tomorrow not days. Thank you so much!

[DarrenStarr]

Thank you Chandoo, this video was very useful and saved me a ton of time. You are brilliant my friend!

[abdulazizahmed]

WOW i was searching every where to have this, you just make easy, Thanks Chandoo

[miguelgaitan]

Extremely helpful and informative video. Thank you Chandoo. Well Done!

[TP]

Straight to point, and straight to point, then some more straight to point. This is what I always look for. Thanks.

[SoNoFTheMoSt]

really well explained, thanks so much and its so amazing to just put a file in and it updates!

[vijethamuppala]

Thanks a lot
It helped me a lot today for consolidating the data .

[RaviKumar-gzmy]

The way you explain is excellent. You make tougher Task to Simple. Great. Appreciate.

[stuartmccloud]

Amazing! I didn't know this was possible, thanks Chandoo

[robinluvsrap]

Thanks Chandoo! this is really really helpful!!!

[asthajain]

you are awesome chandoo, i have find every thing for my project on your videos of power querry

[venkatyalamati]

Thank you very much for the awesome video... This is what I wanted ☺️

[MuhammadAli-vxqd]

Thank u it was gr8 to see u on YouTube I was one of the oldest lover of your excel tricks specially graph presentation