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.
| Download Now | Feature Tour | See how it works |
|
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 beTo 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:
|
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.
Thank you so much for making this add-in for Excel. It does exactly what you say it should do, on my 10,250 item database. Awesome! Nannette DiMascio, Broker / Associate, Realty One Group
Additional options provided by the Merge Tables Wizard let you adjust the merge results depending on your particular data and needs.
Thank you for the great product, it truly opened whole new possibilities for me in combining and analysing data from different sources. Laisan Shafikova
Need to merge Excel cells?
If you want to merge cells in Excel, check out Merge Cells Wizard. With this add-in you can combine multiple cells, join entire rows, columns or a range of cells retaining their values.
See 5 steps to find and merge matching data in Excel tables
Check out the recent posts from the AbleBits blog in which Excel users share their experience with Merge Tables Wizard:
Click Like and get 15% discount on all our products right now!

You can purchase a license of Merge Tables Wizard for Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.
You can buy this add-in as part of the AbleBits Add-in Collection for Excel (11 add-ins in 1 package) and save 60% off.
Quantity | USD | EUR | GBP | Volume discount |
1 | 49.95 | 34.95 | 29.95 | |
2-4 | 47.45 | 33.20 | 28.45 | 5% |
5-9 | 44.96 | 31.46 | 26.96 | 10% |
10-24 | 39.96 | 27.96 | 23.96 | 20% |
25-49 | 34.97 | 24.47 | 20.97 | 30% |
50 & more | ||||
If you are not happy with our product for any reason,
you will get your money back, no questions asked.