Add-ins for Microsoft Excel

Free downloads for Excel 2016 - 2007

This collection of 60+ smart tools will automate most of your daily tasks in Excel and increase your productivity at least by 50%! It's 15 years of experience with Office development embodied in the perfect code of solutions that work flawlessly on all Excel versions and all datasets.

Read moreFree download

Merge worksheets, cells, workbooks, duplicated rows

Merge two Excel worksheets

Merge two Excel worksheets

Merge Tables Wizard finds and merges two Excel tables into one by matching the values in the corresponding columns. These two tables can be located in the same Excel file or in two different Excel files. The intuitive and user-friendly interface of the wizard makes the join process fast and easy.

Read more

Combine duplicate rows based on unique id

If your Excel table has rows of different information referring to the same record, Merge Duplicates Wizard lets you combine all duplicate rows into one without losing any data. Choose key columns, select columns with the values to merge and see all details for the record lined up on the same row.

Read more

Consolidate multiple workbooks into one

With Consolidate Worksheets Wizard you can quickly combine multiple workbooks and worksheets into one. You can choose from a number of options to consolidate your Excel data. You can merge worksheets from different workbooks into one Excel file; combine data from several Excel workbooks and csv files without opening them; consolidate worksheets by name; create summary reports, and more.

Read more
Merge multiple Excel files into one

Merge multiple Excel files into one

The Copy Sheets tool offers four different ways to merge Excel sheets: copy all worksheets from a given workbook into one sheet, combine data from identically named sheets into one, copy sheets from several workbooks into one file, and merge data from the selected worksheets into one sheet.

Read more

Merge cells, columns, and rows

Merge Cells Wizard for Excel merges, or joins, values from different cells. Use Merge Cells Wizard every time you need to place values from several cells to one cell, or when you need to join several cells and retain their values.

Read more
Vlookup and pull matching data

Build Vlookup formulas

Excel Vlookup Wizard offers a quick and easy way to build Vlookup and Index/Match formulas based on your criteria. You specify the key column to search for, the column to look up against and the column to retrieve the values from, and get a formula best suited for your dataset.

Read more

Remove duplicates and find uniques

All-in-one toolkit to deduplicate Excel sheets

With Duplicate Remover Toolkit for Excel you can quickly find and remove duplicates or unique records in your Excel sheets. Search for duplicates in one table or compare two lists with different number of columns, choose any columns for comparison. Delete duplicate rows from any range, select, color them or add a status column, copy or move them to another worksheet or workbook.

Read more

Find and remove duplicates in one table

Duplicate Remover Wizard is a multi-purpose tool that can find repeated and unique entries in one Excel worksheet. It can search for the following data types: duplicates except their first occurrences, duplicates including their first instances, unique values only, or all different values in the list (uniques and first occurrences of duplicates).

Read more

Compare two tables for matches and differences

Compare Tables is the tool you use for finding matches (dupes) and differences (uniques) between two Excel columns, lists, or tables. 5 intuitive steps, selecting one or multiple columns for comparison, and a variety of ways to deal with the found items: remove, highlight with color, identify in a status column, copy or move.

Read more

Deduplicate Excel lists on the fly

Quick Dedupe comes in handy when you want to swiftly search for duplicates in one list. All you have to do is select the columns to check for dupes and choose what you want to do with them: remove, highlight, copy or move somewhere else. Deduplicating Excel sheets has never been easier!

Read more

Find fuzzy matches (similar records)

With Fuzzy Duplicate Finder for Excel you can easily find and correct all sorts of partial duplicates, typos and misspelled words in your worksheets. The add-in performs a fast search for duplicates that differ in 1 to 10 characters and recognizes omitted, excess or mistyped symbols. You can correct misprints automatically or manually directly in search results, split cell data into words and process them separately.

Read more

Text tools: trim spaces, change case and more

Text Toolkit

Numbers stored as text, excess spaces and line breaks or words written in a wrong case, - you may not notice them until you need to process your data in Excel further. The Text Toolkit automates such tasks as removing spaces between, before and after cell values, deleting and replacing line breaks, wiping non-printing or custom characters, converting numbers stored as text to number format and changing Excel text case. In addition you can remove characters by position, clear formatting, add text and split cells in your Excel table.

Read more

Split names from one cell into several cells

The Split Names add-in for Microsoft Excel does exactly what its name suggests, i.e. splits names into individual cells. If you have a spreadsheet with numerous differently formatted names in the same column, the Split Names add-in will quickly clean up the mess and separate name parts into several columns. It recognizes First names, Middle names, Last names, and over 100 salutations, name suffixes and post-nominal letters.

Read more

Manage workbooks, worksheets and tables

Manage workbooks, worksheets and tables

Move, find and sort Excel worksheets

Workbook Manager organizes all opened spreadsheets in a catalogue so that you can easily navigate through your Excel workbooks, drag worksheets throughout workbooks, insert, rename and delete them. Alphabetize your Excel spreadsheets A to Z or vice versa and quickly find the needed sheet among other Excel files.

Read more
Column Manager for Excel

Manage columns an easy way

Use Column Manager for Excel to get a list of all columns to comfortably manipulate them. Move columns in your worksheets by dragging them on the add-in pane, insert new columns and delete old ones, autofit column width in a click.

Read more

Insert watermark in Excel

Watermark for Excel allows storing custom text and picture watermarks and inserting them in one click. In addition it lets you rename, remove watermarks, and preview the result on the pane before adding to the file. If you struggle to add a watermark in your Excel worksheets each time you need to print out a document or give it a status, this tool will be your trusted assistant.

Read more
Table of Contents

Create table of contents

Use the TOC tool to create a table of contents with links to all sheets in a workbook. All you have to do is select the top cell of the destination range and click on the add-in's icon.

Read more

Work with dates & times

Date & Time formula wizard

Date & Time formula wizard

Using Date & Time formula wizard you can do all sorts of date & time calculations in Excel: add and subtract dates, calculate the difference between two dates, and get a person's age from the date of birth.

Read more
Date Picker for Excel

Date Picker

Date Picker for Excel provides a quick way to insert a date in a cell by selecting it from the drop-down calendar. Additionally, it shows how far out the selected date is from today's date and allows you to add and subtract years, months, weeks, and days to the selected date.

Read more

Transform, split, fill blanks

Convert a crosstab table to list

Unpivot Table transforms your crosstab (two-dimensional) table to a flat list so that you can add new information, improve the table's layout, or rearrange your data for printing. You can choose to separate data parts by an empty row and paste the results to a new worksheet or workbook.

Read more

Easily make and print address cards in Excel

Create Cards turns your data table into label cards with names, addresses and other details for further processing. Choose the number of columns to place the results, separate data parts by a blank row or column, keep the formatting of your original spreadsheet.

Read more

Split worksheet into several tables by column

Split Table Wizard easily separates an Excel worksheet into several tables by selected column values. You can have the split tables inserted into the current or new workbook, or have each one pasted into a separate file.

Read more

Convert rows to columns and vice versa

Transpose Range for Excel is a helpful add-in that easily converts rows to columns and columns to rows in your worksheet. Employ this tool to transform your data and paste values only, values and formulas or create links to source data.

Read more

Swap two ranges

Swap Ranges for Excel switches the contents of two ranges with a mouse click. You can swap columns, rows, cells and adjust cell references in formulas or paste values only. Though your tables will be re-arranged, the original data formatting will be preserved, and all of your formulas will keep working properly.

Read more

Flip table vertically or horizontally

Flip Range for Excel reverses data in the specified range vertically or horizontally. Instead of writing different VBA codes to flip your tables upside down or from left to right, reorder your data in a single click and keep cell references unchanged, adjust them or flip and paste values only.

Read more

Remove blanks in Excel

Delete Blanks is a fast and safe way to delete empty rows, columns, and sheets in Excel. The tool deletes only those rows or columns that are completely blank, so not a single bit of your information will be lost. The add-in can also remove all blank sheets you no longer need.

