Solve 300+ daily tasks in Excel 365, 2024 – 2016

Ablebits Ultimate Suite for Excel

A comprehensive set of 70+ time-saving 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!
Ablebits Ultimate Suite - 70+ time-saving tools for Excel

Smart way to handle routine emails

Shared Email Templates for Outlook

If you are tired of repeatedly typing the same replies to routine emails, reply with a template in a click!
  • Create your set of fully customizable templates.
  • Personalize responses as needed.
  • Share templates with teams or use personally.
  • Access templates from any device on any platform.
Works on
Outlook for Windows
including Windows tablets
Outlook for Mac
Office 365:
Outlook on the web (in browsers)
Microsoft 365:
Outlook on the web (in browser)
iPads
(Outlook on the web / in browser)
Android tablets
(Outlook on the web / in browser)
Shared Email Templates

Bulk but trusted emails from your Outlook mailbox

Mail Merge for Outlook

If you often send flyers, newsletters, business proposals, or holiday greetings to your personal contacts, Mail Merge is just the thing. To save your time, it comes with customizable templates and adaptive layouts. You can launch your email campaign immediately or postpone it if needed. Try this tailored solution for your personal email events. Enjoy the benefits and find no drawbacks ;)
Works on
Outlook for Windows
including Windows tablets
Outlook for Mac
Office 365:
Outlook on the web (in browsers)
Microsoft 365:
Outlook on the web (in browser)
iPads
(Outlook on the web / in browser)
Android tablets
(Outlook on the web / in browser)
Mail Merge for Outlook to send out personalized bulk mailings

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. 40+ 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.
A complete collection of tools to simplify work with Google spreadsheet

Gmail templates made smarter

Shared Email Templates for Gmail

No more digging through messy drafts — keep your Gmail templates organized and just a click away!
  • Create customized reusable email templates.
  • Automate email content with powerful macros.
  • Share templates to keep teams on the same page.
  • Add a personal touch to replies with smart placeholders.
Works on
Chrome and Edge
browsers for Windows
Chrome browser for Mac
Shared Email Templates for Gmail.

20 latest reviews from our customers

Where has this been all my life?

Where has this been all my life? This program is amazing! It's saved me time and headaches! So easy to use, and so versatile ~ it is truly a magic wand.

Li,

Love it!

I use Merge Table Wizard religiously, cannot live without it. As an analyst, data is key & this is VLOOKUP on speed. Customer Service is prompt & exceptional.

Kelly,

Over and above the Excel add-in

Over and above the Excel add-in, after sales service, when needed, is superb. No two ways about it. As for the Ablebits Addin for Excel, you will not find any better elsewhere. Pricing suits what you get, and it is a bargain at best.

Daryll Norton,

The best of the best!

I have been a customer for some time, and each and every time I've needed assistance at all, they have been there and right away too! HIGHLY RECOMMENDED!

Michael,

Ablebits is worth the money

I’ve been using Ablebits personally for over a decade. I've upgraded to newer versions when needed because the Excel add-on is great. I use it almost daily to save time. It has so many use cases. If you use Excel, it is a must. Great cost for such a fantastic tool.

Will Lyons,

Great find!

I’ve been using Ablebits for over 3 years, and it has become an essential tool for expediting my workflow. The software is extremely reliable, user-friendly, and packed with features that save me hours in Excel. Tasks that once took me forever—like merging sheets and columns, cleaning data, and removing duplicates—are now done in just a few clicks. Highly recommend!

Cheryl,

A huge time-saver

I’ve used different versions of this add-in for close to a decade. It is one of the greatest time-saving tools for data wrangling I’ve gotten and I highly recommend it. Especially if you’re looking to do more with Excel but don’t want to be memorizing formulas. It works with a series if “Wizards” or guides How-Tos.

Olga,

Ablebits customer care Excels

I presented the Ablebits Customer Care Team with an Excel data-column extraction challenge that I lacked the experience or tools to perform. The timeliness of the Team's response, their understanding of the nature of the extraction requested, the expertise conveyed via email, the technical tools, and the supplied demonstration video were most professional. I'm wowed!

K. Pate,

Hard to live without this addon, a must

Been using this for a year now. Simplifies soooo many annoying tasks in Excel. The icons make it readable and easy to find what tool you're looking for. This has been by far the best enhancement for my productivity with Excel for my job.

Alex Huffman,

5 star customer service

I've been using the Ablebits Excel add-on for years and every time I need to install my PC, I tend to need a refreshed activation key and every time, the guys at Ablebits help me instantly without any fuss. Excellent product and Excellent customer support.

Simon Hodgkinson,

Ablebits provides great support - even years after purchase

Ablebits is a great tool that I have been using for nearly eight years. It quit responding recently and I contacted Support for help. They responded the next day with a solution along with assistance on the install. Great, responsive customer support!

