Merge Tables Wizard for Microsoft Excel

CNET Editors' review

by: CNET staff on June 17, 2010

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

GoToMeeting®

High-Definition Group Video Conferencing – Try it Free Today

Download Now

Publisher's Description

From Add-in Express:

Merge Tables Wizard for Microsoft Excel is a handy add-in where you can easily lookup and copy matching data from one Excel table to another. Two tables can be located in the same or two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process fast and easy. You can use one or several columns as matching criteria, add new columns to the main table or update data in existing columns. The adding works for Excel 2007, 2003, 2002, 2000.