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 22.214.171.1240. The trial version is limited to 15 days trial only.