Read more

Fill empty cells with the value of above or below cell

Fill Blank Cells for Excel add-in automatically populates blank cells in your table with the values above or below. You can quickly can copy the contents from the first filled cell downwards or upwards, filling all blanks in different columns at once. The tool can be especially useful if your spreadsheet has hundreds of rows with missing data.

Read more

Find and replace in all open Excel workbooks and worksheets

Advanced Find and Replace for Excel gives you simultaneous search in values, hyperlinks, formulas and comments in all opened or selected worksheets and workbooks. With all search results comfortably displayed in a tree view, you'll be able to navigate easily, replacing values directly in the found items.

Read more

Select cells by color, value or data type

Select by Value & Color is a simple-yet-helpful tool that allow you to find and highlight cells based on your condition: by color, value or data type. It can find cells with the same data, font or background color; get cells with comments, formulas, pictures; conditionally formatted cells, and more.

Read more
Column Manager for Excel

Filter based on cell value

Our custom Filter provides two exiting features that Excel's build-in auto filter lacks – filtering a column based on a cell value and filtering by multiple values. Instead of looking for the desired criteria in the long list, use this Filter tool for a quick review.

Read more

Find broken links

Find Broken Links for Excel is a smart tool that checks if links to other Excel files in your current worksheet are valid. The found links are displayed on the add-in pane in a convenient tree view. Update the referenced path on the add-in pane and it will be replaced in all linking cells.

Read more

Sum and count cells

Count characters and words in a cell

Count and sum cells by background or font color

Sum and Count by Color calculates data in your table based on their fill or font color. It allows pasting the summary with the results to any location on your sheet, recalculating data as soon as you highlight a new group of cells and applying Average, Max or Min functions to the range.

Read more
Count characters and words in a cell

Count characters and words in a cell

The Count Characters tool comes in handy in situations when you need to tally up all characters or words in selected cells or get the number of specific letters. The result can be output as a static value or reusable formula.

Read more
Perform basic math operations

Perform basic math operations

The Calculation tools enable you to do all basic mathematic calculations in a mouse click: multiply and divide, add and subtract, calculate percentages. All you have to do is select a desired operator and click the Calculate button. Additionally, you can apply one of the recent calculation to all selected cells at a time.

Read more

Generate random numbers, passwords, strings, dates

Use Random Generator to fill the Excel range with unique random numbers, integers, real numbers, dates or strings in just one click. The add-in can also produce random passwords with different character sets, random strings of any length and pattern. Apart from that it can randomly select values from Excel custom lists, or your own lists and create worksheets from custom lists' values.

Read more

Sort and select randomly

Use the Shuffle Cells feature every time you need to randomize cells in individual rows and columns, or re-sort all cells in a selected range, or shuffle entire rows and columns.

The Select Randomly option enables you to instantly get a random selection by specifying the needed percentage or exact number of entries: e.g. you can pick 10% of rows, or 5 columns, or 3% of cells from the selected range.

Read more

Time-saving utilities

Insert multiple pictures at once

Insert Pictures tool takes multiple images that you select and fits them perfectly into individual cells. You decide whether to insert images into a column or row and tell the add-in what size they should be: pictures adjusted to cells, cells resized to accommodate images, or some specific size that you set.

Read more

Create, edit, and view comments

Comments Manager for Excel makes working with the cell comments in your worksheets a breath. It conveniently displays all comments in a tree-view and lets you comfortably navigate to them in your table. You can edit, delete, copy or export comments to a new workbook, add pictures as comments, convert cells' contents into comments and vice versa.

Read more

Rearrange columns, delete empty rows, sheets and more

Ablebits Quick Tools is a handy 10-piece solution for Microsoft Excel that makes some time-consuming routine tasks easy and fun. Change columns order in your table and filter your records by the selected value, remove empty rows, columns and worksheets, calculate numerical data, work with external and absolute reference addresses.

Read more


Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com