logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

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

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

File & System  ›  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.

    Screenshots

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

    Starting this tool


    Download
    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
    Reload all installed add-ins (rebuilds the menu)



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us