Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

[@LeilaGharani]

Get access to the complete Excel Power Query course HERE: www.xelplus.com/course/excel-power-query/

[@xalidmlikov7322]

How to import live data excel to spreadsheet? Please help me

[@xalidmlikov7322]

My e-mail adress is [e-mail]

[@xalidmlikov7322]

Please help me

[@sustianrubel1808]

I wanna learn excel from basic to advance in a sequent. What playlist should I follow?

[@GiteshBajaj]

Can we import data from one drive folder insted of local computer folder.

[@wolfstream1]

I love the way you explain and turn complex matters into easy ones. You have a very good syntax, perfect diction and a very comfortable voice tone. Excellent in all levels. Thank you!

[@DebbieKinsinger]

You helped me overcome the fear and resistance I've had to learning how to use Excel effectively. I didn't even know that Power Query existed, and suddenly a world a pivot tables, grouping, and aggregating opened up where I could easily conquer my problems without even needing to use a formula. I could weep for the years of frustration and struggle seeing how easy you made this for me, in a few minutes. It's not just the easy to follow logic and excellent presentation but also your tone of voice that reassures me at every step that "This is easy I can do it". Thank you.

[@niranjankumarcoimbatore5842]

nice review....no weep...only sweep victory....

[@joescanlonh1365]

I've been looking for this exact tutorial, to combine non table formatted data sets from multiple file with bare cells above the excel data headers. This will save me so much time, Thank you so much. Cheers!

[@LeilaGharani]

Glad to help Joe!

[@sazopro]

You saved my life today! thank you so much! I'm a beginner in Excel and had work to do with a bunch of workbooks. Power Query made it easy!

[@jeanpoulin8787]

Awesome, the Power Query course is coming!!!! I just can't wait to learn it from you Leila!!!

[@LeilaGharani]

It sure is! I'm very excited. 😘

[@alexandriav3956]

I will forever go to your videos first when it comes to anything Excel related! I even watched your video on the Bing Chat and loved it! You're an amazing teacher and make your videos easy to follow and understand.

[@woljin]

Awesome tip. Always loved your tips but here's a tip for you. This method can not only load to a table but to a data model. You can target excel, csv or text files (if you don't have a SQL database available). If you pull your query into a data model and make a connection only instead of loading to a table, you can pull millions of rows that would never have been possible in excel before power query. You can then add M Code calculated cells (add custom column) to the table for any calculation you need on a row by row basis. Then load to the data model and make a pivot then add any relative measures you need for your selected groupings. In the end, you have a pivot table that has so much data that if you try to expand all, excel will ask you if you want to load all it can (because it can't load it all) but you can also see a snap shot of months or even years of data for thousands of employees at a time but still have the ability to filter down to a given day or even hour of that day. The best part is that once the data is loaded to the model you can share it and everyone that uses it will be able to filter pivots with no issues. They just can't refresh data unless the sources are in a SharePoint but that's not always needed for daily's or weekly's seeing you share every respective interval. It's really a game changer for big data. Hope you like my tip. Try it out and see how many records you can load into a model. My record is 1.2 billion. That's not really usable in any reporting idea but just a fun goal for testing. However, 1-12 million records in data model with like 10 columns and 10 calculated columns is easily usable. I have reports with 50 times that and they work wonderfully. The files are kinda large at 80-500 megs seeing each report has 4 or more of these queries with multiple relationships but they open in seconds and filters initiate in 5-30 seconds depending on the weight of the file. It's really awesome. Lastly, If this works well for you and you employ this method... Congratulations! You basically know Power BI now... Your welcome... Nah.... thank yourself... because if you played with this idea, you just basically had fun with numbers and mistakenly learned exactly how another major MS suite works... but that's the journey we all take :)

[@LeilaGharani]

Wow, that's a crazy record! Yes, loading as a connection and M are great tools.

[@Erethras]

Thank you. I had watched this video a million times, but finally came in handy at work. It has saved me so much time.

[@CJAKS1]

This is the best video on KZbin that explains how to do this. Thankyou for this!

[@Morgenj]

I always enjoy coming back to your videos if I need a refresher. You're an absolute superstar

[@jiajiaphotography]

I append tables frequently. This will make it much easier. And it's great to know that column order doesn't change how it appends. Thank you so much.

[@LeilaGharani]

Glad it was helpful!

[@cathyb2204]

Leila, you absolutely blow me away. I had no idea this was even possible.

[@LeilaGharani]

Glad to hear that Cathy 😁 Power Query really is Power.

[@reactionary]

I just subscribed, partly because i needed much of your excel knowledge, and partly because you are incredibly beautiful.

[@LeilaGharani]

Welcome aboard :)

