Load a List of File Names into Excel
February 17, 2023 - by Bill Jelen

Problem: 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.
Strategy: Power Query makes this simple.
1. Select Power Query, From File, From Folder.
2. Browse to your folder. Click OK.
-
3. 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.

This article is an excerpt from Power Excel With MrExcel
Title photo by Beatriz Pérez Moya on Unsplash