activities
latest
false
UiPath logo, featuring letters U and I in white
Productivity Activities
Last updated Dec 6, 2024

Excel how-to guides

This page includes guides and resources that can help you learn how to create automations using the activities in this package.

Tutorials

Step-by-step guides on how to create automations from scratch. Each tutorial includes a project that you can download and open in UiPath Studio.

TutorialDescriptionActivities
Creating a Pivot TableAdd an Excel file to an automation and how to create a pivot table. Modern Activities
Iterating through Rows in a TableRepeat a set of activities for each row in an Excel file and configure your project to execute certain activities only when a specific condition is met. Modern Activities
Comparing Excel Files and Emailing Reconciliation ErrorsReconcile two files and, when data does not match, send an email with details about the errors that were found. Modern Activities
Filtering Data in ExcelFilter data in Excel, copy the filtered data to a CSV file, and email the CSV file. Modern Activities
Formatting CellsFormat cells in Excel.Modern Activities
Adding Information about the Files in a Folder to an Excel FileIterate through the files in a folder, retrieve their properties, and add this information to an Excel file. Modern Activities
Extracting Table Data from a Web Page and Editing It in ExcelExtract structured data from a web page and format it the way you want with Excel activities. Modern Activities
Manage CSV FilesRead a .csv file and append data from one .csv file to another .csv file. Classic Activities
Filter CSV FilesRead a .csv file, write in .csv files and append data from one .csv file to another .csv file. Classic Activities
Verify CSV FilesIdentify a value and appoint a status to it, analyze the data from one .csv file, process it and store it in another .csv file. Classic Activities
Compare CSV FilesCreate two new .csv files that store the similarities and the differences between two existing .csv files. Classic Activities
Table FunctionsMaximize the use of tables when creating an automation process. Classic Activities
Manage Multiple Excel FilesCreate a single report file from multiple report files that have the same structure. Classic Activities
Interpret Excel ResultsAnalyze the results from an Excel file and rearrange them in the correct order. Classic Activities
Manage Pivot TablesCreate and refresh a pivot table.Classic Activities
Manage Range SelectionSelect a range of rows and columns from an Excel file and inform the user about the selected range. Classic Activities
Read From Excel FilesRead information from a row or a columnClassic Activities
Manage Databases in ExcelRead a database, create a new database and filter it based on the results. Classic Activities
Compare Numeric ValuesCompare the numeric values from two different columns of an Excel file. Classic Activities
Sort Data in Excel FilesProcess an Excel table to display the data in ascending order without duplicates. Classic Activities
Filter and Delete Rows in Excel FilesDelete unwanted rows from an Excel file and filter the information by applying specific criteria. Classic Activities
Manipulate Range SelectionsCopy an entire sheet from one workbook to another and alter its content by deleting a range of rows. Classic Activities
Verify Excel Workbook DataAnalyze and verify stock, and inform the user about restocking needs Classic Activities
Read, Write, and Append Data in ExcelCopy ranges from a workbook, paste, and append them to another workbook. Workbook Activities
  • Tutorials

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.