Add-ins for Microsoft Excel
Free downloads for Excel 2016 (32- and 64-bit), 2013, 2010, 2007, 2003; desktop version of Office 365
The add-ins that you will find on this page are, in fact, an accumulation of our more than 15 years of experience with Microsoft Excel development. We use Excel on a daily basis and, frankly, we don't know how we would live without our Excel tools :). Free download is available for all add-ins.
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.
Free downloadRead more
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.
Free downloadRead more
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.
Free downloadRead more
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.
Free downloadRead moreRemove 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.
Free downloadRead more
Trim excess spaces, add text, 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. In addition you can remove characters by position, clear formatting, add text and split cells in your Excel table.
Free downloadRead moreCalculate values based on cell color
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.
Free downloadRead moreFind 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.
Free downloadRead more
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.
Free downloadRead 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.
Free downloadRead more
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.
Free downloadRead moreGenerate 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.
Free downloadRead more
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 2003 - 2016 (32-bit and 64-bit).
Free downloadRead moreManage 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.
Free downloadRead more
Instantly insert watermark in Excel
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. 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.
Free downloadRead more
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.
Free downloadRead more
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.
Free downloadRead moreTransform and split data
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.
Free downloadRead more
Swap two ranges
Swap Ranges for Excel switches the contents of two ranges. Swap columns, rows, cells and adjust, keep cell references or paste values only. Easily switch data between 2 workbooks.
Free downloadRead more
Flip table vertically or horizontally
Flip Range for Excel reverses data in the specified range vertically or horizontally. Reorder your data and keep cell references unchanged, adjust them or flip and paste values only.
Free downloadRead more
Convert a crosstab table to list
Unpivot Table transforms your crosstab (two-dimensional) table to a flat list. You can choose to separate data parts by an empty row and paste the results to a new worksheet or workbook.
Free downloadRead 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.
Free downloadRead 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.
Free downloadRead 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.
Free downloadRead moreFill empty cells
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.
Free downloadRead moreSpreadsheet auditing
ExcelAnalyzer
ExcelAnalyzer scans spreadsheets for formulas, functions, VBA, references and potential errors, and displays them using colors and intuitive interface. With a great accuracy it identifies input cells, cross-book precedents and dependents, shows hidden, protected, empty sheets and many more. It generates powerful-yet-clear summary reports to display your spreadsheet information and highlight possible errors in a visual straightforward way. Try this effective solution to eliminate arduous manual work and save time when checking an Excel spreadsheet.
Free downloadRead moreFree 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.
Free downloadRead more
Smart Toolbar for Microsoft Excel
Smart Toolbar saves screen space in Excel by collapsing the Ribbon and giving you one-click access to the most popular options.
Free downloadRead more
Select by Value & Color for Microsoft Excel
Select by Value & Color for Excel is a simple-yet-helpful tool that highlights all cells with the same value or background color.
Free downloadRead more
SQL Server for Microsoft Excel
With SQL Server for Excel you can easily view, edit and update records in a Microsoft SQL Server database table without using SQL Scripts or SQL Server Management studio.
Free downloadRead more
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.
Free downloadRead more
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.
Free downloadRead more
No comments:
Post a Comment