logo ASAP Utilities
HomeFeatures added to ExcelFile & SystemCreate a list of filenames and properties in a folder...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

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

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

File & System  ›  24. 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: 1
    1, File & System  ›  24 Create a list of filenames and properties in a folder...
    Example screenshot: 2
    2, File & System  ›  24 Create a list of filenames and properties in a folder...

    Starting this tool


    File & System  ›  24 Create a list of filenames and properties in a folder...
    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
    Trustpilot
    Download  


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


    Empowering Excel Users Worldwide for 25 Years