---
title: Merge excel sheets
description: Merge multiple Excel sheets into a single consolidated file within your workflow.
category: Data Transformation
tags: [excel, merge, spreadsheet, data processing, file automation]
---

# 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 file `merged_data.xlsx` for 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](#) |