Excel Template to Create a List of all Files in a Folder and Subfolders

I have always needed (wanted) the ability to create a list of all filenames inside a specified folder and its subfolders on my computer including additional information like file types, sizes, dates and path lengths.

After a bit of Googling I found a little tool which automatically creates a list of all files inside a specified folder and all its subfolders, including the file names, the paths, the file types, the dates (created, last modified, last accessed) and the lengths of the path and filename.

If you are interested, here is the free download:

Download retrieve filenames from folder and subfolders (Zipped Excel 2016 Macro-Enabled Workbook, 29K)

Download, unzip and open the tool, enable macros, click on the import icon at the top of the sheet, select a folder and wait until the code is finished (the status bar at bottom left shows the progress).

Please be advised that the code is not optimized for performance. Importing approximately 500 files from a folder on my computer took about 7 seconds.


About The Analytical Consultant

Senior Financial Services Digital Consultant with over 12 years of proven experience delivering omni-channel strategies and solutions to help Enterprises streamline processes and improve operational efficiency. Primary focus has been projects in the digital arena in areas such as business analysis, customer experience, voice of the customer, digital marketing, call center solutions, digital analytics and technology consulting,
This entry was posted in Excel Tools, Excel Tutorials and tagged . Bookmark the permalink.

Leave a Reply