# How to take filtered data to a Data viewer list from a spreadsheet?
**URL:** https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025
**Category:** Questions about Thunkable X
**Created:** [July 23, 2020, 4:17pm UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025 "2020-07-23T16:17:42Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@t.backbonef8m](https://community.thunkable.com/u/t.backbonef8m)
#### Post date: [July 23, 2020, 4:17pm UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/1 "2020-07-23T16:17:43Z")
I want to load data to Data viewer list from a spreadsheet as a data source, but I need to filter that database on a text contain in a cell, how can I do that.
Ex:
I have a table in google sheets named “Liquor”, table fields are “Name”, “ID”, “Occasions”.
Example data for Field “Occasions” are “parties, wedding, prom”
So what I need to do is get data of liquor which contains “parties” in the occasion field and display the on a Data viewer list
Any way to do this, couldn’t find blocks to create the logic
---
### Author:  [@doctorsof](https://community.thunkable.com/u/doctorsof)
#### Post date: [July 23, 2020, 10:47pm UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/2 "2020-07-23T22:47:22Z")
I think you can create new data viewer every different columns
---
### Author:  [@saramdl.gaunde021](https://community.thunkable.com/u/saramdl.gaunde021)
#### Post date: [July 24, 2020, 5:59am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/3 "2020-07-24T05:59:50Z")
this was what i really want. (you can search my questions) but, belive me basically it is not possible.
One way to do it is creating filtered google sheets (let say 8). there is only One datasource and 9 dataviewers (original one and each every one of them) And save row id to each data. if someone add new data then it will added to original one and One filtered sheet.
But there are some issue here. maybe it is not to easy to SORT. becuz maybe you have to give up delete function cuz row id acts weird and it ruins. (sorry for not the best explanation)
Otherwise, if you use script in google sheet or zapier to airtable then it might work.
Or you can use list viewer using Clone, but they appear so slow.
in conclusion, nevertheless of all my effort, i GAVE UP. and im doing in another way. (not using data viewer)
wish it helps. good luck to you.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [July 24, 2020, 11:05am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/4 "2020-07-24T11:05:03Z")
Unfortunately, the Data Source blocks don’t work, so I can’t show an example, but when the blocks work, it can be done like this:
1. Connect Google Sheet to Data Source
2. Load data from the Data Source in the List
3. Make a loop over the List and filter out the desired records
4. Show filtered entries in List Viewer
An example of working with Local DB is given below. When the blocks work for Google Sheet, you can quickly change this example and get filtering.
[https://x.thunkable.com/projects/5f1abd8c38a06b3c74457b62/project/properties/designer/](https://x.thunkable.com/projects/5f1abd8c38a06b3c74457b62/project/properties/designer/)
---
### Author:  [@t.backbonef8m](https://community.thunkable.com/u/t.backbonef8m)
#### Post date: [July 27, 2020, 1:54am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/5 "2020-07-27T01:54:27Z")
Hi,
Thank you, I’ve tried many ways and gave up many options in my app aleready 😃
---
### Author:  [@t.backbonef8m](https://community.thunkable.com/u/t.backbonef8m)
#### Post date: [July 27, 2020, 1:55am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/6 "2020-07-27T01:55:56Z")
Hi,
This can be done with list viewer, but not possible with data grids and data lists ☹
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [July 27, 2020, 7:43am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/7 "2020-07-27T07:43:55Z")
Hi,
You are mistaken. The Data Grid and Data List components can display filtered records, but this happens crookedly because of the DataSource’s performance curve.
scrGoogleSheetFilteredRecords in [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/)
---
### Author:  [@saramdl.gaunde021](https://community.thunkable.com/u/saramdl.gaunde021)
#### Post date: [October 7, 2020, 2:32pm UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/8 "2020-10-07T14:32:04Z")
is the name of screen is “scrGoogleSheetFilteredRecords”? becuz i cannot find now.
how did you filter?
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [October 8, 2020, 5:43am UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/9 "2020-10-08T05:43:26Z")
see scrLocalDBFilteredRecords
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:23pm UTC](https://community.thunkable.com/t/how-to-take-filtered-data-to-a-data-viewer-list-from-a-spreadsheet/698025/10 "2024-11-08T12:23:32Z")