# Filtering Data from a Spreadsheet

**URL:** <https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904>\
**Category:** Questions about Thunkable X\
**Created:** [January 4, 2022, 1:15am UTC](https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904 "2022-01-04T01:15:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Wolber](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/david_wolber/32/117458_2.png) [@David\_Wolber](https://community.thunkable.com/u/David_Wolber)\
**Post date:** [January 4, 2022, 1:15am UTC](https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904/1 "2022-01-04T01:15:27Z")

</div>

You can filter spreadsheet data in Thunkable, just not with a SQL “Select \* from Table where column=‘abc’.”

This [tutorial](https://draganddropcode.com/filter-spreadsheet-data/) shows how.

Process: set up a second spreadsheet. Place the data from the first spreadsheet into list variables. Loop through the lists, use an ‘if’ to filter, and add the data as a row in second sheet if it fits criteria. Map your DataViewerList/Grid to the second sheet with the filtered data. You can also use this scheme to display data in reverse order.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [January 4, 2022, 1:36am UTC](https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904/2 "2022-01-04T01:36:40Z")

</div>

Have you tried this?

> [@Filter Google sheet Data and show the result in a DVL](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841):
>
> Just wanted to share this trick to filter data in a DVL For Example, if I have a sheet with numbers and names then I need to add another column to be the condition to filter by [image] In this example I have a number column and a name column and the 3rd is the search column. In a separate sheet have the same two column headings [image] In the row immediately below the heading of the first column, enter this function =filter(Sheet1!A2:B7,Sheet1!A2:A7=Sheet1!C2) [image] Now in Thunkable, …

---

<div class="post-metadata">

**Author:** ![David\_Wolber](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/david_wolber/32/117458_2.png) [@David\_Wolber](https://community.thunkable.com/u/David_Wolber)\
**Post date:** [January 4, 2022, 2:32am UTC](https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904/3 "2022-01-04T02:32:22Z")

</div>

Hi and thanks for the sample, @muneer.

It looks like with Thunkable, currently, you can filter in the following ways:

1. Google sheets formulas (Muneer’s example)
2. Using Thunk code (loop, if) to copy some rows from original sheet to “filtered sheet” (my example)

Of course it would be great if Thunkable adds the capability to specify “Where” clause to fill DataViewerList/Grid

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [April 4, 2022, 2:32am UTC](https://community.thunkable.com/t/filtering-data-from-a-spreadsheet/1664904/4 "2022-04-04T02:32:50Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.