The File List Generator allows you to automate the process of generating a comprehensive file list for a selected folder (and its subfolders). A new sheet will be created which will display detailed information about each file in the selected folder, such as its name, path, size, type, and timestamps when the file was created and modified.
How to Use
- Under Eagles Advanced Tools, navigate to Workbook Organization and click on the File List Generator button.
- A folder selection dialog will appear for you to select a desired folder and once selected, click on OK.
- The tool will scan the selected folder and the subfolders as well and collect the details for each file.
- Based on the information gathered, a new sheet will be created in the workbook and the sheet will have the following table formatted clearly:
- Sr. No: Serial number for all files.
- File Name: Name of each file from the selected folder and subfolders.
- File Path: Full path where the file is located.
- Size (KB): The size of the respective file in kilobytes.
- Type: The file type whether it is a JPG File, Microsoft Excel Worksheet, VBA File, Application, etc. giving the reference of the relevant application.
- Date Created: Initial date when the file was created.
- Date Last Modified: Date when the file was last modified.
Note: Each file from the selected folder and its subfolders will be listed row by row and data will be well-formatted to make it easy for you to read and understand.
- Once the process is completed, a confirmation will appear stating how many files were added to the sheet.
Benefits of the File List Generator
- Comprehensive File Overview: The file list provides detailed information about all files in a folder and its subfolders, which is useful for file management, auditing, or organizing a large set of files.
- Automated Process: Scanning the folder and subfolders and generating a table of file details automatically saves time compared to manually listing all the files with the details of each file.
- Clear and Easy to Read: The generated sheet is formatted with essential file properties, making it easy for you to review and analyze file information.
- Subfolder Support: The program automatically includes files in subfolders, ensuring no files are missed.
Key Points
- Folder Selection: You can select the folder, and the tool handles the rest.
- New Sheet Creation: A fresh sheet is created in the workbook, ensuring no existing data is overwritten.
- Data Population: All relevant file details are populated in a structured and readable format.
- Confirmation Pop-Up: A helpful pop-up confirms how many files were added.
This feature is beneficial for organizing or reviewing file directories, creating file inventories, or managing large sets of files within Excel.