Consolidate Worksheets Wizard for Excel 2016, 2013-2007

Merge data from multiple Excel files into one

Consolidate Worksheets Wizard for Microsoft Excel easily consolidates multiple worksheets into one. This smart tool provides you with a number of data consolidation options to choose from:

  • Merge worksheets from different workbooks into one Excel file
  • Combine data from several worksheets into single Excel spreadsheet
  • Join several Excel workbooks and csv files without opening them

Free download for:

Choose worksheets for consolidation

See also: Merge two Excel worksheets in 5 easy steps

Merge Excel Tables wizard will help you combine data from two Excel sheets by matching columns in seconds!

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.

Consolidate sheets into one file in Excel

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.

Copy multiple worksheets to create one big table

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.

Consolidate data in multiple workbooks into one Excel file

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.

Merge identically named sheets and place them to another 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.

Combine sheets from multiple workbooks into one book

Find more details

Buy now

See the easiest way to combine multiple Excel worksheets

Consolidate Worksheets Wizard for Excel screenshots

Select Excel files to consolidate

Choose worksheets for consolidation

Join data from identically named columns

Select columns to combine based on their name

Choose how exactly to combine your Excel data

Choose additional consolidation options

Select destination worksheet for the results

Choose an Excel file to place the results

Choose an option to copy several worksheets into one

Choose how you want to copy your worksheets

Summarize data from multiple Excel worksheets into one

Consolidate your data by label or by position

Free Download
7-day fully functional version

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

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .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: 2018.2
published on: Nov 17, 2017

End-User License Agreement (EULA).

Featured customers featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools -