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 Control+Alt+F.
Your last used settings will be remembered.

Screenshots

Example screenshot: 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...

You can do this too

Download "The one essential add-in for all Excel users."

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

Printer friendly page

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