Combine all the files in a folder using Power Query | Excel & CSV | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post & download the example file★
https://exceloffthegrid.com/power-que...
★ About this video ★
In this post, we use Power Query to import all the files in a folder. We give Power Query a folder path, click a few buttons, and it imports and combines all the files into a single table. It’s like magic!
0:00 Introduction
0:53 Setting up the example
2:03 CSV Method 1
9:20 CSV Method 2
13:07 CSV Adding more files
13:57 File Uniformity
15:36 Excel Workbooks
16:23 Excel Workbook Method 1
20:50 Excel Workbook Method 2
23:39 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #PowerQuery