Need Help? Chat with us

XLTools PRO Add-In for Excel

XLTools PRO includes 19 features for professional work in Excel. Unique tools like Version Control, SQL Queries, and Mail Merge help you prepare, analyze, store data and deliver spot-on reliable results.

XLTools PRO for Excel Productivity

Our XLTools Review

Well, XL Tools Pro is one of the finest tools and has got few best features. This tool offers not just a few but 19 important and interesting features out of which few important ones are Version Control, VBA Version Control, SQL Queries, Mail Merges and few others. Version control helps in saving the history of changes made inside the workbook. With the use of the SQL Series, the intuitive queries editor highlights syntax and helps create queries even if it is against tables from distinguishable spreadsheets. While using the Mail Merges in Excel if for the one who doesn’t wish to leave the Excel interface and send in bulk the working and marketing emails. Mail Merges in Excel helps in creating email templates, attach files and send personalized messages from Outlook, Gmail, Hotmail

 The Pro version of XLTools doesn’t come up with the automation technique. But rest all the features which are available on XLTools Guru come in the XLTools Pro.

The popup clock which helps to simplify the complexity of work by adding time values in MS Excel. Now merging cells without losing your data can be done easily.

This tool is something which guarantees limitless imagination and you can apply your skills here for the better output


Ease to Use90%
Ease to Install100%
Value for Money90%
Tab View
Popup Calendar
SQL in Excel




XLTools PRO Add-In for Excel Offers

If you’re not satisfied then let us know in the first 30 days and get a complete refund.

30 Days Money Back Guarantee

Full 30 Day Money Back Guarantee No Questions Asked

100% Secure Checkout

Verified & Secure Checkout. Pay Via Credit Card or PayPal

Here’s what you’ll get with Excel Tool

Popup Calendar

Entering a date in a cell is no more a problematic task. With the introduction of Pop up Calendar feature, you get to pick up any date from the calendar, and the popup calendar will track in the absolute correct format. It displays the week numbers, days of the week added the current date.

Workbook Organizer

If you wish to add, delete, rename, sort, filter, copy, hide, unhide, protect, unprotect, save as separate files, etc. You can do it in one go. Easily navigate and manage multiple workbooks at the click of the mouse.

Popup Clock

Popup clock is the effortless feature which instantly simplifies the complexity of the work by adding time values in MS Excel. With this, you get to select and set any time format and you accomplish how to insert time or how to insert date along with the time into the cells and ranges.

Version Control

Version Control helps save the history of changes made to Excel workbooks, track and compare changes, comment on versions, or roll back to a previous version. For effective group work on a shared document, view who modified the file and when.

VBA Version Control

This unique feature is essential for those who often write Excel macros. Version Control helps track changes to Excel VBA projects, compare changes in script line by line, and recover a previous version of a macro.

SQL Queries

Now run SQL Queries directly against Excel tables. The intuitive queries editor highlights syntax and helps create queries even if it is against tables from distinguishable spreadsheets: SELECT, JOIN, GROUP BY, DISTINCT, etc.

Combine Data

With XLToolss you will be able to merge cells without losing your data! Combine data in adjacent cells by columns, by rows or into a single cell, with any separator – and if necessary merge these cells in the same way.
Now merging cells without losing your data can be done easily. This feature combines data in adjacent cells by columns and by rows into a single cell with the use of any separator – and if necessary merge these cells

Unpivot Table

Unpivot table will undo the pivot and transform the 2D tables and complex crosstab tables having multilevel headers to a plain, flat list quickly and accurately. Also, it brings in the added advantage of operations on your data, e.g. PivotTable generation, charting and filtering, etc.

Data Cleaning

If you’ve imported or pasted any data to Excel and want to clean it. Then bulk cleaning is possible and easy now. Click on the data cleaning option which is going to remove all the extra spaces and the non-printing characters, it will change the text case and converts the cell formats from numbers to text and vice versa.

Fill Blanks

At times, when there are gaps in the table it complicates the calculations and analysis. Fill Blanks is the feature, which will instantly populate the blank cells. You can choose to fill blanks with values of the nearest cells: downwards, upwards, rightwards or leftwards.

