- Professional
We do not mean complicated. We mean intuitive tools that deliver spot-on and reliable results no matter how difficult your task is. - Powerful
A small but meaningful toolkit to power up your Excel. Just one tab with unique features helps prepare, analyze, save data and even automate operations easily. - Productive
Get the job done much faster and with no frustrations. Do not waste your time on mindless tedious routines or painstaking bulky VBA coding. - We care about your experience
We answer every question promptly. Your opinion matters! Each new version has improvements based on your feedback and real use cases.
Features
-
Popup Calendar
Never again will you face a problem with date formatting when entering a date in a cell – just pick a date from the calendar! The Popup Calendar will automatically apply the correct format. The calendar displays week numbers, current date and time.
-
Version Control
Version Control helps save Excel spreadsheet history, comment on versions, track and compare changes, or roll back to a previous version. For effective group work on a shared document, view who modified the file and when.
-
SQL Queries
This easy to use add-in allows you to run SQL Queries directly against Excel tables. The intuitive queries editor highlights syntax and helps create queries even against tables from different spreadsheets: SELECT, JOIN, GROUP BY, DISTINCT, etc.
-
Combine Cells Data
With XLTools 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.
-
Unpivot Table
Unpivot Table will transform 2D tables and complex crosstab tables with multilevel headers to a flat list quickly and accurately! This will allow further operations on your data, e.g. PivotTable generation, charting, filtering, etc.
-
Data Cleaning
Cleaning bulk data imported or pasted to Excel is easy now! In just one click, Data Cleaning removes extra spaces and non-printing characters, changes text case, and converts cell formats from numbers to text and vice versa.
-
Export to CSV
This tool will save time for those who work a lot with data export. Now converting Excel data to plain text CSV will not exhaust you – export to CSV proceeds without closing the original Excel file or changing its format.
-
Sheet Switcher
Do you work with large Excel workbooks and need to switch back and forth between the most recent worksheets? The Sheet Switcher by XLTools is the equivalent of Alt+Tab for Windows – it makes navigation quick and easy!
-
Repeat Selection
No need to hold ‘Ctrl’ and handpick cells to make a recurrent selection. Now shading of alternate rows, or every other column, and in a checkerboard or other pattern is done in seconds! Select the pattern once and apply it to the whole range.
-
Mail Merge
Send bulk email directly from Excel spreadsheets quickly and easily! XLTools helps prepare recipients lists, create email templates and send personalized messages from Gmail, Hotmail, Outlook, SendGrid, or other accounts.
-
Columns Match
This tool will help you when you need a general comparison of columns, instead of values cell-by-cell. Learn how much the columns are similar – get the exact match percentage of columns compared with each other or against your benchmark values.
-
Automation
Automate routine operations without bulky macros and create custom buttons in Excel! XLTools helps create and execute even complicated commands in a simple Excel table layout – and basic VBA knowledge will be sufficient.