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

[@nawratanbachhawat]

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

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

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

[@daylightstalker8676]

Thank you saved me a lot of hours doing excel works

[@ArjunPatil-ml6xg]

Thanks bro.. I suppose to create macro but this is super easy steps. ❤

[@il_Presepe]

Thank you! Straight to the point and well presented.

[@logistics7782]

Thanks a lot a simple way of teaching excellent

[@zebulonspruijt1645]

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

[@style2970]

Thank You, this worked perfectly.

[@jackjobriencorso]

thanks for makin it simple and short

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

[@sudhanshusrivastava1776]

Thank you so much sir. This is very helpful.

[@arowgain]

Solved my biggest Problem. thanks for making this video

[@samsuntalukdar6118]

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

[@MITutorials]

Glad I could help!

[@Rabbitsgal]

This is so very helpful!!! THANK YOU!

[@revanthchowdary7856]

Thanks for saving a
Lot of time

[@pawandholwade440]

Thankyou sir, it's helpful

[@sairamvemula708]

Thank you straight to the point

[@ShortVideosTM]

Keep it up very useful video so ever

[@devendrareddy491]

Most searched video
Thanq thanq .....

[@sheikhmarzan9958]

thanks a lot, you're a genius

[@NURULATIRAHBINTISAMUNTechnical]

Thanks!, help me alot

[@fortunepeter6766]

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

[@VlogifyMuskann]

Perfect!! Thankyou ❤️❤️

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

[@someshmishra5653]

All of them have the same number of data what if a sheet has a different number of rows then how to do this

[@doallamani1603]

Thank you very much for this video

[@usamarketingpros]

Great video, much appreciated!

[@Jackmackrel]

Awesome!!!! thank you!!!

[@sarvottamvlog]

Thanks mate it was helpful.

[@routhuaravind6006]

it works for me, Thank you

[@med-lek]

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

[@desaidushyant]

Thanks This is great help

[@vijayragavan7361]

Great .. thanks

[@chenyaohui4573]

It useful in my work

[@Vibhujitiwari]

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.

[@tagadirika2145]

nice and easy... thanks

[@thenissarahamed]

Amazing -- thank you so much for this.

[@dipakhadawale3673]

Which xl version u have used?

[@emmashot5036]

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

[@VIpanfried]

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

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

[@LubosTichy-ce9wu]

For me working perfectly on the first try.

[@andyvancephoto]

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

[@oklangeneralsupplies2262]

Easy to follow along...thank you

[@MITutorials]

You’re welcome 😊

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

[@RenuSharma-yo1js]

Thanks sir

[@MrSo24so]

Thank you 🙏🏼

[@MITutorials]

Glad it helped.. Jzk

[@hajiso786]

Thanks a lot

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

[@annaluksu6937]

Thank you a lot ☺

[@kumarv9672]

It is work on older version?

[@m.n.953]

hi
i have 20 files with one sheet in every file . every sheet has deffirent name . how could i bring all the sheets from 20 excel files into only one file with the 20 sheets saperated in it. it means i can open only one file to work with those sheets . thanks in advance fore your help.

[@merajahmad7733]

I can't see combined and load after choose a folder can you help

[@fatimachoonara1337]

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

[@gentleboys31]

thanks sir , this is the esiest way

[@radhaganesan3336]

Can I remove the column A ?

[@swapnilkudale27]

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

[@CraigMasonUMaine]

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

[@dontsovcmc]

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

[@ajeetpratap2151]

How can i use same thing in excel 2014

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

[@rizwanwaheed3073]

thank you

[@mostainbillah]

Dear sir,
Need a Tutorial to get Specific range Data from multiple select file to Active Sheet ,
I have seen Many kinds of Video tutorials From your channel ,But i haven't Found As a Tutorial .
I Have a need : get Specific range Data as a Range (A29:D29) to Active Sheet From All selected Workbooks . And Past Active Sheet ,Destination Range (A29:D29) .xldown
Please help To get Tutorial or Code.
Please see my Request.
Best Regards
Mostain
Bangladesh

[@AnnoyedBigWaterfall-zc8vd]

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

[@suvendubiswas3978]

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

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

[@AkashMishra0021]

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

[@niravshukla6999]

what if i want it in multiple sheets

[@mister_bake2743]

thanks

[@jummydutta8114]

Please teach in Android mobile.

[@excel_tech5422]

If it binary files?

[@mehardi1]

i dont hv that get data tab in my excel

[@danielgolmohammadi]

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

[@Motiur-t6f]

How to get folder option😊

[@jjpierce6032]

Well of course it didn't work for me.

[@marionegodias8015]

Save my time :D

[@syedrayan2393]

can i have the master file with code

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

[@himanshubatrasuccessismine6578]

RUclipsr always welcome contact me

[@allinone5star]

I don't have get data tabs

[@ayushprajapati9251]

Thank you!

[@Thalakodhum]

Thanks so much

[@MaytheLordbewithyou2]

Thank you so much

[@MITutorials]

You're most welcome

[@stevejonathan_14]

Thank you

[@MeleMelelo]

Thank you!

[@javierbernardos8733]

Thank you!!!

[@stargalaxy308]

thank you

[@AshokKumar-qh5vc]

thank you

[@rohithg5654]

Thank you ..