How to Combine Multiple Excel Sheets or Workbooks Seamlessly

Welcome to our step-by-step tutorial on how to seamlessly combine multiple Excel sheets or workbooks into one comprehensive sheet using Power Query! Whether you're an Excel beginner or looking to enhance your data management skills, this video is designed to guide you through the process with ease.

What You'll Learn:

✅The basics of Power Query and its powerful capabilities in Excel.
✅How to import multiple Excel sheets and workbooks into Power Query.
✅Step-by-step instructions on combining data from various sources into a single, organized table.
✅Tips and tricks to streamline your data consolidation process.

Why Watch?
Merging data in Excel is a common task, yet it can be time-consuming and complex when dealing with multiple sources. Power Query simplifies this process, allowing you to combine, refine, and analyze data more efficiently. This tutorial is perfect for Excel users of all levels who want to improve their data management skills and save valuable time.

Resources:

Timestamps:

0:00 Introduction
0:24 How to combine multiple sheets in Excel
4:56 How to combine multiple workbooks in Excel

[heathermoore]

Super helpful! I had to merge 52 weeks of csv files (1 per week), so this helped massively. Thank you.

[christinegagliardi]

Thank you for this video! After figuring out how to hide rows, I was able to (finally) import data from 5 worksheets and have a functioning query! 🙌🙌🙌🙌

[kamaboko]

I had to do some slight of hand to get my particular use case to work, but your instructions helped me down the path. Thanks!

[lexicarmichael]

Amazing! Just combined 250k lines that were initially spread across 28 tabs. Great help, thanks very much.

[JimHanson]

thank you hugely for this video. i've been trying to find a solution for this for 2 years. consolidate, add ons, etc. did not work for the data i have. this works just fine (with a few modifications). thank you very much!

[leesever]

Woooo thank you so much!!! It is almost as Power BI. I'm. going to $$$ for that.

[hamidkhalaj]

Thank you so much for the straightforward and clear tutorial!

[CovidWarriors-ikor]

Very helpful and elaborate! Thank you for teaching and saving my time! :)

[RoseAnnRabe]

It works! Saved a lot of time. Thank you so much!!!

[hsualexandre]

great thanks for sharing! Very useful!

[evasommer]

Thanks for the clear demo and explanation. Very helpful 🙏🙏🙏

[dolphinpig]

Thanks a lot. It’s really really helpful! ❤

[ufxcwxk]

Thanks for the wonderful guide! It works!

[Badminton_ever]

Hello,
Can we not consolidate the data in the same Excel workbook? And the consolidated sheet dynamically updates when data is added / changed to other sheets

[SordidTempest]

Is there a way to add additional data to certain fields based on another excel file?

[yyusof]

Thanks for the valuable video, done subscribe. How could we do if the data contains pictures in product, how PQ handle data contains picture

[TheYdyp]

Man found this to late as last week I had to combine 10 workbooks with 30 sheets each. So had to rewrite my older macros that combined the sheets and added a loop for the workbooks in a folder. Which took me a lot longer then using a combination of this method.

[Beemerbmr]

I added some columns to the source files in order to get additional detail, how do I get these columns to carry over to the power query?

[rivermike]

Will formulas come over or will that create an error?

[venessamuller]

How to create a reference to the same cell range on multiple worksheets? Not everything in the spreadsheet, but only certain cells data into one.
I need to create a list from hundreds of quotes sent to clients. I only need to pull their info and quote number to one list in excel in order to keep track of the quotes sent out. No one bothered to keep track before I started the job and I would like to implement this for myself.