Consolidate Worksheets Wizard for Excel 2016, 2013-2007

See also: Merge two Excel worksheets in 5 easy steps

How to consolidate data in multiple workbooks in seconds

Data consolidation in Microsoft Excel is arguably one of the most challenging and time-consuming tasks. But you can do it hands-down with Consolidate Worksheets Wizard. Simply install the add-in and now you can easily:

• Select any number of Excel files for consolidation
• Combine or copy data from the selected ranges into one worksheet
• Convert workbooks to spreadsheets
• Consolidate worksheets with the same name to one sheet
• Paste all, only values or links to source data into the resulting table
• Separate the copied ranges by a blank row
• Copy the results to a new workbook, worksheet, or select custom location

Consolidating data from multiple worksheets into one is no longer a challenge!

Excel: consolidate worksheets with ease

If you are an active user of the Excel consolidation option, our tool will help you consolidate multiple worksheets into one in a breeze. In addition to the standard feature, it lets you select many spreadsheets and automatically pick the same range for identically structured sheets

Often it is necessary to combine data from several worksheets into one master table. Merging multiple Excel files into one allows you to easily compare data, look through the results and create summary reports in Microsoft Excel 2010, 2007 and 2003. Our wizard will help you summarize, analyze data or prepare a report by joining multiple records and creating a consolidation table.

Merge Excel worksheets without copying and pasting!

Often we keep identically structured data in multiple spreadsheets and files. However helpful it is to check and view data parts individually, we sometimes need to combine them to create a Pivot Table, chart, or report in Excel.

Say, you have multiple sheets in numerous Excel workbooks. Most of these tables have identical structure. However the order and number of columns may differ in some of them. On a daily basis, you need to copy all the data from these lists to one spreadsheet.

If you want a trouble-free way to automatically copy certain ranges from numerous worksheets into a single large list, the AbleBits Consolidation add-in is a really good idea. With this tool you can select the necessary sheets or specify the ranges you need to copy and have them in one workbook in no time. Whether the structure of your lists is identical or different, the data from columns with the same name will be joined even if their order is broken. In addition, you can choose to copy data only for the matching columns in the sheet, which appears fist in the list on the add-in window.

Turn workbooks to sheets and copy them to one Excel file

Some tasks are more difficult to describe than to complete. Let's say your company's offices are scattered around different cities of different states. Every State Manager keeps an Excel file with a separate sheet for each city. At the end of the month State Managers forward their workbooks to you. You need to:

• combine worksheets in each workbook into one sheet first
• then place all joined worksheets into a new Excel workbook

In this case everybody would like to figure out how to do that automatically. Otherwise you can find yourself spending hours doing this manually each day. Check out the wizard's option Copy sheets in each workbook to one sheet. Place the resulting worksheets to one workbook to see how a difficult-to-describe task turns into an easy-to-do one.

Copy identically named worksheets to one

Working on the same project in Excel together involves tons of workbooks. In the result there can appear workbooks with identically named sheets either by accident or on purpose. To analyze and store the data effectively you may need to combine matching worksheets and place them to a new workbook. For example, you have similar Excel files. Each file has sheet tabs Mon, Tue, Wed, Thu, Fri. What you need is to join identically named sheets and copy them to a new workbook so that all Mondays will be under the same tab.

What can help you? VBA? Macro? Copy/pasting? Magic?

The answer is Consolidate Worksheets Wizard! The tool will recognize and combine sheets with the same name and put them to a new workbook.

Combine multiple Excel files into one

It can be really handy to have separate workbooks for different themes. But sometimes it is necessary to join worksheets from all workbooks into a single file to declutter your folders or to have an easier way to handle the data.

Let's imagine you have about 50 Excel files for different projects. Each workbook contains about 10 worksheets. You want to automatically copy certain sheets from each file into a master book.

With Consolidate Worksheets Wizard for Microsoft Excel it is not necessary to open all workbooks and copy/paste their sheets one by one. This no-nonsense add-in lets you select the sheets you need to include and copies them to one workbook.

Find more details

• Video: the easiest way to combine multiple Excel worksheets into one
• Download Consolidate Wizard and try for yourself
• How to merge several sheets into 1 - step-by-step guide

See the easiest way to combine multiple Excel worksheets

Consolidate Worksheets Wizard for Excel screenshots

Select Excel files to consolidate

Join data from identically named columns

Choose how exactly to combine your Excel data

Select destination worksheet for the results

Choose an option to copy several worksheets into one

Summarize data from multiple Excel worksheets into one

Consolidate Worksheets Wizard for Excel system requirements:

Microsoft Excel

• Microsoft Excel 2016 (32- and 64-bit)
• Desktop Excel included in Office 365
• Microsoft Excel 2013 (32- and 64-bit)
• Microsoft Excel 2010 (32- and 64-bit)
• Microsoft Excel 2007
• Microsoft Excel 2003

Operating System

• Windows 10 (32- and 64-bit)
• Windows 8 (32- and 64-bit)
• Windows 7 (32- and 64-bit)
• Windows Vista (32- and 64-bit)
• Windows XP (32-bit)
• Windows Server 2003, 2008, 2012
• .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Consolidate Worksheets Wizard version

Current add-in version: 3.1
published on: May 19, 2016

End-User License Agreement (EULA).