This utility will list all the files in a folder and subfolders.

• It's like a big browser
• You choose:
  1. The folder to start at
  2. Whether to include subfolders
  3. A limit on the number of files you want to return
     • Set this to a small number to test if it's working
     • Then set it to a big number for your run
  4. Choose the format you want by formatting the cells on the sheet
  5. Choose your own sort order for the results
• Then Press "List Files"
• Your files will be listed
• A pivot table will be created
  • You can do lots of things with the pivot table
    • Create a list of folders and size of the files
    • Find how many files are in the folders
    • Find duplicate files
    • Split out files by file type
    • etc...

Here's a screen shot of the main screen in Excel:

Here's the output in Raw form:

Here's one of the things you can do with the data:

- put it in a pivot table and find out the size of the files in each folder

Training Video on how to List Files In Folder in Excel: