# Filtering Excel

**URL:** <https://forum.uipath.com/t/filtering-excel/96903>\
**Category:** Help\
**Tags:** excel, activities\
**Created:** [February 21, 2019, 7:31am UTC](https://forum.uipath.com/t/filtering-excel/96903 "2019-02-21T07:31:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anandhu](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anandhu/32/155510_2.png) [@Anandhu](https://forum.uipath.com/u/Anandhu)\
**Post date:** [February 21, 2019, 7:31am UTC](https://forum.uipath.com/t/filtering-excel/96903/1 "2019-02-21T07:31:39Z")

</div>

Hi,

 ![image](https://global.discourse-cdn.com/uipath/original/3X/4/7/47fd1295caef3b1a37f86df4dab45890d43e11f9.png)

I have the above excel sheet **with a filter in the range D9:D13.**  
How can i operate that filter thorough UiPath using excel application scope?

Thank you!

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [February 21, 2019, 8:10am UTC](https://forum.uipath.com/t/filtering-excel/96903/2 "2019-02-21T08:10:44Z")

</div>

If data is in a table, you can use the following activity -

> **[Activities - Filter Table](https://docs.uipath.com/activities/other/latest/productivity/excel-filter-table)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

Please refer the below post -

> [@Filter and update the excel data](https://forum.uipath.com/t/filter-and-update-the-excel-data/67889):
>
> I am having excel sheet with the following data [excel%20data] . My requirement is I want filter the column “Dept No” and extract the data and print each"Emp No" based on filtered data of “Dept No” and update the status(Yes/No) to the “Processed(Yes/No)” column at the same time. Thank you in advance.

Regards,  
Karthik Byggari

---

<div class="post-metadata">

**Author:** ![Anandhu](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anandhu/32/155510_2.png) [@Anandhu](https://forum.uipath.com/u/Anandhu)\
**Post date:** [February 21, 2019, 8:38am UTC](https://forum.uipath.com/t/filtering-excel/96903/3 "2019-02-21T08:38:29Z")

</div>

Hi Kartik,  
My data is not in the table, I have the filter already in the EXCEL FILE, Bot should be a designed to access it.

---

<div class="post-metadata">

**Author:** ![Divyashreem](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/divyashreem/32/464042_2.png) [@Divyashreem](https://forum.uipath.com/u/Divyashreem)\
**Post date:** [February 21, 2019, 12:29pm UTC](https://forum.uipath.com/t/filtering-excel/96903/4 "2019-02-21T12:29:56Z")

</div>

you can use Send hot key activities.