How to Filter Data in Excel Using UiPath: A Step-by-Step Guide
Filtering data is a very popular functionality in Excel employed for analyzing large datasets. Although Excel already possesses in-built filtering options, this process can be automated using UiPath thus providing you with the benefit of taking up fewer steps and making it easier to complete. This blog post will guide you on how to create a filter in Excel using UiPath, as well as removing a filter and also the application of such a UIPath filter on a DataTable. No matter what your experience level with UiPath is, these tips will let you automate the data processing workflows you work on better.
1 How to Filter Data in Excel Using UiPath
It is a very easy process to filter data In Excel with UiPath and it consists of the simple flow of Excel Application Scope and Filter Data Table. Here lies the summary of the whole filtering procedure:
Step 1: Open Excel Application
- Take advantage of the Excel Application Scope activity to access the Excel workbook where the data under study is stored.
- Concern the Excel Application Scope to designate the path of your Excel file.
Step 2: Utilize Read Range Activity
- Inside the Excel Application Scope, you need to insert the Read Range activity and then drop it from the Activities panel to the Scope to read the data from your worksheet.
- You must make sure that the “Range” property is left empty so that it would allow you to read the full worksheet, and choose to display the data in the DataTable format as well.
Step 3: Apply the Filter Data Table Activity
- With the DataTable at your disposal, employ theFilter Data Tableactivity to extract specific rows that meet your needs.
- TheFilter Data Tableactivity gives you the opportunity to choose the columns to be filtered and set up the filter criteria. For instance:
- Sorting based on value (e.g., a value higher or lower than a specific number).
- Sorting by text (e.g., contains or starts with a specified text).
For instance, you can choose the option to only show rows in the column where sales data is found if the sales amount is more than $500.

Step 4: Write the Filtered Data to Excel
- After you have filtered the data, you can use the Write Range activity to transfer the filtered data either to the existing worksheet or to a newly created one.
2. How to Remove Filter in Excel Using UiPath
Filters in a spreadsheet are not only crucial at times, but are also the reversal ones may be needed for the managing process tasks such as one-off changes and the file necessities be default for checking the untouched version. Here’s how to remove the filters in Excel by using UiPath: kuid exploratory comments.
Step 1: Open Excel Application
- Initiate the process by getting the Excel file opened in the Excel Application Scope activity.
Step 2: Use the Clear Filters Action
- There is an easy way of clearing filters from your Excel sheet, and it is the action, theClear Filtersaction from theExcel Application Scope,that you can use. Besides, the tool does away with each filter of the worksheet that has been set.
Otherwise, in the case you have used filters manually (for instance, via the AutoFilter feature), you can delete them using Green Automation capabilities by programming the Excel VBA activity to run a macro that does that. The VBA code to clear it goes like this:
Step 2: Use the Filter Data Table Activity
- Include theFilter Data Tableaction in your process flow.
- In theFilter Data Tablesettings, clarify the following:
- Input DataTable: The DataTable which you will filter.
- Output DataTable: A fresh DataTable to hold the filtered results.
- Filters: Specify the filter conditions (e.g., filter by column values, numeric conditions, or text patterns) if any.
For example, if you have a DataTable of employee records you can choose the salary column and put in a condition named salary more than $50,000 to show only those who have salary above $50,000.
- The DataTable can be filtered afterward, and you may then either Output DataTable activity shows the filtered data in UiPath or Write Range activity will write it back to an Excel file.
4. Conclusion
Using Excel as a tool to automate tasks like filtering data is a strong use case for UiPath. Whether you are filtering the data directly in an Excel sheet through the Filter Data Table activity, removing the filters, or working with in-memory DataTables, UiPath provides the opportunity for efficient processing of the huge volumes of data, without any effort at all. The business process of a company that is not only saving time but also cutting out errors that often arise when manual data processing is involved.
By implementing the above steps, you will be able to smoothly perform filtering of data among other operations and also enhance productivity in different business processes.
Key Takeaways:
- Excel application Scope can be used to deal with Excel files.
- TheFilter Data Tableactivity will be useful for ensuring that the DataTables only contain the necessary information according to the set conditions.
- TheClear Filtersaction along with a simple VBA macro should be executed to clear filters in Excel.
- With UiPath it is like a drag-and-drop process that you use to filter and manipulate data thus you save time and increase productivity.
Get started with UiPath to automate your Excel filtering tasks and see how much time you could gain!
Lucille
An effort offers a chance to learn, and a result provides valuable lessons.
