Consolidate data from multiple worksheets

Summarize several worksheets into one report

Consolidate data from multiple Excel files into one without opening each of them. Sum, count, find the maximum, minimum, or average value in three simple steps. The Consolidate Sheets tool can summarize your data by column headers, row headers, or position in a table.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Consolidate Sheets for Excel 2019, 2016 - 2010

With Consolidate Sheets you will

  • Consolidate multiple Excel files at once You can select as many Excel workbooks for merging as you need without even opening them.
  • Summarize any range Have the add-in consolidate all data on the sheet or select the desired range.
  • Summarize your data in 11 different ways All Excel consolidate functions are at your disposal to calculate the numbers one way or another.
  • Consolidate data in columns and rows Use column and row labels separately or together to calculate the numbers at the intersection.
  • Consolidate by position Have numbers merged and calculated according to their position in your tables.
  • Define a place for results Get the result in a new workbook, new worksheet, or any destination range that you specify.

How to consolidate data in Excel

You can choose as many files for consolidation as you need
You can choose as many files for consolidation as you need
Choose any of the Excel consolidate functions for your calculations
Choose any of the Excel consolidate functions for your calculations
Consolidate data based on column headers, row headers, or position
Consolidate data based on column headers, row headers, or position
Put the result into a new workbook, worksheet, or a range of your choice
Put the result into a new workbook, worksheet, or a range of your choice
Data from all selected worksheets are consolidated
Data from all selected worksheets are consolidated

Consolidate Excel files into one

4 different ways to summarize data

Consolidate files by column headers
Consolidate files by column headers
Summarize values by row labes
Summarize data by row headers
Merge and summarize data by row and column labels
Merge and summarize data in rows and columns
Consolidate data by position in worksheets
Consolidate sheets by position

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Consolidate Sheets and what do I need it for?

The Consolidate Sheets tool not only joins multiple Excel sheets together. It creates a full summary of your numbers, using any of Excel consolidate functions such as Sum, Count, Average, Min, Max, etc.

Doesn't Excel provide a way to consolidate data?

It does. You can use the built-in Excel Consolidate feature. But our Consolidate Sheets offers a user-friendly and intuitive way to join worksheets together. It will walk you through the consolidation process helping you configure all the options. In addition, our add-in can summarize data not only by column or row labels, but also by position.

How to consolidate many Excel files at once?

To consolidate multiple Excel files into one, do the following:

  1. Click Consolidate Sheets on the Ablebits Data tab.
  2. Select worksheets for consolidation.
  3. Select the function.
  4. Choose to consolidate by label or by position.
  5. Decide where to place the result.
  6. Click Consolidate.

See a more detailed description here.

How many Excel worksheets can I consolidate at once?

You are free to merge and calculate as many files as you need as long as the result table doesn't exceed the limit for cells in your Excel version.

What functions does Consolidate Sheets summarize with?

Our utility uses the following Excel consolidate functions: Sum, Count, Average, Max, Min, Product, Count Numbers, Stddev, Stddevp, Var, Varp.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close