[@paulkalra3372]

Threw me off with all the ifs and buts, pivots and transformations. I wish the video covered combining three identical data files with similar column titles.

[@MrSupernova111]

Pretty cool! I'm going to do this at work with about a 12 or so files that I must transform and combine every quarter. Currently, it takes upwards of 1 hour to do manually (its a lot of data). But I think if I use this method and save a template I can just refresh every quarter once I receive all the files for the project.

[@atul001]

This is my first lecture of Leila Gharani. But I am impressed the way she describe and show Power Query

[@rafaelnardi4915]

This has solved one big problem I have in my daily tasks. Thank you for the video, you are amazing

[@jmoralesg14]

Thank you Ms. Leila. Thanks a lot to help people to do better their office jobs.

[@LeilaGharani]

Our pleasure, Jorge!

[@NamanArya]

Leila, I could understand most of your videos but this one went over the head. Really looking forward to the power query course!

[@LeilaGharani]

Don't worry. In the course we'll start with the basics. It will make it easier to follow along.

[@YH-gp9hd]

Thank you! I had to pull together a few sale reports for a customer today, had find this tool very useful. However, I might have to practice this a few times to get it to work.

[@AutopilotAdventures]

This was amazing. Thank you. I googled around for this for months where every example was using VBA until I decided to search youtube and found your channel.

[@LeilaGharani]

Glad it helped!

[@rksenthilrajan]

Very easy to follow steps, great presentation. Thanks for sharing, I am trying to combine multiple worksheets, each work sheets having different header columns. For eg, Sheet 1 has A,B,C has columns. Sheet 2 has B,D,E has columns, Sheet 3 has A,CF has columns, Sheet 4 has E,G,H has columns, I wanted to merge all 4 sheets together A,B,C,D,E,F,G,H is this possible in Power Query? Can you please share a technique if there is any?

[@CAKimberlyLewis]

Same question!

[@darrylmorgan]

Hi Leila!Great Tutorial,Power Query Is Simply Awesome Especially When You Add The Power Of DAX FUNCTIONS Into The Mix..Thank You :)

[@LeilaGharani]

So true! The combination is amazing.

[@woljin]

I almost wanted to report you for talking dirty LOL JK

[@stephenstephen8660]

Great video as usual Leila. You're the best! Thanks!!

[@kristycarlson1042]

You just saved me hours of work! THANK YOU!

[@konli]

Leila, Fantastic the only need this option "Data" "Get Data", been doing it for 10 years manually ! ( for 53 sheets) If I need to separate by year, its easy by formulas We respect I love you !!!!!!! Thank You

[@JimFikes]

Excellence in training strikes again. Thanks, Leila.

[@LeilaGharani]

My pleasure Jim!

[@hanssoo8566]

Thank you for sharing this useful clip!

[@waseemriaz4486]

You are absolutely amazing. Your work is highly commendable.

[@niranjankumarcoimbatore5842]

LEILA JI.....THE GOD OF EXCEL TEACHER.....Your parents are great....We salute

[@srikeshmaharaj]

This video helped me with a solution I needed for PowerBI! Thank you!!

[@LeilaGharani]

Happy to help!

[@anaru46]

Thank you - this really helped me alot

[@JuanHernandez-ij5dc]

Thank you! Very straightforward and helpful!🙂

[@SUFTUM_YNWA]

Amazing. So clear. Thank you.

[@saravanansomasundaram2365]

THANKS A LOT MAM ! VERY HELPFUL & TIME SAVING

[@aleksanderdvanajscak3472]

Thank you for giving us your knowledge. You're a great teacher. Excel is great!😁💪

[@LeilaGharani]

I appreciate that Aleksander!

[@MrHugawa]

great info, thank you very much.

[@yossibagdadi2056]

Amazing and very useful tutorial. Thank you!

[@vinayvvalaboju]

Very good explanation. Thats helpful. Thanks 👍

[@mohammadashiq9996]

All I say leila's Video too good for learner'.and very happy with.

[@purvamirji]

