If data migration is even tangentially related to your job, you use Excel. With all the web apps and tools at our disposal today, Excel is still (by far) the most powerful tool when working with large data sets. It’s capabilities, functions and speed have made it a cornerstone of data migration.

That said, unless you have a decent knowledge of Visual Basic for Applications (VBA), Excel can be limiting. Time and time again you will find Excel functions lacking in key areas. But, there is light at the end of tunnel! That light is provided by the Ablebits Ultimate Collection for Excel, a package of insanely useful Excel utilities for all things data.

While the purpose of this post is not to review the Ultimate Collection, I wanted to quickly highlight my satisfaction with their Excel extensions. As I say in the screencasts below, the Ablebits Ultimate Collection has literally saved me hundreds of hours of drone work on various projects. Below I’ll show you how to use the Merge Tables Wizard to add and update data across two different spreadsheets in Excel.

Add Missing Data From One Excel Spreadsheet to Another

Update Existing Data From One Excel Spreadsheet to Another

Posted by: John Dugan

Comments

  • Global

    Hi!

    My team and I are searching for a simple solution to merging large data sets. We have considered PowerBI tools, SQL, etc., however these options are limiting the results we’re seeking.

    For example, there is a master list of firms. From that list each state has been placed in a separate workbook. The data has been manipulated within each workbook (i.e. a de-duplication process/added information), then leaving the data we would like to merge to the master. In merging, we would like to populate and/or replace data in the master list. Is this possible with the AbleBits add-in?