Merge Multiple Excel Files into 1 File in just few Seconds !!

Using Power Query Merge Multiple Excel Files into one single File in just few Seconds !!

[chien]

Very helpful. A reminder for other users: the folder can only contain the files that you want to combine. All unrelated files should be removed, including those in sub-folders; otherwise, the combination will be failed.

[andrewlavalle]

Thanks! Awesome tutorial for those of us who are excel challenged. Super easy!

[nawratanbachhawat]

Thanks dear for the Merging multiple excels in one file.. Gratitude

[il_Presepe]

Thank you! Straight to the point and well presented.

[zebulonspruijt]

Exactly what I was looking for. Thanks a lot, sir!

[daylightstalker]

Thank you saved me a lot of hours doing excel works

[JohnS-erjh]

thanks for the helpful video. What about if you want to do a merge of multiple files but then keep the source file worksheets in separate worksheets on the target (merge) file, can this be done with the merge tool (or do you have to write a VBA code macro) ? I am working with multiple files so doing a Macro wizard is not something I want to do (but I guess if the Merge tool will not work in this case, I will have to research how to do this in VBA in the Code Editor).

[sudhanshusrivastava]

Thank you so much sir. This is very helpful.

[kundanvispute]

This is called sidhi baat no mins me properly bataya bhaine....thanks for such informative content 😊

[arowgain]

Solved my biggest Problem. thanks for making this video

[logistics]

Thanks a lot a simple way of teaching excellent

[fortunepeter]

I have been looking for this All this while, thank you so much sir

[samsuntalukdar]

I never comment on YouTube videos, but thank you, thank you, thank you!

[med-lek]

On Mac version option "get data from folder" etc is invisible. It's working only on Excel in Windows version.

[feloniousmonk]

Can't believe how difficult it is to find a tutorial on how to combine different sheets into one workbook - one that actually works. This isn't it.

[emmashot]

Thanks a lot man. You saved me some 30 mins. <3

[LubosTichy-cewu]

For me working perfectly on the first try.

[thenissarahamed]

Amazing -- thank you so much for this.