Manage updates with the Download AppCNET Editors' review
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.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.
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.
More Products to Consider
-
Join multiple data from selected Excel cells.DownloadInstalled
Smart Install -
Make your Excel works easier and faster with over 300 extra too...DownloadInstalled
Smart Install -
Take an open-source approach to office productivity.DownloadInstalled
Smart Install -
Convert Adobe PDF file to MS Word file format.DownloadInstalled
Smart Install -
View, navigate, and print PDF files.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Open, edit, and save files using the new file formats in 2007 v...DownloadInstalled
Smart Install -
Create and share content with the help of a comprehensive set o...Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Convert PDF files to Microsoft Word format.DownloadInstalled
Smart Install -
Keep track of how you use your PC.DownloadInstalled
Smart Install -
Integrate Barcode into the Microsoft Office applications.DownloadInstalled
Smart Install -
Browse, edit, and create data in with this MySQL client.DownloadInstalled
Smart Install -
Create, view, edit and share word, spreadsheet and presentation...DownloadInstalled
Smart Install -
Browse, edit, and create data in with this MySQL client.DownloadInstalled
Smart Install -
Remove duplicates from a list, compare two lists for duplicates...DownloadInstalled
Smart Install -
Create, manage, and collaborate with others on presentations.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Create letters, envelopes, and labels, and send faxes.DownloadInstalled
Smart Install -
Develop your own custom solutions visualizing various data.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install - Access and interact with multiple databases.Download
Installed
Smart Install -
Use this full-featured text editor to create and store document...DownloadInstalled
Smart Install -
Manage personal finances via MS Excel spreadsheet.DownloadInstalled
Smart Install -
Create barcodes of many different types.DownloadInstalled
Smart Install -
Allow information workers to communicate in real time.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Convert JPG, BMP, TIFF, PNG images to PDF files.DownloadInstalled
Smart Install -
Create and manage databases with graphical interface.DownloadInstalled
Smart Install
