Solve 300+ daily tasks in Excel

Ablebits Ultimate Suite

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! Whatever task you are faced with, you'll find the tool to accomplish it quickly and flawlessly.
A set of 70+ time-saving tools for Excel

Smart way to handle routine emails

Shared Email Templates for Outlook

Using your own bank of fully customizable adaptive templates, you can create a professional looking email response in no time. Use your templates individually or share with your colleagues, access from any device and all your Microsoft accounts and without limits. Personalize repetitive emails to the fullest extent possible and enjoy an improved engagement rate!
Shared Email Templates for Outlook on Windows, Mac and Outlook on the web

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

Shared Email Templates

Easy customizable adaptive 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 repetitive emails
  • Share your templates with colleagues
  • Personalize your replies with macros
  • Attach files and images automatically
  • Create dynamic templates with fillable fields
  • Create gorgeous html-based designs
  • Send out personalized bulk mailings
  • Set up company and team wide signatures
  • Run on PC, Mac, Windows tablet
  • Protect your privacy with encryption
Works for:   WindowsmacOSOutlook Online

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:   WindowsmacOSOutlook Online

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
  • Find, extract, replace, and remove strings by means of regular expressions
  • Merge columns, rows, or cells into one
  • Combine rows by duplicates
Works for:   macOSExcel Online

Add-ons for Google Sheets

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.

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.

These companies choose Ablebits add-ins

New blog posts

Excel IF statement between two numbers or dates

To check if a given value is between two numbers, you can use the AND function with two logical tests. To return your own values when both expressions evaluate to TRUE, nest AND inside the IF function. Detailed examples follow below.