# Break row data and store it into multiple sheets in single excel file

**URL:** <https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306>\
**Category:** Get Help & Discuss\
**Created:** [July 3, 2020, 11:53am UTC](https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306 "2020-07-03T11:53:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![akshay.kulkarni](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@akshay.kulkarni](https://community.automationedge.com/u/akshay.kulkarni)\
**Post date:** [July 3, 2020, 11:53am UTC](https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306/1 "2020-07-03T11:53:04Z")

</div>

How to break row data and store it into multiple sheets in a single excel file?

---

<div class="post-metadata">

**Author:** ![rohini.deshpande](https://avatars.discourse-cdn.com/v4/letter/r/e79b87/32.png) [@rohini.deshpande](https://community.automationedge.com/u/rohini.deshpande)\
**Post date:** [July 3, 2020, 11:54am UTC](https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306/2 "2020-07-03T11:54:35Z")

</div>

Hi Akshay,

You can achieve this by doing manually hard coding like:-  
If incoming data contains 6 fileds(columns) & you want to create 3 sheets with 2 fileds in each sheet then take 3 different excel o/p steps, specify the same file name but different sheet names in each step & write first 2 columns in first step(first sheet), next 2 columns in next sheet & so on…

If you want to achieve this dynamically the you need to write the code like checking no existing columns, then in loop checking column no & writing it in the specific sheet. etc…

---

<div class="post-metadata">

**Author:** ![sagarc](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@sagarc](https://community.automationedge.com/u/sagarc)\
**Post date:** [July 11, 2020, 6:49am UTC](https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306/3 "2020-07-11T06:49:11Z")

</div>

Hi Rohini,  
Its about column but we want to take 5 rows in one sheet and next 5 in other so how we can achieve this.

---

<div class="post-metadata">

**Author:** ![aesupport](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/aesupport/32/371_2.png) [@aesupport](https://community.automationedge.com/u/aesupport)\
**Post date:** [July 13, 2020, 6:39am UTC](https://community.automationedge.com/t/break-row-data-and-store-it-into-multiple-sheets-in-single-excel-file/2306/4 "2020-07-13T06:39:57Z")

</div>

We have **Split every … data rows** field in File and Sheet tab. Where you can specify number of rows, you want in sheet.