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

[@il_Presepe]

Thank you! Straight to the point and well presented.

[@andrewlavalle88]

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

[@vamsisairaam2728]

I have 30 files in each file there are 5 sheets in that I need only A1 to A30 cells data in sheet 5 of all 30 files into a single table will that be possible please tell me if there is any simple way Thank you

[@fortunepeter6766]

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

[@zebulonspruijt1645]

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

[@JohnS-er7jh]

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).

[@nawratanbachhawat]

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

[@kundanvispute2281]

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

[@chien533]

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.

[@thenissarahamed]

Amazing -- thank you so much for this.

[@logistics7782]

Thanks a lot a simple way of teaching excellent

[@daylightstalker8676]

Thank you saved me a lot of hours doing excel works

[@emmashot5036]

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

[@sairamvemula708]

Thank you straight to the point

[@Rabbitsgal]

This is so very helpful!!! THANK YOU!

[@usamarketingpros]

Great video, much appreciated!

[@sarvottamvlog]

Thanks mate it was helpful.

[@arowgain]

Solved my biggest Problem. thanks for making this video

[@doallamani1603]

Thank you very much for this video

[@med-lek]

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

[@dipakhadawale3673]

Which xl version u have used?

[@desaidushyant]

Thanks This is great help

[@sudhanshusrivastava1776]

Thank you so much sir. This is very helpful.

[@jackjobriencorso]

thanks for makin it simple and short

[@VlogifyMuskann]

Perfect!! Thankyou ❤️❤️

[@oklangeneralsupplies2262]

Easy to follow along...thank you

[@MITutorials]

You’re welcome 😊

[@routhuaravind6006]

it works for me, Thank you

[@annaluksu6937]

Thank you a lot ☺

[@revanthchowdary7856]

Thanks for saving a
Lot of time

[@Jackmackrel]

Awesome!!!! thank you!!!

[@pawandholwade440]

Thankyou sir, it's helpful

[@NURULATIRAHBINTISAMUNTechnical]

Thanks!, help me alot

[@mikeogieriakhi3394]

When I tried loading the multiple files, I get "Download failed" error message, so what's the problem and what should I do, please?

[@tagadirika2145]

nice and easy... thanks

[@LubosTichy-ce9wu]

For me working perfectly on the first try.

[@SermonsForLife]

Thanks!

[@ayushprajapati9251]

Thank you!

[@Lyahy9317Xxx-pp9qp]

Youre Awesome you made it so hopeful

[@vijayragavan7361]

Great .. thanks

[@devendrareddy491]

Most searched video
Thanq thanq .....

[@hajiso786]

Thanks a lot

[@Thalakodhum]

Thanks so much

[@andyvancephoto]

dude! you nailed it! talk slower for the ones who are slow. lol

[@user-nl5dm4dq1h]

Hello Sir,
We have a folder in which we have 150 no. of excel files & all these files data is being stored in a different master file using get data from folder option.
Each time when we are changing the data in these files same thing is updating in master file. It is simply over writing the same. Is there any option so that we can add on the change instead of overwriting.

[@stevejonathan_14]

Thank you

[@rohithg5654]

Thank you ..

[@rizwanwaheed3073]

thank you

[@MaytheLordbewithyou2]

Thank you so much

[@MITutorials]

You're most welcome

[@chenyaohui4573]

It useful in my work

[@samsuntalukdar6118]

I never comment on TH-cam videos, but thank you, thank you, thank you!

[@MITutorials]

Glad I could help!

[@RenuSharma-yo1js]

Thanks sir

[@tanu131088rawat]

Thank you so much for this helpful video but in my excel I am facing a issue. It is showing an errow : "External table is not in the expected format." Please help me for this

[@kumarv9672]

It is work on older version?

[@prasannas8836]

I don't have get data tabs

[@feloniousmonk321]

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.

[@jspee1965]

Yeah browsing to the file folder shows and empty folder.

[@elishbarajesh8265]

This is extracting excel file into one excel , not excel sheets. Maybe if you knew how to search properly you’d get the right video

[@akshar1109]

Where to find right onee

[@livekhushal37]

At our office we use python code

[@CraigMasonUMaine]

Thanks! Very helpful. Note (if anyone has issues) it appears the sheets in each file need to be the same name.

[@anhnhatnguyet4628]

File A have 1 sheet. File B have 2 sheet. Need create file merge C have only 1 sheet with data of file A + B (3 Sheet into 1 sheet), use VBA, how ?

[@mister_bake2743]

thanks

[@dontsovcmc]

That is a version of Excel? Cant' find "Get Data" in Excel 16.32 2019

[@johnmartin2154]

It seems to be loading all the blank rows below my data per file and it’s overloading and erroring out. How do I work around this?

[@mehardi1]

i dont hv that get data tab in my excel

[@VIpanfried]

[Expression.Error] The key didn’t match any rows in the table.
What’s the key??

[@swapnilkudale27]

I want to add three workbook into one workbook ..in three diff sheets..how to do that

[@ajeetpratap2151]

How can i use same thing in excel 2014

[@marionegodias8015]

Save my time :D

[@fatimachoonara1337]

Mines gives an error "The data in the preview has been truncated due to size limits." How do I fix this?

[@syedrayan2393]

can i have the master file with code

[@excel_tech5422]

If it binary files?

[@CMichaelLyle]

All my column names are the same but I'm getting an error message that reads: expression error. The key didn't match any rows in the table.

[@sianjombz9596]

Did you manage to solve you issue here? If not the problem is with your sheet names. You need to name them the same. from both or all files.

[@niravshukla6999]

what if i want it in multiple sheets

[@suvendubiswas3978]

In my excel, that "Get Data" button is not there at all! Help out please

[@AnnoyedBigWaterfall-zc8vd]

But it only works when colum datatype and column name are similar

[@AkashMishra0021]

Sir Microsoft 365 meh option hi nahi hai,Get data > From File ka, pls help

[@user-vk6nb2nt4x]

How to get folder option😊

[@danielgolmohammadi]

You did not hit ok, it does not work the way that it was explained

[@jjpierce6032]

Well of course it didn't work for me.

[@Erqin]

this is appending, not merging. name it precisely.

[@ajitfeb04]

your vedio is for merge but you teach for combine. This is not very good. both are different, be specfic as per your topic.

[@bboyrjk]

its such a shit feature, Why Microsoft makes it so difficult everything!

[@gentleboys31]

thanks sir , this is the esiest way

[@AshokKumar-qh5vc]

thank you

[@MrSo24so]

Thank you 🙏🏼

[@MITutorials]

Glad it helped.. Jzk

[@allinone5star]

I don't have get data tabs

[@stargalaxy308]

thank you