Merge Tables Wizard for Microsoft Excel - Match and merge two Excel spreadsheets in 5 quick steps
With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds.
The add-in is an easy-to-understand alternative to Microsoft Excel Lookup and Vlookup functions. It perfectly merges matching data from two tables whether they are located in the same or in two different Microsoft Excel files.
The intuitive and smart wizard provides a step-by-step guidance through the join process while additional capabilities and advanced options of the add-in ensure exactly the results Excel users need. Those who do a lot of data analysis in Excel will definitely appreciate the following capabilities of the Merge Tables Wizard:
- Ability to find and copy matching data in seconds.
- Auto-detecting all matching columns.
- Using one or several columns as matching criteria.
- Comparing Excel lists from different workbooks.
- Adding new columns to the main table or updating values in existing columns.
- Highlighting updated data in any color.
- Updating only empty cells so that the existing content won't get overwritten.
The add-in works in all versions of Microsoft Excel from 2003 to 2013 (32- and 64-bit).
Get started with a free download at http://ablebits.com/mergeexcel
What's New: FIXED: Data outside of Excel table were included in the selected range. IMPROVED: Excel color palette is used for picking new background color for the updated values.
Limitations: 15 Days Trial

Merge Tables Wizard for Microsoft Excel 3.1.6 is 100% clean
This download (merge-tables-excel.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. Ablebits.com Workbook Manager for Excel 2.0 - See all opened books & sheets in a tree view. Easily sort, insert, rename, copy
2. Fuzzy Duplicate Finder for Excel 4.1 - Find and remove partial duplicates, misprints and typos from Excel worksheets.
3. Random Sorter for Microsoft Excel 2.1.2 - Shuffle cells, rows or columns; randomly select a number or percentage of data
4. Ablebits.com Duplicate Remover for Excel 3.1.5 - Remove duplicates from Excel list, compare two worksheets for duplicates/uniques
5. Advanced Find & Replace for Excel 5.0 - Find and Replace in values, formulas and comments in all opened workbooks.
6. Merge Cells Wizard for Excel 4.1.15 - Merge Excel cells preserving all data, join by rows or columns.
7. Cells Assistant for Microsoft Excel 1.5.0.1 - An Excel tool that enriches the built-in Special Cells dialog.
8. AutoFormat for Excel PivotTables 2.0.3 - Create, store and apply your own formats for excel pivot tables
9. PivotTable Helper for Microsoft Excel 1.1.0.17 - It makes working with pivot tables comfortable and fast.
10. Style Manager for Microsoft Excel 2.0.5.105 - Create your unique collection of Excel styles quickly and easily.