You are a genius...Thanks for sharing these tricks with us!

[@LeilaGharani]

My pleasure :)

[@graphguy]

Great functionality! The more you can dispose of VBA the better.

[@roozbehebadi6661]

سپاس فراوان خانم قنایی

[@derekbingham486]

Amazing video. Life saver for me!

[@umairarshad8541]

Thank you. You solved my problem. Great!

[@VladimirGusev-s8z]

Thanks! It worked well

[@ARIBRUZZO]

Thanks Leila!!! super helpful!!! I have a challenge that maybe would be interesting for you :) is there any way to proceed in the other way arround? I mean I have just one table with all the information and need to split it in different files depending on one column that is the name of the person. So each file should have the data from the table but just the lines that correspond to that person. This is specially important when we want to collect data and we need to avoid that the person see all the data from other persons because of confidentiality issues. Then eventually we can consolidate the data of each file in just one table like you show in this video Thanks in advance!!! LOVE your videos, they are increasing my productivity a lot!!! 🤩

[@weiloong2]

Clear and concise Thank you for the guide

[@Oprimaita]

Great teacher as usual ! Thanks a lot again and again !

[@randomsde4390]

Great tutorial! Everything is exactly what I need!

[@christopheboudnonman7801]

You are the best👍

[@Humphrey181]

Once again mind blown. Quick question though. How would you do this if all the files lived on SharePoint? Synchronise the folder locally and run it that way? How would I make the report work on multiple computers? I don't ask for much :)

[@kamalakannanj4016]

Really helpful lot.. thanks

[@pravinwaghmare6957]

Thanks for this video

[@gadfly1974]

So helpful. Thank you!

[@Noelito40]

Very well explained! This video purported to explain exactly what I needed to do!...and it did! Thank you.

[@mathewinmuscat]

Excellent tutorial, Thanks Leila.

[@hayleymcmillan7581]

This was so useful Leila. Thank you for putting it together!

[@yemisiadeoluwa7907]

Thank you so much Leila

[@LeilaGharani]

You’re welcome 😊

[@helenasvensson6747]

Thank you so much for this tutorial! Exactly what I needed! :-)

[@AUSSIEMALAYALI2024]

Power query a great tool , i am trying to use lately , but the cleaning parts are quite difficult for now.. hopefully will get a good hands with more use

[@cpawlowic]

Thank you for your informative videos. One question: Is there a way to combine data that has similar headers? Meaning if one worksheet's header has an extra column that the worksheet you want to merge is missing? Or would you have to edit your worksheets first, then merge?

[@randyb3347]

EXCELlant! Thanks!

[@jeanpoulin8787]

Leila, after the Power Query course, when are you planning to create a Power BI course?

[@GUAYABAFELIZ]

Please teach us Power BI!!!

[@LeilaGharani]

In the Power Query course we end with a project in Power BI. And next year, we will do a separate Power BI course.

[@stevennye5075]

Excellent content and presentation!

[@zahidmehboob6829]

Nice efforts Laila. If you donot mind I want to share a personal problem. I tried to listen your videos but could not understand completely might be by the fact that your video volume is little bit less if it may be increased it would be more helpful for me. Secondly I m not native english speaker if you keep slow it would be more help from you . Thanks a lot for your great videos for me like persons.

[@mattschoular8844]

Thanks Leila. As always, there's some great info here. Power Query is so powerful!

[@LeilaGharani]

It really is!

[@mhm.saathitheen5652]

Thank you dear Leila.. awaited and asked one

[@LeilaGharani]

Hope you like it!

[@mhm.saathitheen5652]

@@LeilaGharani 💯

[@chrism9037]

Great video! Power Query is awesome

[@LeilaGharani]

It really is! My new favorite.

[@ENSubscriptions]

Hi Leila, awesome work on that as usual! Please Don't forget to include the download link for the exercise files , I couldn't find it this time :)

[@haihathanh5061]

Hello Leila, Could you attach the source files to practice? Thanks!

[@Justme-bf1vf]

fantastic, thanks a lot for all the fabulous job you are doing here

[@LeilaGharani]

So nice of you!

[@henrikmanukyan3152]

6:15 - 7:08 are the main changes to the combines data - delete top rows - make top rows as headers - delete blank rows - detect data type

[@joseherrera7680]

Thank you so much, this makes my life easier!

[@LeilaGharani]

