Ultimate Suite for Microsoft Excel

Comprehensive set of time-saving tools

60+ professional tools that cover over 300 use cases: merge tables and combine worksheets, find and remove duplicates, concatenate and split strings, trim spaces and clean data, compare two sheets for matches and differences, built custom-tailored formulas, and a lot more! Whatever task you are faced with, you'll find the tool to accomplish it quickly and flawlessly.
Ultimate Suite for Microsoft Excel

Power Tools for Google Sheets

A complete collection of tools for simpler work with spreadsheet data

Power Tools takes the burden of monotonous repetitive work in spreadsheets off your shoulders. 30+ features will streamline multiple routine operations in Google Sheets: remove duplicates, merge cells and tables, sum by color, combine sheets, perform advanced search and replacement, split names, and much more. Keep a list of your favorite tools and re-apply them to any cells any time.
Power Tools for Google Sheets

Add-ins Collection for Microsoft Outlook

8 helpful tools for Outlook that will boost your mailing productivity

We have rounded up our best add-ins for Microsoft Outlook in one collection to reveal the full power of your inbox and improve your emailing routine. Customize your Outlook with lots of great features like email templates, auto-filling CC or BCC line, checking emails before sending, and more.
Add-ins Collection for Microsoft Outlook
1/3

Add-ins for Microsoft Excel 2019, 2016 – 2007

60+ professional tools in one Excel Suite

With these time-saving tools that collectively have over 300 useful features, you can automate most of your daily tasks in Excel and increase your productivity at least by 50%! It's many years of our experience with Office development embodied in the perfect code of solutions that work flawlessly on all Excel versions and all data sets.
Read more        Free download

Merge Excel worksheets

Merge Tables Wizard quickly finds and merges matching data from two Excel tables.

Remove duplicates in Excel

Duplicate Remover will quickly find, select, identify, or remove duplicates from your Excel worksheets.

Consolidate multiple worksheets

With Consolidate Worksheets Wizard you can combine multiple Excel worksheets from different workbooks into one easily and quickly.

Compare two sheets

With Compare Worksheets Wizard you can quickly find, highlight, and merge differences between two Excel sheets or lists.

Merge Excel cells

Merge Cells lets you combine the selected range of rows, cells, or columns into one and never lose any of your data during the merge.

Combine duplicate rows

With Merge Duplicates Wizard you can quickly combine duplicate rows into one by one or more key columns without losing any data.

Text Toolkit

With Text Toolkit you get a quick way to trim excess spaces, change text case, add text and split cells, count characters and words, extract text, and more…

Date & Time Formula wizard

Perform all sorts of date & time calculations: add and subtract dates, get a date difference, and calculate age.

Plug-ins for Microsoft Outlook 2019, 2016–2007

Add-ins Collection for Outlook

Get 8 helpful tools to boost your inbox productivity. Reply to emails with templates, automatically add CC and BCC, check emails before sending, get alerts for important messages, see sender's time zone, and analyze email headers.
Read more        Free download

Shared Email Templates

This add-in for Outlook and web app lets you quickly reply to emails with templates that are stored in a cloud-based service. Easily share templates across your devices and with colleagues.

Check email before sending

Outgoing Email Checker for Outlook will check your email before sending it for conditions you define in the rules.

Reply to email with template

With Template Phrases add-in you can instantly insert commonly-typed text into your Outlook e-mails, share your templates with co-workers, use various macros, and more.

Important Mail Alert

The tool scans incoming emails for your alert key words and pops up a notification each time you get an urgent message.

Auto BCC in Outlook

Automatically send BCC (blind carbon copy) or CC in Outlook, create different rules and add exceptions for different e-mail accounts when sending your messages.

Quick Reply

Just select the email and pick the needed template from the list. The text will be inserted into the message and sent automatically.

Email Headers Analyzer

The utility will help you quickly display and examine Internet headers.

Sender's Time Zone