Combine Sheets

In the blink of an eye, the add-in click will copy data from multiple worksheets across different workbooks into one master worksheet. Now you’ll get to easily combine the data from sheets with the same name and merge similar tables under a single header.

Split Table

In case you want to split an entire table or a range into multiple worksheets the Split Table is the fastest solution to do it. Now you do not have to think before breaking down a report, break down a report into sub-reports by key column value, or split a long list by a fixed number of rows.

Export to CSV

Dealing with a lot of data export and have been really occupied with it then Export to CSV is going to help you. Convert the Excel data into plain text CSV with exhaustion. Simply export to CSV proceeds without closing the original Excel file or changing its format.

Sheet Switcher

If you’ve been struggling a lot with working on Excel Workbooks and you think of switching back and forth in between the most recent worksheets, then the Sheet Switcher by XLTools is the equivalent of Alt+Tab for Windows – now see the navigation getting quicker and comfortable!

Disable F1/F9

Accidentally hitting on F1 (Excel Help) or F9 (Calculate All) keys now, will not slow you down. This will disable F1/F9 keys for all Excel spreadsheets in a second – without even the need of a macro.

Repeat Selection

Now shading of alternate rows, or every other column, and in a checkerboard or other pattern is done in seconds! All you got to do is select the pattern once and apply it to the whole range. Holding ‘Ctrl’ and handpicking cells to make a recurrent selection is nowhere needed.

Count by Color

The add-in feature helps to instantly aggregate values in a selected range based on the cell’s background color, font color or conditional formatting color. Now you can quickly calculate and compare COUNT, SUM, AVERAGE, MIN, MAX results for each color.

Mail Merge

Send bulk marketing and work emails without leaving Excel interface! Mail Merges in Excel Do not want to leave the Excel interface and send in bulk the working and marketing emails. Mail Merges in Excel helps in creating email templates, attach files and send personalized messages from Outlook, Gmail, Hotmail, and SendGrid, etc.

Match Columns

This tool is going help you when you wish to make a general comparison of columns, instead of values cell-by-cell. Match column helps you to find, how much the columns are similar – to get the exact match percentage of columns compared with each other or against your benchmark values.



Online Help

Get assistance at one go i.e. as promptly as possible. XLToolss Guru improves with your questions.


This XLTools is for you if...

  • You use ERP downloaded Excel files as a base to generate custom MIS reports
  • You want to reduce your TAT significantly (turnaround time)
  • You want to prepare Financial Models with combo-logical statements
  • You prepare Management Reporting dashboards
  • You are involved in Performing CAAT & Forensic Audit techniques
  • If you want the popup clock which helps to simplify the complexity of work by adding time values in MS Excel. Now merging cells without losing your data can be done easily.
  • If you want on the spot and reliable results then XLTools Pro is for you.
  • If you want to copy many worksheets at a time or save as separate files, manage and organize multiple workbooks and worksheets then you should take this tool.

This XLTOOLS is not for you if...

  • You use Excel rarely like if you’re in sales field all the time or work as a salesman or cashier facing the consumer [I love you guys, but this model will not help you]
  • You have a personal assistant who is an Excel expert and can do all the number crunching for you [May be, this course will be helpful to your assistant]
  • Anyone who wants to instant results just because they have joined without taking any real action or practicing the working filesYou think you can use the XLTools license for multiple computers then you’re wrong. And you don’t need to take this tool.
  • You’re a Mac user and you do not use office on Windows, you don’t need to take this course.

Watch XLTools in Action

Other XLTools User Testimonials

I have been using Excel for many years and on the constant lookout for add-ins to help with my workflow and productivity. I work with data and databases quite a lot, and use applications to help me find and filter data. The SQL Queries and custom Automation features alone save me hours in my day to day activities. If you have repetitive tasks or need an element of database querying in Excel then this add-in is for you. XLTools team is very supportive and respond to questions very quickly.


