top of page
Computer Robot

CSV to Excel Automation

Starter Pack

This is the # 3  series of the UiPath small starter pack series. We provide tutorials for implementing automation with examples of cases that are commonly encountered in everyday life.

UiPath - Input Bank Statement Automation: Image

Why you need Small Starter Pack?

First time on Robotic Process Automation (RPA) and UiPath? Don't have an idea for automation?

Small starter pack will help you to learn and familiar with UiPath. We provide UiPath Starter Pack to let you experience the look and feel of UIPath and trial it yourself. We offer support for you to plan, build, manage, run, and measure automation using UiPath.

​

Check our UiPath Starter pack series

​

  1. Input Bank Statement Automation

  2. Collect Invoice from Emails Automation

  3. CSV to Excel Automation

  4. Split Excel Sheet into Multiple Sheets Automation

  5. PDF table to Excel Automation

  6. Collect Customers Data from Website Automation

  7. Generate Excel Report from Database Automation

Get Started on your UiPath journey

Interest in purchasing or need more information?

Please enter your email to request a quote or request more information about the UiPath Small Starter Pack.

Thanks for submitting! We will contact you soon.

An error occurred. Try again later

UiPath - Input Bank Statement Automation: Text

CSV to Excel

In this case, an accountant has a task to calculate cash flow and status from operations. An accountant needs to copy cash-in and cash-out information from the CSV file and data processing into Excel.

CSV to Excell Manually.jpg
UiPath - Input Bank Statement Automation: Video

How UiPath Help CSV to Excel Automation?

UiPath robot capable of mimicking human user actions.

UiPath robot will help the accoutant to improve the speed of the operation and end the repetitive tasks.

CSV to Excel by Robot.jpg
UiPath - Input Bank Statement Automation: Video

CSV to Excel Automation using UiPath

Build an automation with no code using UiPath StudioX

  • Create a new project by selecting blank task in the new project section.

  • Fill in the process name, location and description

  • Let's build the UiPath robot

  1. Add activity "Excel File" to set where the files will be saved

  2. Add activity "Read CSV" to know the files to be processed

  3. Add activity "Write Range"

  4. Add activity "Insert Column" to add new column "Difference"

  5. Add Activity "Insert Column" to add new column "Status"

  6. Add Activity "For Each Excel Row"

  7. Add Activity "Write Cell" to calculate column "Difference"

  8. Add Activity "Write Cell" to set column "Status"

  9. Add Acitivity "Message Box" to show the process is completed

  10. Click button "Run"

​

List of UiPath components on CSV to Excel Automation :

  • Activity "Excel File"

  • Activity "Read CSV"

  • Activity "Write Range"

  • Activity "Insert Column"

  • Activity "For Each Excel Row"

  • Activity "Write Cell"

  • Activity "Message Box"

down-arrow.png
UiPath - Input Bank Statement Automation: Video

What is in UiPath Starter Pack?

small starter pack.JPG
UiPath - Input Bank Statement Automation: Text

How to execute small starter pack?

execute(1).jpg
UiPath - Input Bank Statement Automation: Image

Get Started on your UiPath journey

Interest in purchasing or need more information?

Please enter your email to request a quote or request more information about the UiPath Small Starter Pack.

Thanks for submitting! We will contact you soon.

An error occurred. Try again later

bottom of page