# Excel Automation

**URL:** <https://community.automationedge.com/t/excel-automation/5625>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [March 24, 2022, 6:05am UTC](https://community.automationedge.com/t/excel-automation/5625 "2022-03-24T06:05:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![junaid98shaikhjsgma](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@junaid98shaikhjsgma](https://community.automationedge.com/u/junaid98shaikhjsgma)\
**Post date:** [March 24, 2022, 6:05am UTC](https://community.automationedge.com/t/excel-automation/5625/1 "2022-03-24T06:05:16Z")

</div>

I want to compare two excel sheets and copy the non duplicate lines to new excel file. How can I achieve the same?

---

<div class="post-metadata">

**Author:** ![KalyaniW](https://avatars.discourse-cdn.com/v4/letter/k/71e660/32.png) [@KalyaniW](https://community.automationedge.com/u/KalyaniW)\
**Post date:** [April 1, 2022, 8:10am UTC](https://community.automationedge.com/t/excel-automation/5625/2 "2022-04-01T08:10:44Z")

</div>

Hello @junaid98shaikhjsgma

You can use the two separate Microsoft Excel Input steps to read the two sheets and then use the Merge Join step to merge the data of the two sheets. And, then use the Formula step to check if the data from the two sheets matches or not.

I’ve attached a sample workflow for your reference.  
[DataCompareTwoSheets.xls](https://community.automationedge.com/uploads/short-url/n37FtyVOXTyFJJTiYddK6igYurD.xls) (23 KB)  
[WF\_CompareTwoSheets.psw](https://community.automationedge.com/uploads/short-url/4WoRVNI0BXCBwwPB2u9DqFVcF1G.psw) (24.3 KB)

---

<div class="post-metadata">

**Author:** ![junaid98shaikhjsgma](https://avatars.discourse-cdn.com/v4/letter/j/5daacb/32.png) [@junaid98shaikhjsgma](https://community.automationedge.com/u/junaid98shaikhjsgma)\
**Post date:** [April 2, 2022, 1:21pm UTC](https://community.automationedge.com/t/excel-automation/5625/3 "2022-04-02T13:21:18Z")

</div>

Thank you @KalyaniW