You're welcome, José!

[@hiteshagarwal1164]

Thank you so much

[@pgkannan]

Awaited one from your end. Thank you.

[@LeilaGharani]

Hope you enjoyed it!

[@TanyaAxyonova]

i had 99 files and it worked perfectly! thank you!

[@LeilaGharani]

👍

[@ohdjrp4]

Aha! I just registered for the alert, once the PQ course is available!

[@MrTubertub]

Thank you for the video. Above my column headers I have a text string that contains a date. This date is needed because in the other columns there is no date. How can I extract this text date Into a column (as date format) before removing the top rows in the Samle File? Regards

[@samernoufal6067]

Best KZbin channel

[@LeilaGharani]

😘

[@mrbensontck]

Thank you Leila. Very useful video, I encountered error if combining one the file is empty. How can I automatically skip that, instead of having error. And the whole query stops. Thanks again. ;-)

[@sooshil]

That's awesome. More thanks to you than Excel. 🙂

[@LeilaGharani]

You're most welcome

[@zxu-zv2yy]

Hi Leila, I have watched your courses for a while, they are really great! Would you please teach me how to keep adding new period's data to the existing published power BI reports instead of combining all periods' data and reformatting them, then publish it again? Thank you

[@pieterkaruniadeo3494]

Thanks for another knowledge !!!!!

[@fuad471]

Thank you very useful tips on real life scenario

[@LeilaGharani]

Glad you liked it

[@RobertLongM]

🤕 She reads minds now! I asked this yesterday to myself! 🥰 You make life too easy L

[@LeilaGharani]

Haha. Very good, it worked then 😁

[@anonuser3332]

This went all over my head.

[@sameertaral2211]

Yes same here

[@JamesBond-qg5gx]

I also did not understand anything

[@khaledseghari1189]

Great tutorial thank you

[@balaguruj3475]

Thank you🙏

[@stevenock2722]

This was a lifesaver. So well explained. I’m in for the course.

[@LeilaGharani]

Glad to hear that, Steve!

[@mstech107]

Very cool way to combine files of folder, i really like your channel and im your subscriber, But one thing i don't like is that you never provide us a sample file for practice, Kindly provide us sample file so i can practice..... Thanks in advance

[@LeilaGharani]

Hi. Glad to have you on board. You’ll usually find the sample files in the bottom of the blog post. Link is in the description of the videos.

[@mstech107]

@@LeilaGharani Thanks for touching in back with me, I noticed that usually there be a practice file for short project like your text transform but not for complex projects of power Query like Consolidation of files of folder, I checked but there no file at the bottom of your blog post,

[@AndrewFroude]

Yet another awesome tutorial! Thank you.

[@LeilaGharani]

My pleasure, Andrew!

[@johnborg5419]

Thanks Leila. Looking forward to power query. : ) : )

[@LeilaGharani]

Coming soon! 😊

[@Elroyxxx62]

Hi Leila - What is the approach to consolidate multiple worksheets from one workbook and show them on the Master File onto one summary worksheet ? Great work and so far a big help. Just works for only one worksheet.

[@centurychallenger]

Do you mean something like this? kzbin.info/www/bejne/fJS5dHZuj7qWqqM

[@chessbizz9547]

how to copy multiple excels and paste them as tabs in new excel. I have about 20 files I need to paste as 20 tabs in new file

[@Ms89Ela]

Hi, first of all I want to say big thank you for all your videos. They make work in excel enjoyable and are source of desire to learn more. One question please, if I need to merge multiple files which are password protected into one. Power query does not seem to be able to open the files, is there any way around it? Thank you for your help. Elena

[@SRSKILLLAB]

Hi Leila...once I've loaded file in power query using transform option can I later change it to combine & transform

[@svk853]

Thanks so much Leila. Quick question: is there a method to combine (or append) different Excel workbooks with both common and 'unique' column headings, into a single file? This is a repeat issue I have come across and a solution to this problem would be appreciated

[@infy25]

Exactly looking for same. Validating column headings is again manual intervention, instead it has to combine the data if the column headings are same and add the columns which are unique...

[@MuhammadAsif-uh9pv]

i'm facing the same problem so if you have found any solution to it then please it with me. i'll be really obliged

[@emptycl0ud9]

Is it possible to consolidate the different worksheets from different workbooks into 1 workbook with multiple sheets?