Join or Sign In

Sign in to add and modify your software

Sign in with Facebook Sign in with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Agreement.

Merge Tables Wizard for Microsoft Excel

By Add-in Express Free to try Editors' Rating

Editors' Review

Download.com Staff Jun 15, 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.

Full Specifications

What's new in version 3.1.4

Version 3.1.4:
  • 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.

General

Release July 9, 2013
Date Added July 8, 2013
Version 3.1.4

Operating Systems

Operating Systems Windows 2003, Windows 2000, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP
Additional Requirements Microsoft Excel 2013 (32- and 64-bit), 2010 (32- and 64-bit), 2007, 2003

Popularity

Total Downloads 7,159
Downloads Last Week 1
Report Software

Related Software

X-Mouse Button Control

Free
X-Mouse Button Control

Screenshot Captor

Free
Screenshot Captor

My Screen Capture

Free
My Screen Capture

APK Installer and Launcher

Free
APK Installer and Launcher

Best VPN Services for 2021

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan

Developer's Description

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.