Merge excel sheets
Description
The Merge Excel Sheets activity consolidates data from multiple Excel files into a single merged Excel file.
This activity is useful when working with datasets spread across multiple workbooks or reports. It automates the process of combining these files, making it easier to analyze, report, or process the data as one unit.
Use this activity to:
- Combine monthly or departmental reports into a single Excel file
- Prepare unified input for downstream transformations or uploads
- Automate Excel consolidation as part of ETL workflows
Use case:
A sales team uploads daily sales logs into individual Excel files. This activity merges them into a single filemerged_data.xlsxfor reporting and uploading to a database.
Input
| Input Type | Format | Description |
|---|---|---|
| Files | Excel (.xlsx) | Multiple Excel files to be merged |
Output
| Output Type | Format | Description |
|---|---|---|
| Merged File | Excel (.xlsx) | Consolidated Excel file with merged sheets |
Configuration Fields
| Field Name | Description |
|---|---|
| Input File Pattern | Pattern to match input Excel files (e.g., sales_*.xlsx). |
| Output File Pattern | Naming convention for the merged output file (e.g., merged_data.xlsx). |
Sample Input
Not applicable
Sample Configuration
| Field | Value |
|---|---|
inputFilePattern | sales_*.xlsx |
outputFilePattern | merged_data.xlsx |
Sample Output
| File Name | Size | Link |
|---|---|---|
| merged_data.xlsx | 5 MB | Download Link |