XLTools Guru Add-in for Excel

XLTools GURU is a package of a complete toolkit of all 20 XLTools features. So now, you can prepare, analyze, clear data, store Excel data and automate daily routines without the macros or the help of the VBA programming - no matter how complicated your task is, it’s time to work smart and make the most utility possible, turn the most difficult task easy.

XLTools Guru Add-in for Excel

Our XLTools Review

XL Tool Guru, the Microsoft Excel tool, is an aid.

Just imagine the complex array of workflow which is streamlined in your project getting done with just a click of the mouse.  The XLTools Guru has made it possible.  The various features like the Popup calendar, made for editing the dates is something interesting, XLTools Guru has improved interaction with dialogue boxes, it is standardized and the dialog boxes are fixed on top of Excel interface. 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. XLTools Guru lets you disable F1/F9 keys for all the Excel spreadsheets in a second – without even the need of a macro.

Also, it even has simplified range selection feature which helps in automatic selection of the ranges and tables, you can try automation because here you do not need macros or the VBA to fix the routine in your workflow, data cleaning is another feature to remove the unwanted space or if you want to convert a number into text.

This software comes handy with template files that contain several worksheets including mLEDGER, mITEM, Single, Multi and Stock.

 

Ease to Use90%
Ease to Install100%
Support85%
Feature-Rich90%
Value for Money90%
Tab View
SQL in Excel
Automation

XLTools

XLTools

XLTools

XLTools Guru 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
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.

 

Automation

Now you can automate routine operations without bulky macros and can even create custom buttons in Excel! XLToolss help to create and execute even one of the most complicated commands in a simple Excel table layout –  even the basic VBA knowledge will be ample.

 

Online Help

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

 

 

THIS TOOL IS FOR YOU IF...

  • If you use ERP downloaded Excel files as a base to generate custom MIS reports on regular basis.
  • If you want to reduce your TAT (turnaround time) significantly.
  • If you want to run SQL series on excel and on Excel Tables.
  • If you want to prepare Financial Models with combo-logical statements
  • If you prepare Management Reporting dashboards frequently.
  • If you’re involved in Performing CAAT & Forensic Audit techniques
  • If you want to automate your normal routine without the VBA Programming.
  • If you want on the spot and reliable results then XLTools Guru 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 TOOL IS NOT FOR YOU IF...

  • If you use Excel rarely like if you’re on sales field the whole time or you’ve been working as a salesman or cashier facing the consumer [Tbh, I love you guys, but this model is not going to help you]
  • You have got a personal assistant who is an Excel expert and can do all the number crunching for you [Maybe, this course will be more helpful for your assistant but not you.]
  • Anyone who wants instant results just because they have joined without taking any real action or practicing the working files. This course is not for you.
  • If you think you can use the XLTools license for multiple computers then you’re wrong. And you don’t need to take this tool.
  • If 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 responsive to questions very quickly.

 

Chris

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.

 

Nikolay

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!

Vitaly

COMPANIES Who use XLTools

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 Guru Add-in for Excel

The complete toolkit to automate any Excel operations
$199.95
  • one-time lifetime license
    20 features
    Automation without VBA
    + all PRO features
    + all Essentials features
    + help with automation of your routines in Excel
  • Priority support
  • 1 year free upgrades
  • 30-day Money-Back Guarantee
Join now
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
$690
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1800+ Office Productivity Tricks Lessons
  • XLTools Guru Add-in for Excel
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.