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

Merge and consolidate multiple workbooks

Combine Worksheets Toolkit is your all-in-one solution to merge and consolidate data in Excel. It can quickly bring worksheets from different workbooks together without even opening all of them, merge data from multiple sheets into one, combine worksheets by column headers, and consolidate data for your summary reports.

Read more

Combine duplicate rows by key columns

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 data from different worksheets

Consolidate Worksheets Wizard offers a user-friendly way to join worksheets together and summarize their data. You can choose to consolidate by column and row labels separately or calculate numbers at the intersection, or by position in the sheet. All Excel consolidate functions are at your disposal, so you can sum, count, find the maximum, minimum, or average value in three simple steps.

Read more
Merge multiple Excel files into one

Merge multiple Excel files into one

The Copy Sheets tool provides 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 multiple Excel files into one

Combine worksheets by column headers

Use the Combine Sheets Wizard to merge data from multiple spreadsheets into a single sheet based on column headers. You can choose what columns to copy, and decide whether you want to keep the original formulas, copy the calculated values, or link the combined datasets to their sources.

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
Compare two worksheets for differences

Compare two worksheets for differences

With Compare Sheets you can quickly find and highlight differences between two Excel worksheets or lists. The add-in detects differences in values, formulas, formatting and marks them with fill, font, or border color. Once the differences are found, your worksheets are placed side by side for you to comfortably review and merge the differences.

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

Calculate ranges

Our Calculation tools allows you to apply the same math operation to all numbers in the selected range: 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
Copy cell addresses as references

Copy cell addresses as references

Use the Copy Address utility whenever you need to get a cell or range address as a reference. If you want to refer to a cell from another workbook, get its address as an external reference. In case you'd like to "fix" a reference to a specific cell, copy its address as absolute or external absolute. Need to insert a reference in a formula? Click Paste! Yep, it's that easy.

Read more
Convert formulas to values

Convert formulas to values

Convert Formulas is specially designed to makes your work with Excel formulas easier and more comfortable. It allows you to toggle between relative and absolute cell references in a click. And if your worksheet has started to recalculate slowly because of many complex formulas, replace all formulas with calculated values in one go.

Read more


Ultimate Suite 2018.3 Summer Offer
 
 
Excel add-ins and Outlook tools - Ablebits.com