XL-FileTools

What is it

XL-FileTools provides a bunch of functions for files, grouped in three categories:

Category	Functions
List	There are two types: - List of files produces a tab of informations about files that can include full path, path, filename, file extension, file details (size, last accessed or modified date), hash value (MD5, SHA1, SHA256, SHA512), count duplicates, list of members (xls(x) and zip), number of files (folders or zip), number of lines (text files) and number of pages (doc(x), xls(x) and pdf). - List of extensions enumerate and calculate the number of extensions in a folder.
Copy/Move	Copy and move the selected folders and files. Duplicates (based on the MD5 hash) can be excluded. The most interesting thing about using XL-FileTools to copy or move files is filters. Filters can be used with any function, but copy and move would be worthless without it. You can filter by file size, last accessed or modified date, using a keyword or regex. You can also combine and use multiple filters.
Rename	There are three types: - By hash simply renames file based on the calculated hash value (MD5, SHA1, SHA256, SHA512). Extension may be preserved or not. - By sort applies a sort to a list of files before renaming them with an incremental value. There a lot of options for type of sort and type of incremental value. - Replace-By can be used on filename or folder name. You can use keyword or regex.

Another interesting feature of XL-FileTools is preview mode. You can see what's gonna happen before doing it for real. See documentation for more details.

Screenshots

Next Previous

XL-FileTools Main Window


Click image to view in full size

XL-FileTools Main Window - Copy or move


Click image to view in full size

XL-FileTools Main Window - Rename


Click image to view in full size

XL-FileTools Preview Window


Click image to view in full size

How it works

XL-FileTools can be installed using the installer or used as a standalone application. In order to start using it, just run the executable file from the start menu or from the program directory.

If you used the installer, you can also start the tool using the link in the Send To folder after right-clicking on any folder or file(s).

What do you need

• Windows XP SP2 or newer

Version History

Version	Comments
4.2	In List Files, new include options: Path Extension List of members (For xls(x) and Zip) Number of files (it now support zip archives) Number of pages (For doc(x), xls(x) and PDF) Tip have been added on some options to give some informations. New: Added Open user dir in Settings window. Fixed: There was an issue when changing timezone in Settings window.
4.1	New: There is new Count option in List files. New: It is now possible to set and change the local timezone in Settings. New: There is a new Format file size option in Settings. New: The XL-FileTools version is now inserted in metadata for XLSX and HTML reports. New: All report formats (HTML, XLSX, TXT) are now supported for List extensions. Fixed: In List files, File Details were empty when Full path was not selected. Fixed: There was an issue with daylight saving time changes for last-accessed and last-modified time. Erroneous values were read from system. This problem occured with NTFS volume and if the computer was set to "Automatically adjust clock for daylight saving changes" (which is the default setting).
4.0	File Filters are now in a separated window with some new options like saving and importing a list of file filters. The saved file filters can be shared with XL-Parser. Function section has been modified to include sub-tabs for each function. In List files, file details (size, last modified, last accessed) are now also apply to folders. In List files, there is a new Number of files option. For List extensions, you can now add a minimum and a maximum length. In Rename by hash function, you can now exclude duplicates and remove extensions. Rename By Sort options are now in main window. In Rename by Sort function, you can now remove extensions.
3.1	Fixed: Headers in filters was not displayed at startup. Fixed: Autoupdate was not working correctly.
3.0	Added: Filter section has been rebuilt to support multiple filters. Added: Report format for List Files: TXT, HTML, XLSX. Added: In [List], a new "browse in explorer" button for report folder. Added: In [List], a new Hash values option window. Added: In [List], new hash functions: SHA256 and SHA512. Added: In [List], a new File details option window. Added: In [Rename], new hash functions: SHA256 and SHA512. Added: In Settings windows, a button to open the log. Modified: Only one input textfield in Input section. Fixed: SHA1 hashing wasn't working correctly.
2.1	Fixed: "Contains" filter didn't work correctly. Fixed: When no report dir selected, Process button was enabled.
2.0	Added: Now, XL-FileTools comes with an installer. Added: Documentation in now online. Fixed: Regex validation
1.0	First release.

Translation

To translate XL-FileTools to other languages:

1. In Config Window, use the Export Lang.ini function. The file will be saved in the same directory of the tool;
2. Open the file in any text editor like Notepad;
3. Translate each expression at the right of the = symbol;
• The expression on the left side is used by the tool to identify the expression so do not change it. Also, be sure to have a space between the = symbol and your expression (ex. Key = Value);
• Authorized characters are alphanumerics, spaces and these symbols: ",", ".", "-", "!", ",", "(" and ")". Any other character will be deleted;
• For some controls, string length must be the same as original. A longer string could be truncated if it doesn't match the length of the field;
• The value associated with the translatorName will be used in the About window to identify you as translator (if you want). You can also add your email or a short url (ex. YourName (youraddress@email.com));
4. Restart the tool so the strings in Lang.ini will be used instead of the default language.

If you translate the tool and you want to share, contact the author.

Available translations:

To install, save the appropriate Lang.ini file in the default folder of the tool (if you used the installer, it should be AppData. Otherwise, it's the same folder of the program).

No translation available for the moment.

License

Copyright (C) 2016-2018 Alain Rioux

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

Feedback

If you have any problem, suggestion, comment, or you found a bug in the utility, contact the author.

Credits

• For icons:
• The main logo of XL-FileTools has been created by Saki (Alexandre Moore) and is distributed on term of the GNU General Public License.
• The icon used for Process button comes from Orb Icons by Taytel. This icon uses Linkware license.
• Stop icon has been created by emey87 (Manuel Lopez) and is distributed on term of the CC Attribution-No Derivative 4.0 license.
• The icon used for Preview button comes from Long Shadow iOS7 Icons by PelFusion. This icon uses Linkware license.
• Documentation button icons has been created by Oxygen Team and is distributed on term of the GNU Lesser General Public License.
• A lot of icons used for buttons come from the Blue Bits collection of Icojam (licensed as "Public Domain") like config, about and open file.
• The icon used for Open folder button comes from Basic Icons by PixelMixer and is distributed as Freeware.
• Filter icons (use, delete, add) come from the Fugue Icons collection by Yusuke Kamiyamane (http://p.yusukekamiyamane.com) and are licensed under a Creative Commons Attribution 3.0 License.
• The "Open folder in Explorer" icon comes from Danish Royalty Free Icons by Jonas Rask Design. This icon is distributed as Freeware.
• The older opened and folder closed icons used in Preview window come from Silk Icons by FamFamFam and are distributed on term of the CC Attribution 4.0 License.
• The file, warning and error icons used in Preview window come from Fugue Icons by Yusuke Kamiyamane and are distributed on term of the CC Attribution 4.0 License.
• Big filter list icon has been created by Double-J Design and is distributed on term of the CC Attribution-No Derivative 4.0 license.
• The import and save filters icons in File Filters window come from the Farm Fresh Icons collection by Fatcow Web Hosting and are distributed on term of the CC Attribution 4.0 license.

Download

Source code is hosted on SourceForge and GitHub. Binaries are hosted on SourceForge.

If you want to download the standalone version or an older version, check on SourceForge.

If you install many tools of the XL-Toolkit, you should follow these instructions.