Powerful trick to combine all Excel files in a folder AUTOMATICALLY

[@briandelaney6354]

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

[@chandoo_]

What can I say.. I read your brain Brian 🤣

[@briandelaney6354]

@@chandoo_ 😄😄

[@sounduniverse9060]

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

[@shristeekashyap1779]

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

[@TP014563]

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

[@chandoo_]

Thank you TP.

[@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!

[@RaviKumar-gz9my]

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

[@MuhammadAli-vx6qd]

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

[@asthajain7093]

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

[@abdulazizahmed7035]

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

[@raj2016]

I'm following your daily dose from 2013 frequently happy to see u finally on you tube. 😀

[@miguelgaitan1630]

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

[@shriidharkulkarni6648]

That is really awesome... You play with Excel as Sachin Tendulkar used to play with a cricket ball. Watching your videos is a pure pleasure. Thanks a lot.

[@89minimalist]

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!

[@pulkithappy1897]

@chandoo, your tutorial was great. Especially, the sound effect at 3:55, it brought my attention back 😅

[@jamiereife5581]

I do this all the time. Huge time saver and makes me look good 😊 I always keep the source file name until I know for sure that I do not need it.

[@saipranityellajosyula8008]

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

[@robinluvsrap]

Thanks Chandoo! this is really really helpful!!!

[@DarrenStarr]

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

[@vijethamuppala5618]

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

[@jamanemon2110]

It was really helpful. Thank you Chandoo👏

[@RaviKumar-gz9my]

Thank you Chanoo I followed all the steps. It works provided after changing the name of the all the Sheets in a folder to same name [ Example: Data]]. I have the files but Sheet ina file different.

[@viswanathan19]

Long wait is finally over. Thank you for your help.
Request you to help with an idea to copy specific cells from multiple workbooks in a specific folder

[@chandoo_]

Thanks Viswa.
Please refer to this advanced example for specific cell situation - chandoo.org/wp/combine-excel-files-using-power-query/

[@roes5654]

Commeting before watching ☆ Looks promising

[@wayneedmondson1065]

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!!

[@chandoo_]

My pleasure Wayne.

[@andreas_Salve]

Wow That's a nice knowledge. Thank you Chandoo sir 👍👍👍

[@hariniharnath9932]

Superb Chandoo.Very Useful

[@chandoo_]

Thank you so much 🙂

[@satishojhaMrblank]

Thank you very much Chandoo.

[@honnurswamy6292]

Your teaching style it's very unique sir.... 🤩. Helpful tips

[@chetrana8314]

Excellent Chandoo.

[@chandoo_]

Thank you Rana.

[@SoNoFTheMoSt]

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

[@a.j.wilkes6352]

Great tip. I was blown away when I first saw this. I work in accounting, and getting people to stop having 40MB Excel workbooks because tab 1 is 800k lines of data instead storing data as period CSV files in a folder called data, is my calling. :)

[@chandoo_]

Wow.. 800k lines per tab... 😮
You are going to LOVE 💚 Power Query.

[@CaribbeanQueen07]

Excellent teacher. Thank you !

[@Soulenergy31]

Great tip Sen Sei!

[@HusseinKorish]

Amazing Explanation ... thanks Chandoo

[@chandoo_]

You're most welcome

[@maziz6237]

Appreciate…Thanks a lot for sharing this EXCEL treasure….Excel never stops revealing itself . Brilliant MS-Office designers and explorers-people like Chandoo. Luv this creative single platform , enough to make n assist various careers.

[@chandoo_]

Excel is AWESOME 😎

[@NoelFerguson]

Thanks for this. Well done.

[@minhajshareef1180]

Sir, You are amazing and well explained information. Thank you

[@balamira297]

Excellent video sir! Chala bagaundhi.

[@chandoo_]

Thanks Mira garu...

[@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.

[@LearnAccessByCrystal]

very interesting, thanks Chandoo ... all ready to put into Access ;)

[@chandoo_]

Enjoy!

[@rosywild4774]

You are just amazing man

[@omkarshedge6065]

Thanku it helps a lot!. While others was using VBA Code for same process, but you taught us simple way to do this.

[@sujaynazare489]

This was amazing! Thank you!

[@chandoo_]

You're so welcome!

[@Kiara0101]

I am in love with this tutorial¡

[@jibinreny6030]

Thankyou so much, this would save me 1 hour

[@chandoo_]

AWESOME 😎

[@rdnyman]

Great video! Thanks for posting!

[@anandtaori6569]

Superb...Saved Time

[@mandara8315]

Super...thanks a lot chandoo!!

[@chandoo_]

You are welcome Mandar. Don't forget to share these amazing tricks with a colleague or friend. Light up their day.

[@Seftehandle]

This is the best vid on the power query topic

[@chandoo_]

Thanks Tina... 😀

[@stuartmccloud307]

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

[@dynamictechnocrat]

This guy is really good it's a pity I don't really use excel would have bought his course .

[@baimeiguo6960]

Thanks a lot, you are wonderful!!! Thank you Chandoo 😁😁

[@chandoo_]

So are you...

[@ramses2]

Thank you Chandoo,

[@anoopx5]

Thank you soo for your valuable tips..

[@ihgamingfun6295]

Informative video 👍👍

[@saloriasaxon7323]

APPLAUSE APPLAUSE SIR! Yet another great video using combine and queries!!👏👏🎉🎆🎇

[@chandoo_]

🙏 Thank you Saloria.

[@alanlamb6047]

