Excel can be a very useful tool for managing large quantities of information, but it's not always easy to combine data from different tables in a meaningful way. Merge Tables Wizard for Microsoft Excel is a handy add-on that automates the merging process, making it easy for even novice Excel users to merge tables like pros.
The program installs easily and appears as its own easy-to-find tab in the Excel menu. The program is designed to work as a wizard, guiding users through each step of the set-up process. Users simply select the relevant cells in the master table and look-up table, select the matching columns, choose the columns that will be updated, and then tweak a few additional options. The wizard itself is fairly self-explanatory, but the program's built-in Help file uses plenty of screenshots to explain the program's features. (In fact, this Help file deserves special praise for being brief but clearly written, something we'd love to see more often.) We liked that the program can handle tables that that are located in the same or different Excel files, and that merged data can be added to existing columns or new ones. Overall, we found the program to be well-designed and flexible, and we think it's a great choice for users who need to merge data between Excel tables.
Merge Tables Wizard for Microsoft Excel has a 15-day trial period. It installs and uninstalls without issues. We recommend this program to all users.
Editors' note: This is a review of the full version of Merge Tables Wizard for Microsoft Excel 18.104.22.1680. The trial version is limited to 15 days trial only.
From Add-in Express:
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.
What's new in this version:
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.