Lookup and merge Excel spreadsheets by matching data

Merge Tables Wizard for Microsoft^® Excel^®

Merging Excel worksheets by matching data with Merge Tables wizard

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Merge Tables Wizard for Microsoft Excel is an easy-to-understand and comfortable-to-use alternative to Microsoft Excel Lookup and Vlookup functions. This cute add-in, which was specially designed for combining data from different sources, finds and merges matching data from two Excel tables in seconds.

Merge Excel spreadsheets perfectly without copying and pasting!

Just imagine this: you have two or more Microsoft Excel worksheets containing information about your company's products. For example, you have 2 Microsoft Excel tables (lists) - "Orders" and "Prices" and they both have a column with the "Product ID". You want to update prices and add product descriptions from the Second table (let's call it a lookup table) to your Main table (master table). If you try to do this painstaking and wearisome work manually, it will take you hours, if not days! You will have to go through each row in the master table to identify the matching row in the second spreadsheet. After that you will spend even more time on updating the selected rows and adding a new column from the lookup table to the main list. Does all this sound too complicated and time consuming? Probably yes, even if you decide to employ the standard Microsoft Excel Match, Lookup, or Vlookup. But definitely not, if you use our Merge Tables Wizard for Microsoft Excel. This handy add-in quickly merges two Excel worksheets into one by copying matching data from the specified columns. The two tables can be located in the same Microsoft Excel file or in two different files. The intuitive and smart wizard guides you through the merge process. Rows from two Excel spreadsheets with different number of columns will be matched perfectly without copying and pasting! Merge results are exactly as you expect them to be To ensure that you get exactly the results you need, the Merge Tables Wizard provides a number of options. You can select which columns you want to update or add to your Master Table by choosing one of the actions: Update. The data will be copied from the Lookup table and pasted into the corresponding column of the Master table. Add to the end. The new column will be added to the Master table. You can also choose to Add non-matching rows to the end of the table. It means that rows that appear only in the Lookup table will be copied to the end of the Master table underneath all other rows.

Combine data from two tables Merge Tables Wizard Choose which columns to update Two tables are merged perfectly

Now, let's look at the resulting table from our example, see the screenshot above. Prices were updated by assigning the Update values action to the "Prices" column and the "Product Description" column was added by choosing Add to the end for this column.

Use additional options to fine-tune the merge results

Additional options provided by the Merge Tables Wizard let you adjust the merge results depending on your particular data and needs.

Additional options

• You can update only empty cells in your Master table. Check this option if you don't want to overwrite existing values in your main table.
• Update the Master table value only if the corresponding cell from the Lookup table contains data. Check this option, if you want to ignore empty cells in the Lookup table.
• Ignoring extra spaces in matching columns will ensure the most accurate results. When you import data in Microsoft Excel from external data sources, it often comes with some extra spaces that are of course invisible for a human eye. If you select this option, the Merge Tables Wizard will ignore excess spaces and you will never be bemused by the question why those rows were not merged while their matching columns look exactly the same!
• You can choose to add a Status column that reflects all the changes made to your master table, allowing you to filter only updated rows, non-updated rows, or new rows for your further analysis.
• And finally, you can color updated cells in order to see all the changes at a glance.

In summary, with Merge Tables Wizard for Excel you can:

• Find and merge data from 2 Excel spreadsheets by following 5 easy steps of the Wizard.
• Use one or several columns as the matching criteria.
• Compare Excel lists from different workbooks.
• Add new columns to the main table or update data in existing columns.
• Add non-matching rows to the end of the table after all other data.
• Color updated rows; a variety of different colors are available.
• Ignore extra spaces in matching columns.
• Update only empty cells in your Master Table if you don't want to overwrite the existing values.
• Update only if cells from Lookup Table contain data.
• Add a Status column to the Master table that will reflect the changes and mark rows as: "Updated", "Non-updated", "New row".
• 100% support of Microsoft Excel 2007 and 2010 (32-bit, 64-bit): Ribbon interface, 1,000,000 rows and so on.

How Merge Tables Wizard works

See 5 steps to find and merge matching data in Excel tables

First-hand experience of Merge Tables Wizard users

Check out the recent posts from the AbleBits blog in which Excel users share their experience with Merge Tables Wizard:

• How Merge Table Wizard saves countless hours for educators by Emily Kern
• Excel Merge Wizard: time saving magic by The WebMarketing Group
• Merging data in Excel: creating spreadsheets from data housed in multiple locations by Tiffeny Wilkinson

Download now and see how it can help you