logo ASAP Utilities
HomeFeaturesImportCreate a list of filenames and properties in a folder...

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 / Русский / 中文(简体) / 日本語

Import » 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 Ctrl+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 utility

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

    « Return to the list of “Import” tools.
    « Previous
    Merge and/or import multiple files...
         		 Next »
    Export selection or active sheet as new file...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utilities
    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

    Follow ASAP Utilities on Facebook



    • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2018 - - - - 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