XLTools Excel Add-in


What is XLTools?

XLTools is an Excel extension (also called add-in) that provides advanced functionality for all Excel users who want to become more efficient and effective with their data analysis, automate repetitive tasks without VBA, and manage their worksheet properties and history with ease. 

All the features that come with this add-in are not available in the standard Excel version, but once you extend Excel with these features, you will have a bunch of tools that you will use every day.

Disclosure: Some of the links on this page are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

All features of XLTools

XLTools provides 20+ powerful features for a lot of different task categories. Let’s take a closer look at everything you can get with this add-in.

Workbook Control

XLTools revolutionises the way to can work with your spreadsheets. It let’s you control all worksheets from one place and adds versioning from within Excel.

Workbook Organiser

Version Control

Version Control for VBA

Data Tools

The data tools in XLTools let you work with big amounts of data like never before. It simplifies data preparation, cleaning, and analysis tremendously.

SQL Queries from Tables

Combine Data

Unpivot Data

Clean Data

Fill Blanks

Combine Sheets

Split Table

Repeat selection

Count by Color

Match Columns


With the automation feature of XLTools you can automate routine operations without bulky macros and create custom buttons in Excel.

Automation without VBA

Email Automation

Usability Tools

The usability tools in XLTools make the handling of your worksheet much smoother and reduce multi-step tasks to one simple step.

Pop-up Calendar

Pop-up Clock

Export to CSV

Sheet Switcher

Disable F1/F9

You can find a detailed description of every single feature on the product page.

Main benefits of XLTools

Without a doubt, XLTools provides a massive amount of additional tools for Excel, but as you know quantity doesn’t mean quality. So let’s focus on the real value this add-in can bring for your day-to-day work.

XLTools Official Add-in

Depending on your needs, you can choose between different licenses of this add-in. 

Requirements: Office 365, 2019, 2016, 2013, 2010, or 2007 (Windows only)

Is this Add-in worth the money?

Generally, when you buy a product to accelerate your work and productivity, you should consider it from the perspective of an investment rather than simply spending money (at least that’s how I do it). From an investment perspective,  the question is 

Does the product provide more value to me over its lifetime than I spend on it?

If you rarely use Excel or only use it for really simple tasks, this add-in most likely has many features that you will not use, so the return on investment might be minimal for you. 

However, if you are a regular or heavy Excel user, you will most likely save a lot of time in your day-to-day work with this add-in. The saved time can be multiplied by your hourly rate and with that in mind, the break even point (the point at which you start getting more value from this add-in than what you paid for) will be reached in very short time. 

You should also consider the impact of faster and more professional results on your career. The faster and better the results are you deliver to your boss or customers, the more likely you advance in your job or position. So investing into tools that will get you faster and better results is absolutely worth a consideration.

If you want to test it first, you can simply make use of the 14-days free trial that is offered for XLTools.

XLTools Official Add-in

Depending on your needs, you can choose between different licenses of this add-in. 

Requirements: Office 365, 2019, 2016, 2013, 2010, or 2007 (Windows only)



Interested in other add-ins? Have a look at our list of alternative add-ins.