XL-Tools

What is it

XL-Tools provides a bunch of functions for list of strings, grouped in five categories :

Category Functions
Lists No duplicate, Only duplicates, Count items, Count characters, L1-L2, Column to row, Row to column, List to regex, Concat, Split strings, Split and extract, Merge lines, Replace, Reverse string, Lowercase, Uppercase, Add line number
Sorting Alphabetical order, Numerical order, String length, IPv4 Address, Date and time, Randomize
Conversion Hex to ASCII, ASCII to Hex, Hex to Base10, Base10 to ASCII, URI Decode, URI Encode, HTML Decode, HTML Encode, Base64 to ASCII, ASCII to Base64, SHA1 - Base32 to Base16
Time Anytime to Anytime (Datetime (any formats), Unixtime, ChromeTime, LDAPTime, Filetime, SystemTime), Time difference, Add time, Substract time.
Utils NSLookup, CIDR to IP Range, IP to Arpa, Arpa to IP, Resolve MAC Address, Resolve IPv4 GeoIP, Resolve ISP, Resolve User-agent, Credit Card to issuing company, Address to GPS coordinates, Distance between locations, Custom functions

See documentation for more details.

Screenshots

XL-Tools - Lists - Concat

XL-Tools - Lists - Concat
Click image to view in full size
XL-Tools - Lists - Split and Extract

XL-Tools - Lists - Split and Extract
Click image to view in full size
XL-Tools - Lists - Merge Lines

XL-Tools - Lists - Merge Lines
Click image to view in full size
XL-Tools - Lists - Split and Merge

XL-Tools - Lists - Split and Merge
Click image to view in full size
XL-Tools - Sorting - Date and time

XL-Tools - Sorting - Date and time
Click image to view in full size
XL-Tools - Conversion - Base 10 to ASCII

XL-Tools - Conversion - Base 10 to ASCII
Click image to view in full size
XL-Tools - Conversion - URI Decode

XL-Tools - Conversion - URI Decode
Click image to view in full size
XL-Tools - Time - Anytime to Anytime

XL-Tools - Time - Anytime to Anytime
Click image to view in full size
XL-Tools - Datetime Database Window

XL-Tools - Datetime Database Window
Click image to view in full size
XL-Tools - Utils - Resolve MAC Address

XL-Tools - Utils - Resolve MAC Address
Click image to view in full size
XL-Tools - Utils - Resolve IPv4 GeoIP

XL-Tools - Utils - Resolve IPv4 GeoIP
Click image to view in full size
XL-Tools - Utils - Resolve ISP

XL-Tools - Utils - Resolve ISP
Click image to view in full size
XL-Tools - Utils - Resolve User-Agent

XL-Tools - Utils - Resolve User-Agent
Click image to view in full size
XL-Tools - Utils - Credit Card to Issuing Company

XL-Tools - Utils - Credit Card to Issuing Company
Click image to view in full size
XL-Tools - Utils - Custom functions

XL-Tools - Utils - Custom functions
Click image to view in full size
XL-Tools - Utils - Custom functions - Edit

XL-Tools - Utils - Custom functions - Edit
Click image to view in full size

How it works

XL-Tools 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 the directory you install it.

What do you need

  • Windows XP SP2 or newer

Version History

Version Comments
3.5
  • New: [Time] With time difference, you can now get result by absolute number of years, months, weeks, days, hours, minutes or seconds.
3.4
  • New: [Utils] New Address to GPS coordinates function.
  • New: [Utils] New Distance between locations function.
  • New: [Utils] When Resolve MAC Address function is selected, the current date of the database is displayed.
  • Fixed: When XL-Tools is used for the first time, some defaults values are set to prevent error with [Datetime]. It includes language (en-US), local timezone (America/New York) and charset (cp1252). You may change these values before using [Datetime] function.
3.3
  • New: [Datetime] Output language is now known as Default language and applies to input as well. If a datetime contains language specific object, like month name, you can set the appropriate default language and XL-Tools will be able to parse it correctly.
  • New: [Datetime] Double clic on an entry in the Datetime format will open it in the Edit window.
  • Fixed: [Datetime] There was a problem when timezone was implicetly included with datetime format like unixtime.
  • Fixed: [Datetime] There was a problem with ambiguous timezone abbreviation like EST, PST, CST, etc. These ambiguous timezones are now set to fit the most appropriate offset. See Documentation.
