Consolidate Worksheets Wizard for Excel - Combine data from several Excel worksheets into a single worksheet
Ablebits.com Consolidate Worksheets Wizard for Microsoft Excel quickly combines data from multiple worksheets into one. This smart tool provides you with a number of consolidation options to choose from. You can merge data from one or several workbooks and csv files without opening them, create summary reports, copy multiple worksheets to one large table, consolidate worksheets by name and more.
This smart tool gives you flexibility in data consolidation and allows choosing additional options that suit you best:
- Select any number of Excel files for consolidation.
- Combine data from the selected ranges into one worksheet.
- Copy data from the selected ranges to one spreadsheet.
- Copy sheets in each workbook to one sheet. Place the resulting worksheets into one Excel file.
- Consolidate worksheets with the same name to one sheet.
- Copy the selected spreadsheets to one Excel workbook.
- Paste all, only values or links to source data into the resulting table.
- Preserve formatting of the selected ranges.
- Separate the copied ranges by a blank row.
- Copy the results to a new workbook, new worksheet or select custom location.
If you deal with numerous worksheets in Excel 2010 - 2003 that need data consolidation, Consolidate Worksheets Wizard is the right tool for you.
What's New: New release
Limitations: 15 Days Trial

Consolidate Worksheets Wizard for Excel 1.0 is 100% clean
This download (excel-consolidate-worksheets.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. Ablebits.com Duplicate Remover for Excel 3.0.1 - Remove duplicates from a list, compare two tables for duplicates or uniques.
2. Merge Tables Wizard for Microsoft Excel 3.0.2 - Combine matching data from 2 Excel worksheets into one in seconds.
3. Ablebits.com Split Names for Excel 1.5.2 - Split a column of names into individual cells: names, salutations, suffixes etc.
4. AutoFormat for Excel PivotTables 2.0.3 - Create, store and apply your own formats for excel pivot tables
5. Advanced Find & Replace for Excel 4.5.4 - Find and Replace in values, formulas and comments in all opened workbooks.
6. Merge Cells Wizard for Excel 3.0.8 - Merge Excel cells preserving all data, join by rows or columns.
7. Ablebits.com Workbook Manager for Excel 1.0.4 - See all opened books & sheets in a tree view. Easily sort, insert, rename, copy
8. Fuzzy Duplicate Finder for Excel 3.5.3 - Find and remove partial duplicates, misprints and typos from Excel worksheets.
9. Split Table Wizard for Microsoft Excel 1.0 - Split an Excel worksheet into separate tables by column value
10. Combine Rows Wizard for Microsoft Excel 1.0.1 - Combine data from multiple duplicate rows into one in Excel 2010-2003.