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

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this detailed tutorial, you'll learn how to consolidate data from multiple files using Get & Transform (Power Query) in Microsoft Excel. This process is invaluable when you need to gather and analyze data spread across various files. Perfect for those who regularly handle data in Excel, our video guides you through each step, ensuring you can efficiently combine information without the hassle.
This is the easiest way to combine multiple Excel files from a folder into one Workbook and create a table or a a pivot table report based on the consolidated data.
🔗 What You'll Learn:
▪️ Setting Up Power Query: Learn to connect Power Query to a folder containing multiple Excel files.
▪️ Filtering and Cleaning Data: Discover how to filter out unnecessary files and clean up your data for accurate analysis.
▪️ Combining Data: Understand how to merge data from different files into one comprehensive dataset.
▪️ Creating PivotTables or Excel Tables: See how to transform your consolidated data into a PivotTable or a standard Excel table for further analysis.
00:00 Consolidate Data from Multiple Excel Files
01:28 Get & Transform Data From Multiple Files in a Folder
02:37 Merge and Append Data in Power Query
05:55 Clean Data in Power Query
07:10 Load Data as PivotTable to Excel
09:21 Load Data as Table to Excel
09:53 Wrap Up
Many of us send out templates to colleagues and are later faced with the challenge to somehow consolidate multiple Excel files. To append the data into a single Excel workbook can be quite a troublesome and lengthy process.
Sure, a solution for this has always been Excel VBA. But learning VBA takes time and it can be too difficult for a lot Excel users.
In this tutorial, I'll show you a much easier approach! We'll use Excel Get and Transform aka Power Query to combine data from multiple Excel workbooks. We will directly connect to a folder that contains the files and use the feature Combine Files in Power Query. Any time you drop an Excel file in that folder, the data will be appended and consolidated with the rest. You can then create one Excel table for the appended data or create a pivot table from the multiple Excel files.
The best part about using Power Query to merge data from Excel files is that you don't need to write any code! You just need to click a few buttons to append the data from the files.
Read the article: www.xelplus.com/power-query-c...
Power Query Playlist: • Excel Power Query (Get...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

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

[@shadrackawunyo7786]

Leila!!!!! You are a gifted instructed. This video was loaded last week but I was not really enthused to watch. The reason is I have some knowledge on this subject already and do apply them often. I decided to watch it today and was blown out. You have an amazing way of teaching even familiar subjects clear enough to impact further knowledge and deeper understanding. I am definitely signing up for your PQ course

[@LeilaGharani]

That's great! I'm happy to hear that.

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

[@syairol]

I use to append by individual files. Its time consuming. This is a life saving solution. Append by folder. Thanks Leila. You're truly a excel gem

[@LeilaGharani]

You're very welcome!

[@phamhuyson1988]

Perfect! Everytime I got trouble, searching google and reach your video, my solution was there. I must love you Leila!

[@hayleymcmillan7581]

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

[@randomsde4390]

Great tutorial! Everything is exactly what I need!

[@Morgenj]

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

[@Oprimaita]

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

[@waseemriaz4486]

You are absolutely amazing. Your work is highly commendable.

[@tabban218]

Learned a lot from this as a beginner, thanks Leila

[@myprovenacademy]

Leila is an awesome trainer. This looks like powerBI implementations tool

[@Hurairahgiri]

You're right. Both Excel and Power BI have the same Load & Transform Data tool.

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

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

[@yossibagdadi2056]

Amazing and very useful tutorial. Thank you!

[@hanssoo8566]

Thank you for sharing this useful clip!

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

[@JuanHernandez-ij5dc]

Thank you! Very straightforward and helpful!🙂

[@ltumanyan1980]

Thank you, it was really helpful!!!

[@ryanmiguelsantiago]

As always, practical and great example. Thank you!

[@LeilaGharani]

Glad you enjoyed it!

[@CJAKS1]

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

[@stephenstephen8660]

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

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

[@aleksanderdvanajscak3472]

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

[@LeilaGharani]

I appreciate that Aleksander!

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

[@stevenock2722]

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

[@LeilaGharani]

Glad to hear that, Steve!

[@weiloong2]

Clear and concise Thank you for the guide

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

[@mattschoular8844]

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

[@LeilaGharani]

It really is!

[@CANONinDEVIN]

Thank you! I could not figure out an error encountered after updating a transform sample file, but you addressed it right away w/ removing the "Changed Type" step.

[@stevennye5075]

Excellent content and presentation!

[@JorgeChang550]

This is exactly what I needed. I've been looking for something like this for a while. Thank you.

[@LeilaGharani]

Happy to help, Jorge!

[@SUFTUM_YNWA]

Amazing. So clear. Thank you.

[@pgkannan]

Awaited one from your end. Thank you.

[@LeilaGharani]

Hope you enjoyed it!

[@dhanushthakral4737]

In love with your teaching and your sweet voice as well.... Enrolled for your excel course.....

[@LeilaGharani]

That's great! I hope you'll like them.

[@pieterkaruniadeo3494]

Thanks for another knowledge !!!!!

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

[@helenasvensson6747]

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

[@MrHugawa]

great info, thank you very much.

[@rafaelnardi4915]

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

[@kristycarlson1042]

You just saved me hours of work! THANK YOU!

[@saravanansomasundaram2365]

THANKS A LOT MAM ! VERY HELPFUL & TIME SAVING

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

[@gadfly1974]

So helpful. Thank you!

[@user-lg9nk5qb8u]

Thanks! It worked well

[@anaru46]

Thank you - this really helped me alot

[@harshanaweragama270]

Dear Leila, Thank you for many many videos from which i have plenty of excel tips and tricks, and have managed to provide with more professional looking charts. Whilst i have learnt many i saw a beautiful chart with combining a doughnut chat with a bubble next to each slice, where the bubble size changes with the size of the slice. Would appreciate it very much if you could look at how we can do this in excel

[@Jason-Jason]

Excellent, thank you

[@kamalakannanj4016]

Really helpful lot.. thanks

[@umairarshad8541]

Thank you. You solved my problem. Great!

[@ohdjrp4]

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

[@ScottMoran001]

Great video Leila, but I have a question. I have 12 individual sheets, each represents a full month sales. Is there a certain way I should name each table or sheet that will work better to represent the data for analysis? Example, should it be Jun-2020 or June 2020 or 07-2020? I've searched online but can't identify a good solution. Any thoughts you have would be much appreciated!

[@dixitsantosh2]

Great Leila really helpful.

[@chh8860]

Terrific topic … perfect presentation … ;)

