RDBMerge

An easy and accessible way for users to merge data from multiple Excel workbooks, CSV and XML files into one workbook summary

RDBMerge for Windows is a free Excel add-in by Ron de Bruin that allows users to take information from multiple workbooks and combine them into a singular summary workbook for easier access and interpretation. Below are listed some of the features this add-in has to offer.

Saves time by combining data from many Excel files into one summary sheet in a single step.

Features:

• Merging multiple Excel workbooks (XLS, XLSX, XLSM, XLSB), CSV and XML files from a folder, optionally with subfolders, into a singular summary workbook
• Adding the source file name next to the merged data in the summary workbook to efficiently organize your information
• Entering open and modify passwords to merge data from password-protected workbooks
• Selecting worksheets by index or name and setting a fixed range or a range from a first cell, so that all information is properly organized into the final summary spreadsheet

In conclusion, RDBMerge saves time by providing this Excel add-in to users throughout the world. Through this add-in, users can seamlessly merge multiple Excel files into one large summary data file for further analysis, and a log sheet lists any errors. The add-in (version 1.4) works with Excel 97-2003 and Excel 2007-2016 for Windows and is no longer updated.