List all the files in a folder and subfolders with Power Query

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Check out the blog post ★
https://exceloffthegrid.com/power-que...


★ About this video ★
This video shows:
- How to list all the files in a folder and subfolder with Power Query
- Use file attributes such as Size, Read-Only, Last Modified date
- Difference between Folder.Contents & Folder.Files

0:00 Introduction
1:03 List the files in a folder and subfolders
3:18 List files in the folder only
4:22 File attributes
5:40 Summary


★ 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