Merge multiple Excel files into one

Combine worksheets without copying and pasting

All-in-one toolkit to merge and consolidate data in Excel. Use the Copy Sheets add-in to bring worksheets from different workbooks together or combine data from multiple sheets into one. Get the Consolidate Sheets wizard to summarize data for your reports. Utilize the Combine Sheets tool to merge Excel sheets based on column headers.

Buy now
  • 30-day unconditional money-back guarantee
  • 1 license for 2 PCs, e.g. work and home
  • Life-time license & support, no annual fees
  • Copy data from different sheets
  • Combine tables based on their headers
  • Consolidate and summarize data

With Combine Worksheets Toolkit you will

  • Combine multiple Excel files into one Merge numerous workbooks and worksheets into one file without even opening each of them.
  • Merge selected sheets into one workbook Select the worksheets of interest from various files and have them copied to a single workbook.
  • Collect data from identically named sheets Merge data from all the worksheets with the same name into one spreadsheet.
  • Copy data from selected sheets Select ranges of data to pull them from many Excel worksheets into one.
  • Merge tables based on common columns Bring data from identically named columns of different tables together.
  • Consolidate data in Excel Get a full summary report by merging and summarizing data from multiple Excel files.
  • Save formatting of each table If needed, keep the formatting of all original tables that have been brought together.
  • Choose a place for results Put the results to a new worksheet, workbook, or any specific location in any worksheet.

How to merge Excel files without copying and pasting

  
Watch how you can quickly combine multiple sheets into one
Select the way you want to copy your worksheets
Select the way you want to copy your worksheets
Choose which worksheets you'd like to bring together
Choose which worksheets you'd like to bring together
Instantly get all data combined in one file
Instantly get all data combined in one file
Select the columns you need to combine
Select the columns you need to combine
Have the values from the same columns merged into one column
Have the values from the same columns merged into one column
Choose the function to consolidate your data
Choose the function to consolidate your data
Have a summary report in a new worksheet
Have a summary report in a new worksheet
Watch how you can quickly combine multiple sheets into one
Select the way you want to copy your worksheets
Choose which worksheets you'd like to bring together
Instantly get all data combined in one file
Select the columns you need to combine
Have the values from the same columns merged into one column
Choose the function to consolidate your data
Have a summary report in a new worksheet

Merge multiple Excel files into one

exactly the way you want

Copy sheets in each workbook to one sheet.
Copy sheets in each workbook to one worksheet and place the resulting sheets in one file.
Copy data from the selected sheets with the same name to one sheet.
Copy data from the selected sheets with the same name to one sheet.
Copy the selected worksheets to one workbook.
Copy the selected worksheets to one workbook.
Copy data from the selected worksheets to one sheet.
Copy data from the selected worksheets to one sheet.
Consolidate data in rows or columns.
Consolidate data by row and column labels.
Combine the selected worksheets to one workbook.
Combine worksheets by column headers.

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
Buy now

These companies choose Ablebits products

   

Frequently asked questions

About Combine Worksheets Toolkit

  • What is Combine Worksheets Toolkit and what do I need it for?

    The Combine Worksheets Toolkit lets you merge multiple Excel files into one without copying and pasting. It offers 3 tools to do that.

    Copy Sheets copies worksheets or data from several workbooks into one. You can choose to arrange the copied datasets side by side or one under another, save the original headers, formulas, and even formatting.

    Combine Sheets merges spreadsheets based on their column headers. You decide whether to bring the data together from all or specific columns.

    Consolidate Sheets comes in handy when you need to merge and calculate numbers at the same time. The wizard consolidates numeric data using Excel summary functions (aggregation functions) such as SUM, COUNT, AVERAGE, MAX, MIN, etc.

  • Doesn't Excel provide a free way to combine many Excel files?

    You can merge sheets in Excel using VBA. But this approach requires some skills and has a number of limitations. Or, you can try combining data from multiple worksheets with Power Query. However, this way is rather difficult and requires a long learning curve. Finally, you can use Excel's built-in Consolidate tool. Compared to the first two methods, it's quite easy to use, but it works only for summarizing numeric data.

    Our toolkit offers many different ways to merge Excel files of any structure and size.

  • How to merge multiple Excel files into one?

    To merge several Excel files into one, use the Copy Sheets Wizard:

    1. Click Copy Sheets on the Ablebits Data tab.
    2. Choose what to copy:
      • Sheets from each workbook to one sheet.
      • Sheets with the same name to one sheet.
      • Selected sheets to one workbook.
      • Data from the selected sheets to one sheet.
    3. Select the worksheets and, optionally, ranges to copy.
    4. Choose additional copying options.
    5. Click Copy.

    See a more detailed description here.

  • How to combine Excel sheets based on column headers?

    To combine data from multiple worksheets into one, use the Combine Worksheets Wizard:

    1. Click Combine Sheets on the Ablebits Data tab.
    2. Select the worksheets.
    3. Choose the columns to combine.
    4. Select additional options if needed.
    5. Specify where you want to place the result.
    6. Click Combine.

    See a more detailed description here.

  • How to consolidate data in Excel?

    To merge and summarize numerical data from different workbooks, use the Consolidate Worksheets Wizard:

    1. Click Consolidate Sheets on the Ablebits Data tab.
    2. Select the worksheets for consolidation.
    3. Select the function to process your data with.
    4. Choose to consolidate by column or row 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 combine at once?

    You are free to merge as many files as you need as long as the result table doesn't exceed Excel's limit for cells. These limits depend on the version of Excel you use.

  • All my tables are formatted differently, how will your tools handle that?

    That depends on you, actually :) Our tools will keep the formatting of each original table if you choose to do so. Only the Consolidate Sheets Wizard won't be able to do that since it calculates numbers and creates a new summary report for you.

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
7-day trial 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