# Split every data rows

**URL:** <https://community.automationedge.com/t/split-every-data-rows/2554>\
**Category:** Get Help & Discuss\
**Tags:** rpa\
**Created:** [September 10, 2020, 11:20am UTC](https://community.automationedge.com/t/split-every-data-rows/2554 "2020-09-10T11:20:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AnkitaPuri](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@AnkitaPuri](https://community.automationedge.com/u/AnkitaPuri)\
**Post date:** [September 10, 2020, 11:20am UTC](https://community.automationedge.com/t/split-every-data-rows/2554/1 "2020-09-10T11:20:14Z")

</div>

Can I use “Split every…data rows” feature to splits the rows in different Sheet in Same excel File

---

<div class="post-metadata">

**Author:** ![mrunalini](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@mrunalini](https://community.automationedge.com/u/mrunalini)\
**Post date:** [September 10, 2020, 11:22am UTC](https://community.automationedge.com/t/split-every-data-rows/2554/2 "2020-09-10T11:22:20Z")

</div>

Hi Ankita,

Split every… data rows split the data rows in different excel files. To split the data in different sheets in the same excel file you may use Executor to create a sheet dynamically and write the data rows.