[@cdyard1]

Fantastic!

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

[@mohammadashiq9996]

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

[@pravinwaghmare6957]

Thanks for this video

[@wayneedmondson1065]

Hi Leila.. thanks for the video.. great! Looking forward to more transformations inside your new course. Thumbs up!!

[@LeilaGharani]

I hope you'll enjoy the course, Wayne!

[@bujiliubrt]

Thx, Leila, excellent!

[@vinayvvalaboju]

Very good explanation. Thats helpful. Thanks 👍

[@rishabhjain6565]

Your video's quality are always awesome!! Love from INDIA 😍

[@jmoralesg14]

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

[@LeilaGharani]

Our pleasure, Jorge!

[@sachithtillekeratne4915]

This is just great!!! Thanks Leila

[@LeilaGharani]

Glad you like it!

[@dunnobe]

I've read some interesting articles from Ken Puls on combining VBA and PowerQuery. I wonder to what level Excel can be pushed by combining these 2 great features.

[@derekbingham486]

Amazing video. Life saver for me!

[@user-st9wr7hr4t]

Best lectures May she live long with health and wealth too

[@varunsonu1]

thank you so much for this

[@AndrewFroude]

Yet another awesome tutorial! Thank you.

[@LeilaGharani]

My pleasure, Andrew!

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

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

[@tanandteestation4700]

Thank, it helps me a lot..

[@reactionary]

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

[@LeilaGharani]

Welcome aboard :)

[@khaledseghari1189]

Great tutorial thank you

[@hwasolo88]

Hey Leila..thank you for this tutorial, very helpful! is there any way we can add new blank column in the power query table and, in that blank column, we create a hyperlink to connect to original data sheet? I am making a sort of progress tracking page by consolidating all the tables i have in different sheets so my audience can track their progress from 1 single sheet instead of opening 1 sheet to another. But this consolidated tables are not for them to edit/enter information, i still want them to go back to the individual sheet to update a data. And i want to provide a link to this individual sheet. Could you pls teach me? Thank you.

[@GND_95]

Thank you a million :)

[@mjmallari796]

Thank you so much.

[@buddikasudarman3832]

great lecture

[@purvamirji]

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

[@LeilaGharani]

My pleasure :)

[@mummyzara]

thank you so much.. help simplify repetitive work of combining files.

[@LeilaGharani]

Welcome 👍

[@hiteshagarwal1164]

Thank you so much

[@ashoksahu9546]

Excellent video.

[@WilliamAzevedo]

Thank you, thank you and thank you! And before I forget: thank you!!!

[@tahiryasin3766]

Nice explanation

[@zab82a]

Super clear, thank you, nice animation 5 star

[@venkateshmekala9535]

Hey!! thanks very much!! Really it is helped me a lot:)

[@nonoobott8602]

Very insightful and easy to follow through 👍

[@LeilaGharani]

Glad you think so!

[@asmrindia]

Very Nice Mam

[@atul001]

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

[@graphguy]

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

[@shafeerey170]

Excellent Leila.....

[@randyb3347]

EXCELlant! Thanks!

[@christopheboudnonman7801]

You are the best👍

[@JimFikes]

Excellence in training strikes again. Thanks, Leila.

[@LeilaGharani]

My pleasure Jim!

[@balaguruj3475]

Thank you🙏

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

[@joseherrera7680]

Thank you so much, this makes my life easier!

[@LeilaGharani]

You're welcome, José!

[@lloydditchfield6917]

This is exactly what I need as a billing analyst to combine multiple sources of invoice data!!!! Awesome video

[@LeilaGharani]

Glad it was helpful!