# Creating multiple sheets

**URL:** https://community.automationedge.com/t/creating-multiple-sheets/1720
**Category:** Get Help & Discuss
**Created:** [March 3, 2020, 9:59am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720 "2020-03-03T09:59:32Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![shubham.dhumane](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@shubham.dhumane](https://community.automationedge.com/u/shubham.dhumane)
#### Post date: [March 3, 2020, 9:59am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/1 "2020-03-03T09:59:32Z")

</div>

How to create multiple sheets in single excel workbook?

---

<div class="post-metadata">

### Author: ![priyanka.gupta](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@priyanka.gupta](https://community.automationedge.com/u/priyanka.gupta)
#### Post date: [March 3, 2020, 10:03am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/2 "2020-03-03T10:03:32Z")

</div>

Hi Sbhubham,  
As workflow executes in a parallel manner, we cannot create multiple sheets simultaneously in one excel workbook.  
In this case, we need to use “Block the step until steps finish” step to serialize the generation of sheets in one excel workbook like shown in the attached screenshots.

 ![1. WorkflowScreenshot](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/d8cfa6b52846a1e6661a5cc947df1320acfbc207.png) ![2. ExcelSheet1_Screenshot](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/fcccd784c70580902c373c11e3f874389febb3d0.png) ![3. ExcelSheet2_Screenshot](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/86fb577ef70616c8a8e9273813b08a8c8e8277e5.png) ![4. ExcelSheet_Screenshot](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/b73e6754a131106b1b8352f07db7f154f111d515.png)

---

<div class="post-metadata">

### Author: ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)
#### Post date: [May 20, 2020, 8:15am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/3 "2020-05-20T08:15:40Z")

</div>

How to merge multipe sheets data into one sheet?

---

<div class="post-metadata">

### Author: ![BhagyashriC](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@BhagyashriC](https://community.automationedge.com/u/BhagyashriC)
#### Post date: [May 20, 2020, 8:29am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/4 "2020-05-20T08:29:49Z")

</div>

Do you have same fields/columns in all the sheets.

---

<div class="post-metadata">

### Author: ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)
#### Post date: [May 20, 2020, 8:35am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/5 "2020-05-20T08:35:59Z")

</div>

Yes, All fields are same in all sheets

---

<div class="post-metadata">

### Author: ![BhagyashriC](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@BhagyashriC](https://community.automationedge.com/u/BhagyashriC)
#### Post date: [May 20, 2020, 11:01am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/6 "2020-05-20T11:01:12Z")

</div>

Please refer below workflow.

[WF\_MultipleSheetsInput.psw](https://community.automationedge.com/uploads/short-url/ccxH7T80xm8bhMUCG313g3qpef5.psw) (19.9 KB)

---

<div class="post-metadata">

### Author: ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)
#### Post date: [May 20, 2020, 12:08pm UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/7 "2020-05-20T12:08:17Z")

</div>

Thank you, successfully executed.

---

<div class="post-metadata">

### Author: ![Vaishali](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@Vaishali](https://community.automationedge.com/u/Vaishali)
#### Post date: [April 4, 2021, 6:24am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/8 "2021-04-04T06:24:03Z")

</div>

Ok ma’am ,i got this with different excel input but “if we are having single excel input file” with 30 rows in it and we want to split it in 3 different sheet with single sheet should consist maximum 10 rows ?

---

<div class="post-metadata">

### Author: ![SnehalWaghmare](https://avatars.discourse-cdn.com/v4/letter/s/ea5d25/32.png) [@SnehalWaghmare](https://community.automationedge.com/u/SnehalWaghmare)
#### Post date: [June 3, 2021, 8:05am UTC](https://community.automationedge.com/t/creating-multiple-sheets/1720/9 "2021-06-03T08:05:30Z")

</div>

Directly go for using step Microsoft Excel Input(get its all sheets while configuring ) and Microsoft Excel Writer