Add-ins for Microsoft Excel
For Microsoft Excel 2013 (32- and 64-bit), 2010 (32- and 64-bit), 2007, 2003
The add-ins that you will find on this page are, in fact, an accumulation of our more than 11 years of experience with Microsoft Excel development. Excel on a daily basis and, frankly, we don't know how we would live without our Excel tools :)
Your task is:
Merge worksheets, cells, workbooks, duplicated rows
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 moreDownload
Consolidate multiple workbooks into one
With Consolidate Worksheets Wizard you can quickly combine multiple workbooks and worksheets into one. You can 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 moreDownload
Merge multiple cells into one and keep all data
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 moreDownload
Merge duplicate rows based on unique id
If your Excel table has rows of different information referring to the same record, Combine Rows 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 moreDownload
Remove duplicates, trim spaces, delete non-print characters
Remove Excel duplicates
With Duplicate Remover for Excel you can quickly find and remove duplicates or unique records from 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 location (worksheet or workbook). Duplicate Remover can easily handle up to 1 million rows in Excel 2010 - 2007.
Read moreDownload
Remove excess spaces, unwanted characters, change case and more
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 Cell Cleaner plug-in 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.
Read moreDownloadFind broken links, formulas, hyperlinks, similar records, etc.
Find and replace in all open Excel workbooks and worksheets
The Advanced Find and Replace add-in for Excel gives you simultaneous search in values, hyperlinks, formulas and comments in all opened or selected worksheets and workbooks .
You will have all search results displayed in a tree view and you'll be able to move between the search results easily, replacing values directly in the found items.
Read moreDownload
Find and fix broken links in Excel spreadsheets
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. You can easily track the links to other workbooks, edit the found entries or open the location of the linked files. Update the referenced path on the add-in pane and it will be replaced in all linking cells.
With this tool you can easily handle formula links to other Excel files to guarantee flawless master worksheets.
Read moreDownload
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 moreDownload
Find cells by value, date or type
With Select Special Cells you can easily find cells in your Excel worksheets based on value or date range, pick the min or max value in a range and select cells by font color or fill color. You can also select all empty cells, cells with errors or cells containing constants, comments, formulas etc.
Read moreDownloadGenerate random data
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. Random Generator works for Microsoft Excel 2010, 2007, 2003, 2002 (XP) and 2000.
Read moreDownload
Shuffle / sort randomly; select random sample of data
With Random Sorter for Excel you can easily shuffle individual cells in rows, columns or in the selected range, or randomly sort entire rows and columns.You can instantly get a random selection of your data 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. The add-in is embedded into your Excel worksheets as a task pane and works with Microsoft Excel 2000 - 2010 (32-bit and 64-bit).
Read moreDownloadManage workbooks, worksheets, tables, comments
Easily sort, drag, rename 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, delete, and resort them.
The plugin works like Excel Task pane so that you can work with your Excel workbook and see all the necessary data in the left part of the screen.
Read moreDownload
10 one-click tools to move columns, delete blanks 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 moreDownload
Create, edit, and view comments
Comments Manager for Excel add-in 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 moreDownloadSplit data
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 moreDownload
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 moreDownload
Extract data from selected rows, convert rows to columns
Extract Data for Excel will help you to extract the selected rows and convert them to columns. You can choose to extract entire rows or selected columns only. You can extract each row to an individual worksheet or all rows to one worksheet and group the extracted data by a specified column. With this tool you can easily change the way your Excel data is laid out, make it easy to print, review or analyze.
Read moreDownloadConvert measurement units, fill empty cells
Convert measurement units
Measurement Units Converter performs various conversions between more than 200 measurement units in 18 different categories such as area, distance, fuel consumption, mass, temperature, time, volume etc. The add-in can be used either as a pane in your worksheets or Quick Converter residing on the Excel Ribbon. No matter how many values you want to convert: one unit, a few columns or the entire table, you need just 1 click and a few seconds to get the result.
Read moreDownload
Fill empty cells with the value of above or below cell
Fill Blank Cells for Excel is a helpful add-in that automatically fills blank cells in your table using values above or below the empty range. It can be especially useful if your spreadsheet has hundreds of rows with missing data, and copying the items manually would take you a really long time.
With this handy application you can copy the contents from the first filled cell downwards or upwards the blank, fill all blank ranges in different columns of your table at once and take the advantage of the Split the merged cells option.
Read moreDownloadFree Excel add-ins
Trim Spaces for Microsoft Excel
This free add-in for Microsoft Excel will eliminate all leading and trailing excess spaces from your worksheets.
Read moreDownload
Show Entire Row for Excel
Show Entire Row for excel displays a row of any length on the add-in pane. It lets you easily edit the values of the row and navigate within a wide data table. Instantly switch to the next or previous row.
Read moreDownload
Note&Do for Microsoft Excel, Outlook, PowerPoint and Word
This add-in for Excel, Outlook, PowerPoint and Word lets you quickly take notes and plan application-specific tasks. Switch to its Notes tab and share some messages in different documents, use the To Do tab and plan your work using tasks that you can categorize with color, complete and keep track of.
Read moreDownload
