This tutorial shows how to combine multiple Excel sheets into one output in Advanced ETL Processor. Use it when each sheet has the same structure and you need one usable dataset instead of workbook archaeology.
What You Will Learn
- Combine Excel sheets that share the same structure.
- Write the combined data into one Excel output.
- Use Excel Writer settings for sheets, tables, or ranges.
- Know when a complex workbook needs block transformation instead.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Writer Docs
This tutorial assumes that all sheets have the same structure. If the workbook has irregular blocks, merged layouts, or sections pretending to be tables, block transformation is usually the better tool.
The supporting Excel Writer documentation covers working with Excel sheets, Excel tables, Excel ranges, adding data into an existing Excel file, and working with Excel tables and ranges.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.