# AutomationEdge RPA Bot | Excel Bot for Data Massaging - RPA

**URL:** <https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging-rpa/10246>\
**Category:** AutomationEdge Cook Book\
**Tags:** rpa\
**Created:** [July 25, 2023, 1:14pm UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging-rpa/10246 "2023-07-25T13:14:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pallavi.Rajadhyax](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@Pallavi.Rajadhyax](https://community.automationedge.com/u/Pallavi.Rajadhyax)\
**Post date:** [July 25, 2023, 1:14pm UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging-rpa/10246/1 "2023-07-25T13:14:05Z")

</div>

This video showcases an AutomationEdge RPA Bot | Excel Bot for Data Massaging on Employee data.

The bot performs data massaging to get Employee Count by designation and Sort Employees by Roll No.

This RPA bot/workflow uses the following AutomationEdge Plugin steps:  
Microsoft Excel Input, Sort Rows, Group By, Block, Microsoft Excel Output

Click on the below links to view complete videos:

(1)Excel Bot for Data Massaging- [https://www.youtube.com/watch?v=Lz5dkxL4IHs](https://www.youtube.com/watch?v=Lz5dkxL4IHs)  
(2)Excel Bot for Pay Slip Distribution with Mail Merge - [https://www.youtube.com/watch?v=6rEij5tU7xc](https://www.youtube.com/watch?v=6rEij5tU7xc)  
(3)Excel Bot for Salary Transfer to Bank- [https://www.youtube.com/watch?v=c7CjYhmypdE](https://www.youtube.com/watch?v=c7CjYhmypdE)  
(4)Excel Bot and send Mail- [https://www.youtube.com/watch?v=P34RrDV7FF0](https://www.youtube.com/watch?v=P34RrDV7FF0)  
(5)Excel Bot to Read Timesheet Emails - [https://www.youtube.com/watch?v=q5cKOlRB8lI](https://www.youtube.com/watch?v=q5cKOlRB8lI)  
(6)AutomationEdge RPA Bot for Employee Data transformation - [https://www.youtube.com/watch?v=7NLg0krRYSM](https://www.youtube.com/watch?v=7NLg0krRYSM)  
(7)Manage a Long-Running AutomationEdge RPA Bot | Excel Bot - [https://www.youtube.com/watch?v=HZgY0i7s-ac](https://www.youtube.com/watch?v=HZgY0i7s-ac)  
(8)Excel Bot to Combine Timesheets - [https://www.youtube.com/watch?v=ewknhuSpbK4](https://www.youtube.com/watch?v=ewknhuSpbK4)  
(9)Salary Processing with formatted output based on a template - [https://www.youtube.com/watch?v=D3zH6umOXXY](https://www.youtube.com/watch?v=D3zH6umOXXY)  
(10)Salary Processing and Reports based on an Excel template file-  
[https://www.youtube.com/watch?v=d5UN-qLfb1M](https://www.youtube.com/watch?v=d5UN-qLfb1M)

#AutomationEdge #SortRows #GroupBy #Block, #MicrosoftExcelInput #MicrosoftExcelWriter #MicrosoftExcelOutput #AutomationEdge #rpa #hyperautomation #workflow #bot #roboticprocessautomation

---

<div class="post-metadata">

**Author:** ![Jane](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@Jane](https://community.automationedge.com/u/Jane)\
**Post date:** [July 26, 2023, 7:45am UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging-rpa/10246/2 "2023-07-26T07:45:40Z")

</div>

Please could you provide a summary or gist of each video!