This tutorial shows how to merge multiple Excel files into one workbook in Advanced ETL Processor. Use it when source files arrive separately but reporting needs one clean Excel output.
What You Will Learn
- Read source data from multiple Excel files.
- Write the combined output into one Excel workbook.
- Choose whether to work with sheets, tables, or ranges.
- Avoid manual copy and paste between workbooks.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Reader and Writer Docs
This tutorial combines multiple source Excel files into one output workbook. Excel is not needed on the machine running the workflow.
The supporting Excel Reader documentation covers reader properties, the ignore format option, and working with Excel tables and ranges.
The Excel Writer documentation covers working with Excel sheets, adding data into an existing Excel file, and combining multiple data sources into a single Excel file.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.