Displays the sender's current time, your time zone difference and the time since the message was sent.

Add-ons for Google Sheets

30+ tools to boost your Google Sheets

This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets.
Read more        Free download

Remove Duplicates

Quickly find duplicate or unique cells and rows in one table, or compare two columns or sheets to highlight, copy, move, or delete the results.

Combine Sheets

Pull the data from many sheets to one spreadsheet, sheet or a custom location. Identify column headers and save original formatting if necessary.

Consolidate Sheets

Merge data from multiple spreadsheets into one and summarize all numbers based on their position in tables.

Merge Values

Bring values from adjacent cells together and get a new column, row, or cell with the results.

Merge Sheets

Find matching records in two sheets to update relevant rows of data in your main table. Five simple steps guide you through the process.

Split Names

Quickly derive first, last names, and titles from the column with names. The add-on is taught to recognize dozens of suffixes and post-nominals.

Random Generator

Get unique raffle numbers, passwords, random dates within a certain time period, or almost any other type of data in the selected range.

Combine Duplicate Rows

Get rid of multiple duplicate rows by merging relevant records from other columns together. Different delimiters and AutoSum functions are there to help you combine your data.

Add-ons for Google Docs

Search & Navigate

Search within headings, bookmarks, images, tables, or text, and use your document outline for quick navigation.

Doc Tools

Handy time-savers for your work with documents: change case, spell numbers, sort lists and tables, adjust font size and highlighting.

Styles for Google Docs

Get 12 professional style sets for your Google Docs to change the look of your headings and text in a click.

Add-ins for Microsoft Excel Online

Duplicate Remover

Get the possibility to identify duplicate or unique records in your online Excel sheet in 3 simple steps.

Split text to columns

Use any delimiters to split text across multiple columns in the online version of Excel.

Advanced Find and Replace

An excellent solution for anyone who misses the possibility to find and replace data in Excel online.

Add-ins for Microsoft Outlook on the web

Shared Email Templates

This add-in for Outlook and web app lets you quickly reply to emails with templates that are stored in a cloud-based service. Easily share templates across your devices and with colleagues.

Attachments

Quickly see all files used in the email conversation. Search the list by key words, filter by sender, or sort by date.

Template Phrases

An essential tool for effective email communication: use your typical replies in a click.

Components for Microsoft Office developers

Create Office add-ins in .NET

Add-in Express for Office and .NET is your all-in-one framework for developing commercial class extensions for all applications and all versions of the Microsoft Office suite, including Outlook, Excel, Word, PowerPoint etc.

Develop Office plug-ins in Delphi

Add-in Express for Office and Delphi VCL is the powerful platform for creating fast, compact and easy-deployable COM add-ins, Excel Automation add-ins, RTD servers and smart tags for Microsoft Office 2019 - 2003.

Disable Outlook security

Using Security Manager you can bypass Outlook security settings and avoid warnings, alerts or prompts in add-ins and applications that interact with Microsoft Outlook.

Program IE add-ons

Add-in Express for Internet Explorer offers a simple and quick way to build thread-safe, secure, isolated, deployable and context-sensitive IE add-ons.

Designer for WiX setup projects

Designer for WiX Toolset in an extension for Visual Studio that enables developers to create any WiX-based setup projects in the familiar Visual Studio way.

VDProj to WiX Converter

VDProj to WiX Converter is an extension for Visual Studio that lets developers convert their existing Visual Studio setup project to a WiX Setup project in a click.

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.

Love the products!

Love the products! They have saved me thousands of hours and they are responsible for me getting a promotion at my last job, which helped me land my current position as a manager.

David Johnston

It's the best $100 we've ever spent!

I talked my supervisor into getting Ultimate Suite. I often deal with huge tables and matching between versions has always been a nightmare. He asked me about the new tools and I said: "It's the best $100 we've ever spent!" Indeed has saved me hours of work time. So, one big "Thanks!"

Mike Cavanagh

