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.

Learn more
This tool is part of
Ultimate Suite
Consolidate Sheets for Excel 2016 - 2007

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
You can choose as many files for consolidation as you need
Choose any of the Excel consolidate functions for your calculations
Consolidate data based on column headers, row headers, or position
Put the result into a new workbook, worksheet, or a range of your choice
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 data by row headers
Summarize values by row labes
Merge and summarize data in rows and columns
Merge and summarize data by row and column labels
Consolidate sheets by position
Consolidate data by position in worksheets

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Consolidate Sheets

  • 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

 

Excel

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

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.
Excel add-ins and Outlook tools - Ablebits.com