top of page
Analyzing Chart

Split Excel Sheet into Multiple Sheet Automation

Starter Pack

This is the # 4  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.

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.

Split Excel Sheet into Multiple Sheet

Do you have big data on an excel sheet and you need to distribute that sheet into multiple sheets based on some data in a column? If you do this manually, you need to sort it first and then copy-paste them one by one into another new excel sheet. This is a very basic task but time-consuming and it will drain you too.

split excel sheet.jpg

How UiPath Help Split Excel Sheet into Multiple Sheet Automation?

UiPath robot capable of mimicking human user actions.

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

split by robot.jpg

Split Excel Sheet into Multiple Sheet 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 "Use Excel File" to set where the files will be saved

  2. Select data manager and add file excel to be processed

  3. Add activity "Group" to process each group in excel

  4. Add activity "Rename Sheet" to rename the sheet

  5. Add activity "Filter" to filter input excel based on city column

  6. Add activity "Copy Range"

  7. Add activity "Format as Table" to format data as a table

  8. Add activity "Message Box" to show the process is completed

  9. Click button "Run"

List of UiPath components on Split Excel Sheet into Multiple Sheet Automation :

  • Activity "Use Excel File"

  • Activity "Group"

  • Activity "Rename Sheet"

  • Activity "Filter"

  • Activity "Copy Range"

  • Activity "Format as Table"

  • Activity "Message Box"


Check our UiPath Starter pack series

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.

Thanks! We'll contact you shortly.

bottom of page