# How to write data into single excel file different sheets
**URL:** https://community.automationedge.com/t/how-to-write-data-into-single-excel-file-different-sheets/18152
**Category:** Process Studio
**Tags:** excel, rpa
**Created:** [August 31, 2026, 5:55am UTC](https://community.automationedge.com/t/how-to-write-data-into-single-excel-file-different-sheets/18152 "2026-08-31T05:55:58Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@sankalpM](https://community.automationedge.com/u/sankalpM)
#### Post date: [August 31, 2026, 5:55am UTC](https://community.automationedge.com/t/how-to-write-data-into-single-excel-file-different-sheets/18152/1 "2026-08-31T05:55:58Z")
I have two excel files with one sheet in both files and i want to put both the sheet in one excel file how do i do it? i’m using excel writer but im not able to do the configuration
---
### Author:  [@madhavibade1](https://community.automationedge.com/u/madhavibade1)
#### Post date: [September 16, 2026, 12:02pm UTC](https://community.automationedge.com/t/how-to-write-data-into-single-excel-file-different-sheets/18152/2 "2026-09-16T12:02:47Z")
Assuming you want to keep the data on two separate sheets within the new destination file (which is the standard approach regardless of whether the headers match), here is the step-by-step configuration.
**1.Read the Files:**
Add two separate **Microsoft Excel Input** steps, configuring each to read one of your source files. Verify by previewing the data.
**2.Add Writer Steps:**
Connect each Input step to its own separate **Microsoft Excel Writer** step.
**3.Target the Same File:**
In both Writer steps, specify the exact same destination path in the `Filename` field and select the `.xlsx` `Extension`. Verify the paths match perfectly.
**4.Define Sheet Names:**
Set a unique `Sheet Name` in each Writer step (e.g., “Sheet1” for the first, “Sheet2” for the second). Run the workflow to verify.
### Alternative: Merging into a Single Sheet
If both source files have the **exact same headers** and you want to append the data together into one single sheet:
- Route both Input steps into a _single_ **Microsoft Excel Writer** step.
- Define a single `Sheet Name`.
- Set `If sheet exists in output file` to **Write to existing** so it appends the rows.
Does this assumption align with what you’re trying to achieve, or were you looking to merge the data differently?