3.2
  • Fixed: With [Lists] Merge Lines, there was a problem when evaluating required parameters.
  • Fixed: When creating a new datetime format, there was a bug with the timezone pattern in combobox (%Z-%z).
  • Fixed: When a list contained more than one empty line at the beginning, items were not enumerated at all.
3.1
  • Added: In List1, a new button to copy data from results.
  • Added: In Results, a Use file option force to use a file as output.
  • Added: In [Sorting], a new Randomize function to shuffle a list of items.
  • Fixed: In custom function, there was a problem when the title of a custom function contained some special characters like parenthesis.
3.0
  • Added: In [Time] :
    • Input and output formats can now be fully customized.
    • Datetime formats are stored in a database: You can add, edit or delete any formats from the database. You can set a format to be use as input, output, both or not used (hidden from list of choices).
    • Local timezone can be customized.
    • Output language and charset can also be customized.
    • Time functions can be used on any string. Data before or after the datetime object can be parsed with the results.
    • Oldest functions like Unixtime to Anytime, ChromeTime to Anytime, LDAPTime to Anytime, Anytime to Unixtime and Date to Weekday are now available using the appropriate datetime formats.
    • Two new time functions have been added for Windows Filetime (64 bits hexadecimal) and Windows SystemTime (128 bits hexadecimal) conversion.
    • Added: New Split and merge function [List], see Documentation
2.0
  • Added: Now, XL-Tools comes with an installer.
  • Added: Documentation in now online.
  • Added: New Transliterate function [List], see Documentation
  • Added: Download function for IIN database
  • Fixed: URI Decode now support two bytes characters like %c2%ae (®)
1.2
  • Added: Eval option in function Replace-By [List], see Documentation
  • Added: Regex validation in function Replace-By [List]
  • Fixed: Stop button didn't work
  • Fixed: Auto-update of the tools didn't work sometimes
1.1
  • Fixed: unixtime with more than 10 digits freezed the tool
1.0 First release.

Translation

To translate XL-Tools 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.

Known Problems

  • The GUI of XL-Tools doesn't support utf8, so if you have some encoding problems, use file for results.

License

Copyright (C) 2015-2017 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 database:
  • For icons:
    • The main logo of XL-Tools 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 Danish Royalty Free Icons by Jonas Rask Design. This icon is distributed as Freeware.
    • Documentation and Cancel (in Utils - Custom Functions) button icons has been created by Oxygen Team 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, open file, delete, check update, import database, etc.
    • Stop icon has been created by emey87 (Manuel Lopez) and is distributed on term of the CC Attribution-No Derivative 4.0 license.
    • Icons for buttons in Utils - Custom Functions and for Datetime database come from Farm Fresh Icons by Fatcow Web Hosting and are distributed on term of the CC Attribution 4.0 license.
    • The check icon used in Configuration Wizard has been created by Cheezen (Anders Bjarnle) and is distributed as freeware.
    • The Copy data from results icon has been created by Yusuke Kamiyamane (http://p.yusukekamiyamane.com) and is licensed under a Creative Commons Attribution 4.0 License.

Download

Source code and binaries are hosted on CodePlex. Source code is also hosted on GitHub.

XL-Tools v3.5 with installer Latest release (2017-03-05)
XL-Tools v3.5 standalone version Latest release (2017-03-05)
Additional content
Datetime Database [Updated 2016-11-27] This database is used with sort by date and time function and with all functions in Time.
Custom Function - Resolve TLD Custom function that resolves TLD to country name or organisation. Uncompress and use the import function to add.
Custom Function - State code to State Custom function that resolves State code to State name (US and Canada only). Uncompress and use the import function to add.
Custom Function - Language code ISO-639-1 Custom function that resolves the language code to the language name, based on ISO-639-1.

 

Credits to Free Website Templates for the template of this Website