FileCart

Merge Tables Wizard for Microsoft Excel 3.1.4

This smart add-in can match and merge two worksheets in Excel 2013-2003 in seconds. You can use one or several columns as the unique identifier, update existing columns in the master worksheet or add new from the lookup table.

afalina Windows Updated Dec 14, 2013
Download 14.81 MB · merge-tables-excel.zip
1.2Kdownloads
0this week
$49.95Shareware
0reviews

Screenshots

Merge Tables Wizard for Microsoft Excel 3.1.4 screenshot

About Merge Tables Wizard for Microsoft Excel

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.

The add-in works in all versions of Microsoft Excel from 2003 to 2013 (32- and 64-bit).
Get started with a free download at [link removed]
Requirements Microsoft Excel 2013 (32- and 64-bit), 2010 (32- and 64-bit), 2007, 2003
Release info Major Update on Jun 26, 2013
Release notes 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.
Related tags excel lookup marge table list

Reviews

No reviews yet. Be the first to review Merge Tables Wizard for Microsoft Excel.

Used Merge Tables Wizard for Microsoft Excel? Tell other visitors what you thought.

Log in to write a review

Other products by this publisher

  • Add-in Express 2007 for VSTO 2008.4.0 Easily develop professional extensions for Microsoft Office. Build Office add-ins with minimal coding and debugging, customize Office 2007 Ribbon UI and Office 2003 toolbars with special visual designers in your VSTO 2005 (SE) and VSTO 2008 projects.
  • Add-in Express 2008 for Outlook Express 2008 Visual RAD toolkit for developing secure, managed, isolated, version-neutral plugins for Outlook Express and Windows Mail. Extend the Outlook Express GUI, create toolbars and menus, add custom menu items and controls, embed forms into OE windows.
  • Add-in Express for Internet Explorer 2010 All-in-one framework that provides a simple and quick way to customize Internet Explorer with your own browser extensions. You can extend the IE 6, 7 and 8 (32- and 64-bit) with menu items, toolbar buttons, context menus, toolbars and side-bars.
  • Add-in Express for Office and .NET 2010 All-in-one platform for developing any types of Office extensibility projects with minimal coding. Use visual designers to create powerful plug-ins for MS Office 2010 - 2000, smart tags, RTD servers and Excel UDFs in C#, VB.NET, C++ and Delphi Prism.
  • Add-in Express for Office and VCL 2010.6 A true RAD tool for writing COM Add-ins, Smart Tags and RTD servers in Delphi 5 - 2010. You write the code once and your extension works in all Office versions from 2000 to 2010 (32-bit). Supports Outlook, Excel, Word, PowerPoint, FrontPage, etc.

Most viewed Windows Spreadsheets

  1. 1 LAselect 2.0 Unclutter Your Spreadsheets But Keep On Sorting! Excel's sorter is too limited for the things people use spreadsheets for. Forcing them to clutter the sheet. LAselect moves the sorting process completely away from sheet to VBA. 20K
  2. 2 Excel Join Multiple Cells Into One Software 7.0 Merge data that spans over multiple rows into one row or multiple columns into one column in MS Excel. Separating character(s), such as comma, space or comma-space, can be added. Excel 2000 or higher required. 19K
  3. 3 MITCalc 1.73 MITCalc is a multi-language calculation package includes solutions for gearing, belt, springs, beam, shaft, tolerances and many others. MITCalc support 2D and 3D CAD systems, Imperial and Metric units and many international standards ANSI, ISO, EN... 17K
  4. 4 DoneEx XCell Compiler 2.6 Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; https://DoneEx.com 17K
  5. 5 CDBF - DBF Viewer and Editor 2.45 A powerful database viewer and editor that allows home and business users to access databases directly using the familiar Windows interface. No programming skills needed! CDBF offers everything you need for working with databases. 15K
  6. 6 ABA Spreadsheet Convert 2.63 ABA Spreadsheet Convert allow to save the workbooks from directory into another formats. Supported the most popular workbook formats including MS Excel, Lotus 1-2-3, Quattro Pro, Open Office. 14K
  7. 7 Pop-up Excel Calendar 1.77 Pop-up Excel Calendar shows you a date picker when you activate a date cell in Excel, so that you can pick or select date value from the calendar by clicking mouse, instead of typing in manually, thus saving time and avoiding format mistakes. 13K
  8. 8 ExcelPipe Find and Replace for Excel 7.6 Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant 12K
  9. 9 Excel Compare 3.0 Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Excel Compare saves time by eliminating the file comparison routine, and improves comparison precision by telling you exactly what and where has been changed. 12K
  10. 10 AnalyzerXL Package 6.1.39 Trading and stock quotes downloading software for Microsoft Excel. Library of 165 technical analysis functions, historical and real time quotes downloaders, portfolio tracker. 11K

Most downloaded Windows Spreadsheets

  1. 1 MITCalc 1.73 MITCalc is a multi-language calculation package includes solutions for gearing, belt, springs, beam, shaft, tolerances and many others. MITCalc support 2D and 3D CAD systems, Imperial and Metric units and many international standards ANSI, ISO, EN... 2.2K
  2. 2 CDBF - DBF Viewer and Editor 2.45 A powerful database viewer and editor that allows home and business users to access databases directly using the familiar Windows interface. No programming skills needed! CDBF offers everything you need for working with databases. 1.9K
  3. 3 ABA Spreadsheet Convert 2.63 ABA Spreadsheet Convert allow to save the workbooks from directory into another formats. Supported the most popular workbook formats including MS Excel, Lotus 1-2-3, Quattro Pro, Open Office. 1.9K
  4. 4 DoneEx XCell Compiler 2.6 Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; https://DoneEx.com 1.8K
  5. 5 CDBF for DOS 2.99 CDBF for DOS is a powerful database viewer and editor that lets individuals and business users access databases directly without programming via the text interface. The program can repair corrupt database file headers. 1.5K
  6. 6 Pop-up Excel Calendar 1.77 Pop-up Excel Calendar shows you a date picker when you activate a date cell in Excel, so that you can pick or select date value from the calendar by clicking mouse, instead of typing in manually, thus saving time and avoiding format mistakes. 1.5K
  7. 7 Advanced Find & Replace for Excel 4.5.4 The Ablebits.com Advanced Find & Replace enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. The add-in works in Excel 2003 - 2010. 1.5K
  8. 8 Excel Compare 3.0 Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Excel Compare saves time by eliminating the file comparison routine, and improves comparison precision by telling you exactly what and where has been changed. 1.5K
  9. 9 AnalyzerXL Package 6.1.39 Trading and stock quotes downloading software for Microsoft Excel. Library of 165 technical analysis functions, historical and real time quotes downloaders, portfolio tracker. 1.4K
  10. 10 Canadian Postal Codes 1.0 Download the Canadian Postal Codes database. 765 344 precise (6 characters format) records are in the Canadian Postal Codes package. The package includes: Postal code, Latitude, Longitude. Latitudes and longitudes are to within 15 digits after comma 1.4K