logo ASAP Utilities
HomeExtra features for ExcelImportList File Names and Properties from Folder...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

List File Names and Properties from Folder...

ASAP Utilities  › Import  ›  11. List File Names and Properties from Folder...

This tool creates a list of all files in a specified folder, including their properties. You can customize what to include:
  • Choose the folder to scan
  • Optionally include subfolders
  • Show only specific file types (e.g., *.xlsx for Excel files)
  • Filter by last modified or created date (e.g., only files from the past 30 days)
  • Sort the results by filename, date, size, etc.
  • Create hyperlinks to the files
  • Choose to insert the list in a new workbook or in a new sheet in your current workbook By default, it reports the following file properties:
  • Subfolder
  • Filename
  • File size (KB)
  • File type
  • Date created
  • Date modified
  • Date last accessed
  • Full path (folder and filename combined) You can also add many additional file details using the "Choose Details" button, just like in Windows Explorer. This allows you to include extra metadata such as document authors, photo dimensions, camera model, music artist and album, and much more.
    These available extra details depend on your version of Windows. ASAP Utilities relies on Windows to retrieve and display these extended file properties. This tool is useful for:
  • Creating a file inventory or audit
  • Tracking files in shared folders or project directories
  • Quickly exporting file metadata for analysis or reporting in Excel Your last used settings are automatically remembered. By default, you can launch this tool using the Control+Alt+F shortcut.

    Screenshots

    Example screenshot: 1
    1, Import  ›  11 List File Names and Properties from Folder...
    Example screenshot: 2
    2, Import  ›  11 List File Names and Properties from Folder...

    Starting this tool


    Import  ›  11 List File Names and Properties from Folder...
    Additional keywords for this tool:
    Get list of file names from folder, Create file inventory, Export folder contents to Excel, List all files in a folder, Generate file list with properties, Folder file listing tool, Import filenames and metadata, Read file properties from directory, File list from Windows folder, Get file details from folder, Create folder report, Extract file list from folder, Print list of files in folder, Insert folder contents into worksheet, List files with creation date and size, Report folder contents with file metadata, Scan folder and export file names, Folder file list generator, Get Windows Explorer file details in Excel
    Trustpilot
    Download  



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


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.