Ultimate Suite for Microsoft Excel

Comprehensive set of time-saving tools

70+ 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.
Free download
14-day fully functional version for Microsoft Excel 2019 – 2010
Read more
Ultimate Suite for Microsoft Excel

Shared Email Templates

Simply templates for your emails. And nothing else.

With this tool, you can create and use Outlook email templates on your PC or Mac with desktop Outlook, or on tablet, opening the Outlook online version in browser. Moreover, you can share your templates with colleagues and manage user permissions for them. Finally, you can encrypt your shared templates to be sure your privacy is protected.
Free downloadRead more
Shared Email Templates

Mail Merge for Outlook

Bulk but trusted emails from your Outlook mailbox

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 ;)
Free downloadRead more
Mail Merge for Outlook

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.
Free downloadRead more
Power Tools for Google Sheets
1/4

Products

Ultimate Suite

70+ professional tools for Microsoft Excel
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.
Works for:   Windows
Read more Free download

Shared Email Templates

Custom email templates for teams and individuals
Do not waste your time on typing the same replies to repetitive emails. Compose your response just once, save it as a template and reuse whenever you want.
  • Quickly reply to emails with templates
  • Personalize your replies with macros
  • Attach files and images automatically
  • Use Outlook drafts as templates
  • Create beautiful email designs
  • Protect your privacy with encryption
  • Use on touch-enabled devices
  • Run on PC, Mac, Windows tablet
Works for:   Windows•macOS•Outlook Online
Read more

Mail Merge

Ideal for newsletters, proposals, and greetings addressed to your personal contacts
Mail Merge is a time-saving approach to organizing your personal email events. It offers:
  • Customizable and adaptive mail merge templates
  • Personalized merge fields depending on the recipient or context
  • Dynamic attachments and images
  • Mailing lists based on Excel tables
  • "Send immediately" and "send later" scheduling
Works for:   Windows•macOS•Outlook Online
Read more

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.

Add-in Express Regions for Outlook

Customize Outlook forms and folder views with advanced regions. Embed any custom .NET forms and use any built-in or third-party controls.

Text Toolkit for Excel

35+ handy options to make your text cells perfect
Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click.
  • Trim extra spaces
  • Convert text to numbers
  • Count characters and words
  • Change letter case
  • Extract text or numbers
  • Remove text by its position
  • Add the same text to selected cells
  • Split cells by symbol, string, or mask
  • Replace unwanted characters
  • Eliminate leading zeros
  • Clean non-printing characters
  • Swap text in your cells
Works for:   macOS•Excel Online
Read more

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.

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.

Advanced Find and Replace

Find data in values, formulas, notes, hyperlinks & errors. Replace each or all records at once, delete or export them to a new sheet.

Sheets Manager

Navigate between sheets easier and process multiple tabs at once: (un)lock, (un)hide, copy, move, color, reorder, rename, delete.

Table Styles

Apply one of 50+ professional styles to your Google Sheets tables as a whole or by parts. Or create your own custom styles.

Function by Color

Sum and count colored cells in the selected range based on the fill and/or font hues. Take colors into account in your own formulas: IF, COUNTIF(S), etc.

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.

See all add-ons for Google Sheets…

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.

I can't tell you how happy I am with Ablebits

I can't tell you how happy I am with Ablebits and the time it has saved me over the years. I started using Ablebits with my previous employer, probably 15 years ago and I constantly recommend your products to coworkers. You truly have top-notch customer service. Keep up the great work!

Jeff Meyer

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.

These companies choose Ablebits add-ins

New tips, releases and updates

Svetlana Cheusheva

Excel IFNA function to catch and handle #N/A errors

Getting a lot of #N/A errors in your worksheets and are curious to know if there is a way to replace them with a user-friendly message? IFNA formula is the solution you need. Continue reading

Svetlana Cheusheva

ISNA function in Excel with formula examples

When Excel cannot find what it is asked for, a #N/A! error appears in a cell. To intercept and handle such errors, you can use the ISNA function. Continue reading

Svetlana Cheusheva

How to change Excel CSV delimiter to comma or semicolon

Imagine this: you want to export your Excel data to another application. Whatever CSV option you use, the result is a semicolon-separated file instead of comma-separated you really wanted. The setting is default, and you have no idea how to change it. Continue reading

Svetlana Cheusheva

How to highlight active row and column in Excel

When viewing a large worksheet for a long time, you may eventually lose track of where your cursor is and which data you are looking at. To know exactly where you are at any moment, get Excel to automatically highlight the active row and column for you! Continue reading

Aksana Pachkouskaya

How to create dynamic Outlook email templates for the current user

Let's say, you have a really nice template, and your teammates would be happy to use it in their correspondence, but you're stuck on making this template dynamic. The problem is that each of your colleagues would like to get a different image, an individual attachment, and some specific text added to the template every time they use it. Continue reading

Svetlana Cheusheva

VLOOKUP to compare two columns in Excel for common values and missing data

When you have data in two different lists, you may often need to compare them to see what information is missing in one of the lists or what data is present in both. Comparison can be done in many different ways, which method to use depends on exactly what you want from it. Continue reading

Natalia Sharashova

Video: How to move multiple Google sheets to new, existing or several separate spreadsheets

Have you ever tried to move – cut & paste – Google sheets from one file to another? There's no such option available in spreadsheets. But it doesn't really matter if you have Sheets Manager at hand. It knows how to split your Google spreadsheet by tabs or simply move multiple tabs to a new or the existing file at once. Continue reading

Alexander Trifuntov

How to use and store custom functions in Excel

You will learn how to call custom functions from another workbook or add-in. Continue reading

Natalia Sharashova

Video: How to copy multiple Google sheets to the current, new, existing or several separate spreadsheets

In today's video, I'll show you why Sheets Manager is a better alternative when it comes to copying multiple Google sheets. You'll see the handiest way of duplicating several tabs and, what's more, learn how to copy them into multiple separate spreadsheets in one go. Continue reading

Svetlana Cheusheva

How to remove whitespace and empty lines in Excel with Regex

Whichever input data you are using, you'll hardly encounter a dataset without spaces. In most cases, whitespace is good. In some situations, however, it may become evil - extra spaces can mess up your formulas and make your worksheets almost unmanageable. Continue reading

Natalia Sharashova

Video: How to lock several Google sheets, copy them, hide/unhide, move, etc. with a special add-on

Though Google Sheets offers its ways to process multiple tabs, there's a faster and user-friendly solution I'd like to share – our Sheets Manager add-on. It even knows a few tricks you won't cover with standard tools. But please, don't take my word for it – come watch today's video to see for yourself. Continue reading

Check more related articles

Excel: featured articles

Outlook: featured articles

Google Sheets: featured articles

Ablebits.com on Facebook Ablebits Youtube channel
Copyright © 2003 - 2022 Office Data Apps sp. z o.o. All rights reserved.   Privacy policy   Terms of use   Contact us
Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Google Chrome is a trademark of Google LLC.