Incredible product, even better tech support…AbleBits totally delivers!

I use AbleBits every day and keep finding new uses. Changing jobs, I get my new employer to cough up the very reasonable cost of this software. There're things I just can't complete any other way in large datasets. My coworkers think I'm a wizard. But I'm just a religious user of AbleBits.

Deborah Bryant

Anyone who works with Excel is sure to find their work made easier by Ablebits

I've been using Ultimate Suite for almost a year and found it invaluable for my projects. I like the ability to merge tables based on 1 or more attributes, transpose columns and rows, and to transform data with Cell Cleaner utility. Plus, Ablebits' support is reliably fast and courteous.

Jackie Lee

Excel is at its best now

Ever since I found your add-ons, it has been a life saver or should I say a major time saver. I have bought two packages for both work computers. Excel is at its best now because of you. Thank you!

Annie C.

KUDOS to you guys for solving a problem that our IT department doesn't understand

Our IT thought they know how the sales department should function and destroyed some data files. With AbleBits I was able to regenerate my database in a few clicks. This was AWESOME. KUDOS to you guys for solving a problem that even our IT department doesn't understand.

Erik Peterson

AbleBits suite has really helped me when I was in a crunch!

Having AbleBits suite really helped me when I was in a crunch! It was intuitive and saved time on my job! Now I'm finding other capabilities I wasn't aware of, (first needed the easy merge capability). The other features are valuable time savers as well. Thanks for the product!

Nelda Fink

Ablebits is a fantastic product - easy to use and so efficient.

Ablebits is a fantastic product that I also brag about, because it is easy to use and so efficient.

Debra Celmer

I have enjoyed every bit of it and time am using it

I got this add-in and it is doing a great job for me. I have enjoyed every bit of it and time am using it. Great one from AbleBits… I recommend this for any data management and excel users.

Christian Onyekachi Nwosu

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 can't imagine using Excel without it! The program paid for itself the first day I used it. Your team has created a really great set of tools for use within 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. I stumbled upon your site figuring out how to merge 2 tables. When I saw a free trial, I thought how well is this going to work? I downloaded it and am AMAZED. I don't know how I lived without it. THANK YOU for making my life easier.

Jennifer Morningstar

Anybody who experiences it, is bound to love it!

Anybody who experiences it, is bound to love it! There're only 2 ways to "exploit" Excel's potential: be a geek or embrace Ultimate Suite. Why waste time on routines that can happen with a click of a mouse? Make use of Excel's capabilities without wasting time and energy.

Kumar Nepa

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 it has saved me, particularly Merge Tables Wizard, Duplicate Removers, Merge Cells Wizard, and Split Names. This was the best spent money on software I've ever spent!

Patrick Raugh

Awesome!!!

Awesome!!! I love the tools and have been using the compare one everyday since I downloaded it.

Sheila Blanchard

THANK YOU, THANK YOU, THANK YOU!!

I'm happy there is a company (Ablebits) where support really can solve customer's problem! Great job!

Tibor

It is like having an expert at my shoulder helping me…

I feel that Ablebits has people like me in mind with software development. It's like having an expert at my shoulder helping me work more efficiently. Now I have more time to goof off at work. Uh, that last statement isn't true - I just have a lot less stress as things 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.

Love the products!

Love the products! They have saved me thousands of hours and they are responsible for me getting a promotion at my last job, which helped me land my current position as a manager.

David Johnston

These companies choose Ablebits add-ins

New tips, releases and updates

Svetlana Cheusheva

How to VLOOKUP across multiple sheets in Excel with examples

When looking up some information in Excel, it's a rare case when all the data is on the same sheet. More often, you will have to search across multiple sheets or even different workbooks. The good news is that Microsoft Excel provides more than one way to do this. Continue reading

Svetlana Cheusheva

How to count cells with text in Excel: any, specific, filtered cells

