# Output Data in Excel using a Template

**URL:** <https://community.automationedge.com/t/output-data-in-excel-using-a-template/5144>\
**Category:** Process Studio\
**Created:** [December 7, 2021, 1:31am UTC](https://community.automationedge.com/t/output-data-in-excel-using-a-template/5144 "2021-12-07T01:31:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmr](https://avatars.discourse-cdn.com/v4/letter/j/d6d6ee/32.png) [@jmr](https://community.automationedge.com/u/jmr)\
**Post date:** [December 7, 2021, 1:31am UTC](https://community.automationedge.com/t/output-data-in-excel-using-a-template/5144/1 "2021-12-07T01:31:29Z")

</div>

Hi,

I am trying to read data from an Input file and then write it on an Excel Template. What I want to achieve is, it should output a separate Template for each data and will still be on the same Output Excel template sheet. Pls see snippet below.

This is my Input File (Excel)

![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/f/f82099e9e5f740c5953be1cbb4eadb57e14d1a34.png)

This is the Excel Template  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/c/caec917143d15d5aa84c0c00201d2cc70918366f.png)

And this is the Output that I want to achieve.

![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/4/40ef9bf67b6f1ce0c6e55dc25ac97e531fecf0e8.png)

Would really appreciate your help in guiding me on how I can build this workflow in PS. Thanks

---

<div class="post-metadata">

**Author:** ![pratik.doke](https://avatars.discourse-cdn.com/v4/letter/p/f1d935/32.png) [@pratik.doke](https://community.automationedge.com/u/pratik.doke)\
**Post date:** [January 4, 2022, 11:27am UTC](https://community.automationedge.com/t/output-data-in-excel-using-a-template/5144/2 "2022-01-04T11:27:10Z")

</div>

Hi Jmr,

Attached workflow for your reference.

[Template.zip](https://community.automationedge.com/uploads/short-url/GReUemzTy26tVikyp6iSn8vk3f.zip) (28.7 KB)

.
