Windows Explorer will show you a list of files in a folder, You can sort by name, sort by date, sort by size. But sometimes it would be great to have this list in Excel. Power Query makes this simple.
- Select Power Query, From File, From Folder.
- Browse to your folder. Click OK.
- You initially see useful columns like Date Modified, File Name, but important columns such as Size are missing. Find the Attributes column and click the Expand icon. You are now given a list of additional fields that you can add to the grid.
- The Expand icon often has hidden fields.