Get Multiple Files Containing Multiple Sheets With Power Query

2021 8:49
Synopsis
How to import multiple files containing multiple sheets with Power Query, even if the data isn't formatted in an Excel Table.

You Might Also Like

Combine Files from a Folder with Power Query the RIGHT WAY! 10:18
Combine Files From A Folder With Power Query The Right Way!
2024
Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥 8:05
Power Query Trick: Combine Excel Files With Different Sheet ...
2026
Combine Multiple Worksheets into one using Power Query 2:00
Combine Multiple Worksheets Into One Using Power Query
2024
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder) 10:29
Easiest Way To Combine Multiple Excel Files Into One (append...
2021
Power Query - Combine Excel files with different sheet names 1:45
Power Query - Combine Excel Files With Different Sheet Names
2024
Excel: Combine Data from Multiple Sheets Across Multiple Files 7:37
Excel: Combine Data From Multiple Sheets Across Multiple Fil...
2026
Power BI - Combining Multiple Sheets From Multiple Files in Power Query 8:05
Power Bi - Combining Multiple Sheets From Multiple Files In ...
2020
Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query 13:02
Combine Multiple Excel Sheets With A Transform Sample Sheet ...
2026
Combine Data from Multiple Workbooks in a Folder Using Microsoft Excel's Power Query 7:34
Combine Data From Multiple Workbooks In A Folder Using Micro...
2024
Excel Tips - Combine Multiple Tabs or Worksheets into One | Power Query 3:33
Excel Tips - Combine Multiple Tabs Or Worksheets Into One | ...
2025
Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamic 5:45
Combine Multiple Or All Sheets From An Excel File Into A Pow...
2021
Download Options
Choose a download method below. All links open in new tabs.
Service Features Action
SaveFrom
MP4 & MP3 • HD Quality • Browser Extension Available
Download
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.