How to import multiple files containing multiple sheets with Power Query, even if the data isn’t formatted in an Excel Table.
🔻 DOWNLOAD the Excel file & see step by step written instructions here: myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-query
🎓 LEARN MORE: view my comprehensive courses: myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy/
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
- Get Multiple Files Containing Multiple Sheets with Power Query ( Download)
- Power Query - Combine Excel files with different sheet names ( Download)
- Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder) ( Download)
- Combine Files from a Folder with Power Query the RIGHT WAY! ( Download)
- Power BI - Combining Multiple Sheets From Multiple Files in Power Query ( Download)
- AWESOME Excel trick to combine data from multiple sheets ( Download)
- Excel: How to use Power Query to Combine Data from Multiple Excel Files with Different Sheet Names ( Download)
- Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamic ( Download)
- EASY Trick to COMBINE Multiple Excel files into ONE with Power Query ( Download)
- Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks ( Download)
- Import Multiple Excel Files with Multiple Sheets in Excel ( Download)
- How to Combine Multiple Excel Sheets or Workbooks Seamlessly ( Download)
- Combine Multiple Worksheets into one using Power Query ( Download)
- Consolidate Excel Sheets with Power Query ( Download)
- Power Query - Combine Excel files with multiple sheets from a folder ( Download)
