Combine data from several Excel worksheets into one
Consolidate Worksheets Wizard for Microsoft Excel 2016, 2013-2003
You create summary reports using data from several different workbooks. Sometimes you need to copy the same range from different worksheets to one; sometimes you sum up data, or simply bring several workbooks together by your criterion.
Consolidate Worksheets Wizard solves the most common tasks for bringing data from different spreadsheets into one in Microsoft Excel 2003-2016. You can summarize data from multiple sheets that took months to collect, combine several Excel files, bring sheets with the same name to one workbook, and a lot more.
How Consolidate Worksheets Wizard works
This add-in leads you through 4 simple steps to get the merged files you need:
- You specify the ranges with the data in Excel sheets that you want to combine; Excel files do not even have to be open.
- You have a choice of 5 consolidation types.
- Depending on the way you consolidate data, there are a couple of useful additional options.
- Then you select where you want to place the results: a new workbook, worksheet, or a custom location, and hit "Start".
You can get this add-in as a part of Ultimate Suite for Excel - 40+ tools destined to cut your time and clicks on the most frequent spreadsheet tasks.
Summarize data from multiple files
When you have similar data in different Excel files, say, split by the year, eventually you'll need to create a chart, a Pivot table, or some sort of summary report with it. Whether or not you are familiar with the Excel consolidate option, its power is included and enhanced in the add-in.
You can simply check off all needed worksheets and define the range you want to consolidate. Just as in Excel, you can choose the function to apply to numbers. If your data are identically structured, you can consolidate by position, otherwise you can consolidate by category. You can get the sheet consolidated in just a few clicks.
Bring data from the selected ranges or sheets to one file
Copying and pasting is really like making fire without using the matches. The add-in can take the same range from dozens of worksheets and bring all the data to one file, no excess rows or laborious switching between sheets.
The same goes for worksheets you need to have in one Excel workbook: just select all you need, they do not have to be open to be copied to one file.
Merge Excel workbooks or sheets with the same name
Even complex tasks can be easy. If each workbook you have represents a month, and you need to create one that would represent the whole year – there is an option in this wizard that will convert every workbook to one excel sheet and take them all to one new Excel sheet.
What about learning how January in 2012 was different from January 2013? Do you need to shuffle worksheets with the same names because they are in different files?
5 clicks will copy identically named sheets to one workbook, ready for you to review.
Using standard options is somewhat cumbersome and it limits your possibilities. Consolidate Worksheets Wizard lets you choose Excel files and data you want to work with, and it gives you a number of options to consolidate data. It makes it simple for you to prepare a summary report by bringing together just the data you need as quickly as you can get it.
Consolidate Worksheets Wizard system requirements
- Microsoft Excel 2016 (32 and 64-bit)
- Microsoft Excel 2013 (32 and 64-bit)
- Microsoft Excel 2010 (32 and 64-bit)
- Microsoft Excel 2007
- 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.
Consolidate Worksheets Wizard for Excel version
Current add-in version: 3.0.24
published on: Feb 02, 2016