Bill Bramble,

Highly recommended!

I highly recommend Ablebits for anyone who works with multiple spreadsheets, build reports, does integrations, or needs to transform data quickly. It's an awesome product, and the company is also super helpful and responsive.

Evan Antonellis,

Cannot work without Ablebits

We mainly use the merge-table wizard to move data between Excel files. Very easy to use and extremely fast even with huge spreadsheets. I don't know how anyone can be without it. We rarely need help from them, but when we do they answer immediately. Strongly recommended!!

Fridtjof Lund-Johansen,

Best Excel Addin

This is by far one of the most useful addins/piece of software I have ever purchased. It solves a ton of excel issues easily. I can't recommend it enough. I have used it weekly for over 5 years. Additionally, support is very helpful.

cmitts,

Ablebits: 5* for quality, 5* for function, 5* for support

Ablebits is one of the best timesavers in my toolbox. I fully believe that I gain >50% efficiency time wise and experience a dramatic increase in accuracy. I just received wonderful and timely tech support from the support team. Fast response. Accurate. To the point. 5* for quality, 5* for function, 5* for support. Thank you Ablebits team!

DavyCinco,

I can’t tell you how much I use and appreciate Ablebits

I can’t tell you how much I use and appreciate Ablebits. The Merge Tables function is worth it alone, but I’m still discovering new fun things this add-in can do. It’s hands down the best program I’ve used to enhance data analysis and curation.

Christina Cenczyk,

Since I found Ultimate Suite, I have been able to actually enjoy my data days

I am the lucky person in our office to manipulate data in Excel. I used to dread it and take days to complete. Since I found Ablebits Ultimate Suite for Excel, I can be the office star and have been able to actually enjoy my data days. This product saves me frustration and time. Excellent support, great documentation and it is easy to work through. Highly recommended!

Kelly Rickard,

My experience with Ablebits has been nothing short of outstanding

Overall, my experience with Ablebits has been nothing short of outstanding. Not only does their software deliver on its promises, but their commitment to customer satisfaction truly sets them apart. I highly recommend Ablebits to anyone in need of reliable and feature-rich software, backed by unparalleled support.

Vijayakrishna Rapaka E,

These should all come standard with Excel

It boggles my mind that it took a third party to add these tools to Excel. Used Ablebits throughout its trial whenever i was hitting pain points in Excel, and it invariably made life easier and streamlined my work. I can genuinely say it's saving me at least 3 to 4 hours a week.
All in all, if you work in Excel daily like me and there's no hope of your business moving away from it, Ablebits will make your life infinitely easier and it's definitely worth the money.

Alex Lugan,

I've been with Ablebits since 2018

I've been with Ablebits since 4/2018. Numerous updates and new installs. No complainants at all. They are very responsive and always very professional. The software is the best Excel add-in that I've tried. If you try their Software, and need help, email them and they'll respond to help. If you've tried other Excel add-ins and felt letdown, give Ablebits a try! You'll love the software and technical support if you need it.

Marv Wilson,

New blog posts

Excel PERCENTOF function to calculate percentage of total

Calculating how much each value contributes to a total is something many Excel users do every day. In older versions, this usually meant creating your own formula that divided a part by the whole. The PERCENTOF function gives you a quick and direct way to return that percentage without building a formula manually.

Full-featured email templates in new Outlook and web: how to create and share

For a long time, the new Outlook app and Outlook online only provided simple text snippets through the My Templates add-in. Those worked fine as quick phrases for repetitive emails, but they fell short whenever you needed a complete, formatted ready-to-send message with attachments. That gap is finally filled.

Filter emails in Gmail: create and manage rules

Want to know how to sort your inbox automatically? Learn how to use Gmail rules to organize your messages effortlessly. This complete guide covers everything you need to know about Gmail filters – from creating, editing, and sharing rules to advanced tricks for managing spam, sorting by date, and organizing unread messages.

How to create Excel progress bar based on checkboxes

If you've already used Excel checkboxes to track project milestones, a progress bar is the perfect next step. It gives you a clear visual snapshot of how close you are to reaching a goal. In Excel, you can easily create a progress bar using conditional formatting or charts, no coding required.

Outlook not working or not responding – reasons and solutions

There are many possible reasons why Outlook might start misbehaving. This guide will help you identify and troubleshoot the problem. We'll start with quick and simple steps that address the most common causes, then move on to a few deeper fixes if the issue persists.

How to add a checkbox in Excel the easy way and use in formulas

Whenever you want to create a to-do list or project tracker, attendance sheet or review checklist, there is one small element you'll definitely need – a checkbox. In modern versions of Excel, adding checkboxes is much simpler than you might think, and you can set it up in under a minute.

Excel: featured articles

Outlook: featured articles

Google Sheets: featured articles