20+ smart tools to do your everyday work
Quickly, neatly and flawlessly
Like you, we use Excel on a daily basis. And we do understand the pain of performing the same routine tasks time and again. It's a real challenge to process tons of data manually and a mistake caused even by the slightest loss of attention might be fatal.
That was the reason why we designed and developed these add-ins. Originally created for our own use, the tools have been tested, enhanced and polished up and now we are ready to present them to you.
Tried-and-true solutions since 1998
The Ultimate Suite is a comprehensive set of tools for Excel that accumulated our 15 years of experience with Microsoft Office development. Over the years we've been adding new features, bypassing pitfall that emerged with every new Excel version and refining the code to make the tools as perfect as they can possibly be.
Simple and intuitive tools
The Ultimate Suite is an excellent set of tools for everyday use. Each add-in solves one of your usual tasks, whether it is removing duplicates or merging data, and it solves the task impeccably.
By combining several tools you can easily build a solution for practically any task just as with a Lego set. Your usual tiring, time-consuming and error-prone routines are not a challenge any longer!
- Remove duplicate rows in your table.
- Check 2 worksheets for duplicates.
- Find fuzzy matches (similar entries or typos).
- Combine two tables by common columns.
- Merge several cells, rows or columns into one.
- Consolidate multiple worksheets.
- Join data from duplicate rows into one leaving unique data only.
- Find (and replace) in all open workbooks at a time, search for values, formula, hyperlinks, etc.
- Find and fix broken links or references to other workbooks.
- Find cells of a particular color or font.
- Find all numbers or dates within a specified range.
Clean and polish up data
- Trim excess spaces.
- Remove unwanted or non-printable characters.
- Change text case.
- Delete empty cells or rows.
- And more...
- Generate random unique numbers.
- Generate random strings, passwords, dates.
- Shuffle rows, columns or individual cells.
- Get a random sample from a set of your data (e.g. for a lottery).
- Separate a large table into several smaller tables by selected column.
- Split a table into individual card views for each record.
- Spilt full names from one cell into separate cells for first name, last name, salutation and so on.
And much more
- Perform math operations on all selected numbers at once.
- Convert measurement units.
- Fill empty cells with the values from the adjacent cells.
- And have a dozen other smart tools at your fingertips.
Tested by over 100,000 users worldwide
You can work with your Ultimate Suite everywhere - on your home computer or terminal server, in campus, small office or corporate network, no problem! Tens of thousands of users all over the world have already made sure of this.
Supports all Excel versions, from 2003 to 2013
Each version of Microsoft Excel brings new capabilities along with new specificities and issues. We guarantee that your Suite will work faultlessly on any version, from classical Excel 2003 to the most up-to-date Excel 2013 64-bit.
20+ add-ins included in the Ultimate Suite for Excel
Please click on the add-in's name to read more.
Find and remove duplicate or unique values in seconds. Choose any columns for comparison. Color, select or delete the found entries.
Merge matching data from 2 Excel tables into 1 in no time. Comprehensible and easy-to-use substitute for Excel Vlookup function.
Combine data from several duplicated rows into one based on the selected key columns. Merge duplicate rows and pull unique records into appropriate cells.
Merge cells, rows and columns in a flash. All data are kept even if the selection contains multiple values.
Find and correct partial duplicates, similar records, misprints and typos from Excel worksheets.
Search in all or selected worksheets at a time. Simultaneously look in values, formulas, comments and hyperlinks.
Generate unique random numbers, strings, dates, passwords, codes and Booleans. Fill the range with occasional custom list values.
Sort individual cells or entire rows and columns; select certain percentage or number of your data at random.
Split names into individual cells: first, middle and last name, salutation, suffix, etc.
Perform various conversions between more than 200 measurement units in 19 categories.
See all workbooks and worksheets you work with on the add-in pane. Easily switch and navigate between them. Rename, delete, sort your worksheets in a click.
Delete extra spaces and change case in Excel, convert numbers formatted as text to numbers, remove or replace unwanted characters & more.
Easily consolidate multiple worksheets into one. Select the consolidation option you need: merge sheets from different workbooks into 1 file, join data from several worksheets or combine workbooks.
Split your table data into multiple new spreadsheets based on key values in the selected columns.
Group the selected rows by key column values, convert them to column view and export to one or multiple worksheets.
Scan your current linking worksheet for broken links. Easily fix references to other Excel files for flawless summary worksheets.
Find all cells that meet your criteria. Select cells by type, value or font format. See the number of the found entries on the add-in pane.
Fill empty cells in the selected columns with the value of the cell above or below.
Conveniently work with cell comments in your worksheets. Easily add, edit or delete cell notes, convert comments to cells and vice versa, add picture, author, date or time.
This set of 10 irreplaceable utilities that cut the clicks on your daily spreadsheet tasks. They make common operations quicker, easier and much more enjoyable. Get the following handy tools at your disposal: Filter by Value, Delete Blanks, Range Operations, Address to Clipboard, Formula Operations and more.
Bought any of AbleBits add-ins? Get a discount for the Ultimate Suite!
If you have ever purchased any of the AbleBits plug-ins, we are happy to give you a good discount for our Collection. Please contact us and we will send you a link to buy the Ultimate Suite at a special discounted price.
Great little time saver - now stop reading the testimonials and just BUY it!
I talked my supervisor into getting Ultimate Suite a few months ago for use here at work. I often have to deal with 2000 - 3000 row spreadsheets with 30 - 200 fields and matching between versions has always been a nightmare. He asked me how it was going the other day, in reference to the new spreadsheet tools. I said: "It's the best $100 we've ever spent!" - and I meant it. Undoubtedly has saved me hours of work time. So, one big "Thanks!" Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Thank you for your commitment to Ultimate Suite. I love the program, and I can't imagine using Excel without it! Ultimate Suite saves me many hours of effort with the projects I manage within Excel. The program paid for itself the first day I used it. You and your team have created a really great set of tools for use within Microsoft Excel. Thank you, thank you, thank you!!! Robert Madsen
One word... WOW!
One word... WOW! I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS! Dave Brown
I don't know how to thank you enough for your Excel add-ins
I don't know how to thank you enough for your Excel add-ins. I stumbled upon your website while trying to figure out how to merge two tables. When I saw your software had a free trial, I thought yeah right, how well is this going to work? I downloaded it and am AMAZED. It does just exactly what I need and I don't know how I lived without it. I have also referred your software to my friends. THANK YOU for making my life just a little easier. Jennifer Morningstar
I love your product
I love your product. It really saves me a lot of time and makes my job much easier. Brad Gibson
The best spent money on software I've ever spent!
I just have to tell you that I love your AbleBits Collection. I can't tell you how much time the collection has saved me…particularly the Merge Tables Wizard, Duplicate Removers, Merge Cell Wizard, and Split Names. This was the best spent money on software I've ever spent! Patrick Raugh
Awesome!!! I love the tools and have been using the compare one everyday since I downloaded it. Sheila Blanchard
It is like having an expert at my shoulder helping me...
I really feel that Ablebits has people like me in mind with your software development. It is like having an expert at my shoulder helping me work more effectively and efficiently. Now I have more time to goof off at work — none the wiser. Uh, that last statement is not really true — I will just have a lot less stress because things will go so much smoother. Linda Shakespeare
Your software really helps make my job easier
Your software really helps make my job easier. I don't know what I would do without Duplicate Remover, I use it several times a day for every project I work on. Thanks for making my life easier. Jeannie C.
Thanks for a terrific product that is worth every single cent!
I just have to tell you that the Duplicate Remover is the best tool I could ever have. I spend all day in Excel and Access and this tool has increased my efficiency 100% - ok well maybe 50%. But I honestly do not know how anyone who has to constantly run pivots, graphs, data exports yadda yadda yadda all day could ever go back to living without this tool once they have used it. Thanks for a terrific product that is worth every single cent! Dianne Young
Ultimate Suite add-ins work in Excel 2013 - 2003
Please have a look at the screenshot below. This is how your 20+ add-ins for Microsoft Excel will look like:
The Ultimate Suite Ribbon has 3 tabs
Duplicate Remover for Excel
Merge Tables Wizard for Excel
Random Generator for Excel
Random Sorter for Excel
Merge Cells Wizard for Excel
Measurement Units Converter for Excel
Advanced Find & Replace for Excel
Fuzzy Duplicate Finder for Excel
Split Names for Microsoft Excel
Workbook Manager for Excel
Cell Cleaner for Excel
Combine Rows Wizard for Excel
Quick Tools for Excel
Fill Blank Cells for Excel
Find Broken Links for Excel
Select Special Cells for Excel
Extract Data for Excel
Comments Manager for Excel
Split Table Wizard for Excel
Consolidate Worksheets Wizard for Excel
- ABOUT US