Initially, Excel spreadsheets were designed to work with numbers. But these days we often use them to store and manipulate text too. Want to know how many cells with text there are in your worksheet? Microsoft Excel has several functions for this. Continue reading

Natalia Sharashova

Google Sheets QUERY function: a spreadsheet cure-all you have yet to discover

If you've been following this blog for a while, you may remember QUERY. I mentioned it as a possible solution for a couple of cases. But those are far from enough to uncover its full potential. Today, it's high time we get to know this spreadsheets superhero properly. And guess what – one equally noteworthy tool will also be there :) Continue reading

Svetlana Cheusheva

How to export and import contacts between Outlook and Google Gmail

Switching between Microsoft Outlook and Google Gmail is a very common trend these days. Some people are migrating from a desktop-oriented Outlook app to a cloud-based Gmail while others are using different email clients for their personal and business communication. Luckily, both Outlook and Gmail make it possible to transfer all your contacts in one go. Continue reading

Natalia Sharashova

Google Sheets FILTER function: formulas and tools to filter data in spreadsheets

If the only way you know of creating a filter in Google Sheets is the standard tool, I have a surprise for you. :) Come explore the FILTER function with me. There are plenty of ready-made formulas you can borrow, along with a new powerful tool that complements the filtering toolset immensely. Continue reading

Svetlana Cheusheva

How to import contacts into Outlook from CSV and PST file

There may be different reasons why you may want to transfer contacts into your Outlook address book. For example, you inherited a list of contacts in an external database, or you are migrating from another mail server, or perhaps you are setting up a new account. Continue reading

Svetlana Cheusheva

How to export contacts from Outlook

Whether you are migrating to another email service or making a regular backup of your data, it is crucial to transfer all contact details without any fail. This tutorial will teach you a few easy ways to export Outlook contacts into a .csv or .pst file, so that you could later import them anywhere you need. Continue reading

Svetlana Cheusheva

Excel INDEX MATCH MATCH and other formulas for two-way lookup

When searching for something in your Excel spreadsheets, most of the time you'd look up vertically in columns or horizontally in rows. But sometimes you need to look across both rows and columns. This is called a two-dimensional lookup, and this tutorial shows how to do it in 4 different ways. Continue reading

Svetlana Cheusheva

Excel INDEX MATCH with multiple criteria - formula examples

Although Microsoft Excel has special functions for vertical and horizontal lookup, expert users normally replace them with INDEX MATCH, which is superior to VLOOKUP and HLOOKUP in many ways. Among other things, it can look up two or more criteria in columns and rows. Continue reading

Svetlana Cheusheva

Excel XLOOKUP function - new way to look up vertically and horizontally

The tutorial introduces XLOOKUP - the new function for vertical and horizontal lookup in Excel. Left lookup, last match, Vlookup with multiple criteria and a lot more things that used to require a rocket science degree to accomplish have now become as easy as ABC. Continue reading

Svetlana Cheusheva

How to share Outlook calendar with Google

Sharing something between two different applications is often far more complicated than it needs to be, especially when it comes to Microsoft Outlook and Google Gmail, the two most prevalent mail and calendar apps used today. This tutorial will teach you 3 easy ways to share Outlook calendar with Google without using any extensions, plug-ins or third-party tools. Continue reading

Svetlana Cheusheva

How to add and view shared calendar in Outlook

In the previous article, we discussed different ways to share Outlook calendar with other people. Looking from another angle - if someone shared a calendar with you, how do you open it in Outlook on your desktop? Continue reading

Mary Trifuntova

How to use MINIFS function in Microsoft Excel

When it comes to finding the minimum based on conditions, there are several possible solutions. You’ll see different approaches to locate the lowest value and choose the one that suits best for you. Continue reading

Mary Trifuntova

Excel MIN function - usage and formula examples

If you have a large range of data to find the lowest value in, the scrolling and looking for it manually is not an option. Please check different ways of locating a minimum number in Excel and choose the best one for your task. Continue reading