Excel: get and create a list of filenames in a folder or directory

Many people may wonder why there is no direct way to get and create a list of files contained in a specified folder or directory. Don’t worry! Kutools for Excel’s Filename List feature solves the problem for you in Excel 2007/2010.

Create a new workbook and generates a list of files contained in a specified directory, and each file is linked with hyperlink;
All the files in the subdirectories also can be generated in the list;
Besides the filenames, the list contains the file size and the creation date.

Usage

1. Click Kutools >> Import/Export >> Filename list. See Screenshot (Fig.1)..

Fig.1 Filename list

2. The dialog box pops up, and click the Browse button to specify a folder you want to create a list. See Screenshot (Fig.2)

2.1 To include the files contained in the subdirectories, place a checkmark to the Include files in subdirectories.

To create hyperlinks to each file, place a checkmark to the Create hyperlinks.

Fig.2 Create filename list

3. Click OK to create the list. See Screenshot (Fig.3).

Fig.3 Example of the filename list

Tips:

1. The list can be sorted by any of the columns.

2. The Size column shows the file size in bytes. To convert to Kbytes, divide the value by 1,024.