The reason I started using XLTools was the Calendar feature. I work mostly with Excel tables where I need to input a lot of data for travel, personnel issues and treasury management. Entering manually all those dates and having to format the cells every time became really an issue for me. So I started looking for a solution. I tried few other options, but when I found XLTools it really did everything I wanted the way I wanted. Another useful feature I use a lot is the Sheet Switcher since normally my Excel files contain many sheets and I find it really easy to navigate this way. Thank you very much again for your kind assistance and time spared for the prompt support. Wish you all the best.


SQL Queries is a must-have tool. Can’t thank you enough! 30000 items, 15 warehouses – and it takes only 4 seconds!! to select and sort items available in storage, and generate a complete table. This is FANTASTIC for Excel!!! Tech support is great above all, thank you!



Every day XLTools helps hundreds of professionals in IT, accounting, finance, engineering, data analysis, business consulting, research, etc. We are proud to have customers all over the world.

Save Time Today

XLTools Pro Add-in for Excel

Professional tools to add new functionality to Excel
  • one-time lifetime license
    19 features
    Version Control
    VBA Version Control
    SQL Queries
    Mail Merge
    + All Essentials features
  • Priority support
  • 1 year free upgrades
  • 30-day Money-Back Guarantee
Add to Cart
Office Training Bundle Package

Office Training Bundle + XLTools Guru Add-in for Excel

Unlimited Learning to All YodaLearning Courses + XLTools Guru Add-in for Excel
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1800+ Office Productivity Tricks Lessons
  • XLTools Guru Add-in for Excel
    20 features
    Automation without VBA
    + All Popup Calendar Features
    + all PRO features
    + all Essentials features
    + help with automation
    of your routines in Excel
    +Priority support
    +1 year XLTools free upgrades
Join now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Frequently Ask Questions

I have purchased XLTools. Where do I download and get my license?

Right after the purchase you should have received a confirmation email with your license key. Please check your spam folder, or contact us if you did not receive the email.

1. Install XLTools:

  •  If you have XLTools add-in installed, e.g. to take a free trial, you do not need to install it again. Simply activate your license – Step
  • If you do not have it installed yet, please download and install XLTools. See the detailed Installation Guide.

2. Activate your license:

  •  Copy the license key delivered to you by email > Open Excel > XLTools tab > Click on the ‘License’ button > Paste your license key > Apply. See the detailed License Activation Guide.

I have misplaced my license key. Can it be restored?

Of course! Please send us an message from the email address you used to purchase XLTools license. This way we can track your order and send you your license key.

Can I get a demo or take a free trial?

You can begin the Free Trial – 14-day full-access – immediately after installation. We strongly suggest you take the Free Trial before purchasing a license.

Download and install XLTools > Open Excel > Click ‘Free Trial’ in the popup window > Enter your contact details > Click ‘Begin the Free Trial’.

Does XLTools work on a Mac?

XLTools add-in is only compatible with Office for Windows. We do not have plans to develop a version for Mac. However, you can run XLTools if you have a Windows virtual machine on your Mac.

You may be interested in our online Office Add-ins. Their functionality is similar to the desktop version. Office add-ins work in Excel for iPad and Excel for Mac.

What are the system requirements for XLTools add-in?

Compatible with Microsoft Excel 2016, 2013, 2010, 2007, as well as desktop version of Office 365.
Supported on Windows 10, 8.1, 8, 7, Vista, XP SP1.

You should have administrator rights to install the add-in.

How do I download and install XLTools add-in?

Close all Excel files > Download XLTools for your Excel version > Save the file > Run the file as administrator.

How do I uninstall XLTools from my PC?

You can uninstall XLTools like any other program: Control Panel\Programs\Programs and Features > Select ‘XLTools Add-in for Microsoft Excel’ > Uninstall.

How can I reinstall XLTools?

1. Uninstall: Control Panel\Programs\Programs and Features > Select ‘XLTools Add-in for Microsoft Excel’ > Uninstall.

2. Install again: Download the latest version > Save the EXE file > Run the file as administrator.

3. Activate the license: If you have a license, it will activate automatically. If it doesn’t, please activate manually: Find your license key (it was emailed to you after the purchase) > Open Excel > XLTools tab > Click the ‘License’ button > Paste your license key > Apply.