logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Fill » Create a list of filenames and properties in a folder...

This utility will create a list of all filenames in a specified folder.
This way you can for example import on a worksheet the names from all files on a cd-rom.

You can configure the following settings:
  • The folder to be searched.
  • Search subfolders.
  • Create hyperlinks to the files.
  • Show only certain file types. For example to report only Excel files you can enter '*.xl*'.
  • Sort the results, for example by filename, foldername, date, etc.
  • Show only files modified or created within the past specified number of days.
  • Create the list of files in a new workbook or on a new worksheet in your current workbook.

    This utility reports the following information about the files:
  • Parent Folder
  • Filename
  • Size (KB)
  • Type
  • Created (date)
  • Last Accessed (date)
  • Last Modified (date)
  • Full name (foldername and filename together)

    By default you can start this utility with the shortcut Control+Alt+F.
    Your last used settings will be remembered.


    Example screenshot: Create a list of filenames and properties in a folder
    Create a list of filenames and properties in a folder

    Starting this utility

    In the Excel menu choose: ASAP Utilities » Fill » Create a list of filenames and properties in a folder...

    « Return to the list of “Fill” tools.
    « Previous
    Insert workbook's path and name in header, footer or cell...
     Next »
    Insert sheet(s) name in selected cell(s)
    Additional keywords for this tool:
    Directory, list folders, import list of files, read list of filename from explorer, importing, searching, contents of a folder, get file names from folder to excel, listing filenames, folder view into excel, get list of file names from folder, windows explorer, print a list of files in folders

  • Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
    © 1999-2021 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook