Le-tools.com Forum Contact
XL-FileTools - Documentation

Main window

Xl-FileTools Main Window

The main window is divided in three sections:

File Filters window

File Filters window

When you select a Folder as input, you can use filters to restrict the scope of the search to files that match your criteria. You can add, edit (by double clicking a filter in the grid) or delete filter. You can also save your filters for a later use. File Filters can be shared between XL-FileTools and XL-Parser.

You have five types of file filters:


File Filters window - 

By default, the keyword or regular expression applies to the relative path (folder or file, but excluding input directory). You can select Filename only option to exclude folders. If you select Regex option, a colored border around the textfield will indicate if your regex is ok. If not, you can press the ? button to see the error message.

Filters can be combined. For example, you can filter using a range of dates (using Before and After filters) or create "greater or equal to" filters.

Case scenario

Let's suppose you have a list of files that you want to search on a volume. If you have the files, you can list the size and the hash value of each file. Then you search the volume, using the list of sizes as a filter, and you list the files including hash values. If you get results, all you have to do is compare these results with the first list you do. If you have a long list, you can use XL-Tools which has functions to do this.


There are three groups of functions: List, Copy/Move and Rename.

List Files

Functions - List Files

Produces a report in the selected format that can include the selected details:

  • Full path: The full path of the folder or the file. If not selected, only files will be in the report.
  • Path: Relative path of the folder or the file.
  • Filename: Only the filename.
  • Extension: The extension of the file.
  • File details: A popup will appear where you can select any of the three type of detail: file size, last accessed date, last modified date and created date.
  • Hash values: A popup will appear where you can select any of the four hash functions: MD5, SHA1, SHA256, SHA512 and SHA1-32bits.
  • Count duplicates: With this option, duplicates will be counted. A popup will appear where you can select how to count duplicates, based on MD5 or filenames.
  • List of members: For xls(x) and zip only. For xls(x), it gives the list of sheet names. For zip, it gives the list of the files inside the archive.
  • Number of files: This option is available for folders and zip only. It gives the number of files in the folder or the archive. For folders, it doesn't include the subfolders.
  • Number of lines: This option is available for text files only.
  • Number of pages: For doc(x), xls(x) and pdf only. It gives the number of pages inside the document or the number of sheets in case of xls(x) file.

Some informations, like hash values, apply only to files as other, like number of files apply only to folders. By default, report includes a header with the name of each columns, but you can disable it with the No header option. With No folder option, only files will be included in report.

Report: This is the folder where the report will be saved. The folder is automatically saved. Available report formats for List Files are TXT (TSV (tab-separated values)), HTML or XLSX.

Important: There is no preview for the List functions.

Validation on the fly

XL-FileTools, like my other tools, validates controls on the fly. Everytime you click on a checkbox, you select a different option, you change the content of a textfield, etc., the GUI will change, based on your changes.

Regex and replacement expression are also evaluated on the fly and the status will be indicated with a colored border around the corresponding textfield.

To see warning or error message, previous controls must meet requirements. In the footer of the Main Window, if Not Ready? Click here is visible, click on it if you want to know what to do next.

Preview window

Preview window

With Preview Window, you can see what's gonna happen before doing it for real. The Preview is available as soon as your input and selected filter options are validated, but for the left side (Before) only. When your function options are set and validated, the results will be shown on the right side (After).

Take note that there's no Preview for the List category.

Some errors and messages can be shown in the Preview Window but not all. For example, errors related to file system permissions can't be evaluated in preview mode.



Settings window - General

In Tool section, we have the following functions and options:

  • Export Lang.ini: Use this function to translate XL-FileTools GUI. See Translation for help about this functionality.
  • Open user dir: This is the directory where settings are saved. Copy the content of this directory if you want to backup your settings.
  • Check Update: Check on le-tools.com if a tool update is available.
  • Check for update at startup: When XL-FileTools starts, check on website for available update of the tool.

In Functions section, you have the following options:

  • Local timezone: This option will affect the last-accessed and last-modified date and time.
  • Format file size: When listing files, the file size is written as number of bytes. If you select this option, the file size in report will be rounded and represented as Kb, Mb, Gb.
  • Use lowercases for hash value: This option applies to List and Rename functions.

Copyright (c) 2015-2021 Alain Rioux