Hi Chandoo and comment readers
I'd like to suggest a a minor change that yields a neater approach.
PowerQuery EXPECTS you may want to transform each file
So, start by working on the Transform Sample File, use the built-in feature to remove top rows, promote headers etc
PowerQuery will then automatically update the Transform File function
Now you you don't have to faff around filtering out the blank rows and extra heading rows in your main query
(Also, if the specification changes, you only need to review and update the Transform Sample File)
And, thank you for taking the time to keep posting great Excel videos.

[@mangeshbarve1751]

This is the best way...

[@chandoo_]

Great tip on Transform Sample Alan. Donut for you 🍩
While I am aware of this, I didn't show it for a reason.
> Transform sample & transform functions are somewhat tricky to explain. So I wanted to cover them in an advanced future video
Here is one example of the AWESOME power of Transform functions - chandoo.org/wp/combine-excel-files-using-power-query/

[@sunnypandit8033]

Sir, You are Amazing 😍

[@Hopspowered]

Thank you Chandoo!

[@shakeel778]

Thank you so much its very helpful for it was saved my time during my heavy load work 👍👍👍

[@venkatyalamati3285]

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

[@sivannatarajan7]

Wow, you are a magician 🙏

[@chandoo_]

🎩🐇💥

[@udhayakhanthl6464]

Thank you so much. This is an extraordinary.

[@vaibhavthakur_1997]

Thanks chandoo ji🙏

[@PeterLawrence193]

Great Video. I tried with my own data and it worked after my 2nd try. And I know I will be able to save 40 minutes at the financial month end

[@chandoo_]

That is AWESOME to hear Peter...

[@ultra332211]

Thanks, Chandoo - I want to give 100 marks to you for this fantastic data analysis video 📹

[@chandoo_]

Thanks Manzar 😀

[@TimEllisWW]

Just like that 15 files into one. Thanks, great explanation.

[@chandoo_]

You're welcome!

[@hanhnguyenhong3039]

woww, this way is so perfect and magination

[@GoldenSlumber474]

Another useful & awesome tip! I have a huge file with multiple data sheets I plan to consolidate with this method. Thanks Chandoo!

[@chandoo_]

Glad it was helpful!

[@hazemali382]

No doubt Power Query Amazing powerful Tool 🤩

[@shoppersdream]

Nice, thanks!

[@reshmajoshi7115]

Wow well explained sir thnk u

[@chandoo_]

You are welcome Reshma.

[@amjadansaree]

thanks sir ........ very useful tick ......... wow....😲😲😲

[@chandoo_]

Most welcome

[@mrrishiraj88]

Great intro!
😇👍

[@chandoo_]

Thanks Rishi. I love LEGO and couldn't resist adding them to my videos every now and then.

[@sujitdhas174]

Thank you Chandoo Lots of love from seawoods darave which is located in Navi Mumbai ❤❤

[@egmedo1407]

Thanks Chandoo

[@rameshharidhasa7107]

Nice explanation using the futures of powery query in excel.Thank you.😉💝💝💝

[@chandoo_]

You are welcome

[@FRANKWHITE1996]

thanks for sharing

[@chandoo_]

My pleasure

[@sakibahmed1815]

Thank you for providing the zip file to practice .

[@chandoo_]

My pleasure.

[@nafiurpial7209]

Awesome!

[@alysonjwilson]

That’s awesome! Thank you 🤩

[@krimlinturhks4651]

Mabrook!!! Thanks man!

[@chandoo_]

😀 You are welcome...

[@stevenperry7041]

Yours is the forth video I've tried. Three failed. You, however, said (approximately) "select only, do not open." And that made all the difference. (I was double clicking.) THANK YOU for paying attention to the little things... things that can totally frustrate.

[@mikemason964]

You are the man. Thanks !!!!!

[@FaysalEasyExcel]

Great video. thanks for sharing sir.

[@chandoo_]

Thanks for watching!

[@aw1961utube]

Chandoo, it is great, but can you tell me if I use Excel on Mac can do?

[@syedmubashir9594]

Thanks 🙏

[@michaelhogan1887]

Thank you for the video, do you know how to this on a Mac? I only have the load option.

[@Radhakrishnasandha]

Hi chandoo sir,... Thank you so much 💗

[@chandoo_]

Most welcome

[@sumardjo]

thanks for you knowledge
file sample is very very good
for practice to learn
thanks

[@chandoo_]

It's my pleasure

[@mjmousavin6865]

آقا ممنونم از لطفت.

[@daFrimpster]

You Rock! Thanks

[@bittujha2890]

Hi Chandoo - Many thanks for posting this video. Many I request you to pos something to how to get rid of helper queries while combining multiple xlsx file? As there are several video that talks about combining csv file and show the steps get rid of helper queries but not with xlsx file

[@عبدالروؤفاحمد-ب5ه]

wonderful boss

[@chandoo_]

Thanks for watching

[@sarasuselvaraj8643]

Hi Chandoo.
You made consolidation very easy and Awesome.
I have 1500000+ rows of data in three excel with same format. Could you please help me out with getting all these data in single sheet for analysis & comparison study.

[@mbaftab]

thanks a million

[@srisudharsan4169]

How did You learn so much like this brother. It's really interesting to learn Excel from your videos.❤️❤️❤️❤️🥳🥳

[@taizoondean689]

Thanks sir 👍

[@chandoo_]

Most welcome

[@alwulhan]

This is awesome 👍. I wish you have published this video few weeks ago. I was modifying files one by one and then append queries 😅

[@chandoo_]

Better late than never. 😀

[@mrunalrocks1707]

You're a god