# Search entire airtable spreadsheet

**URL:** <https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [September 27, 2021, 1:59pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731 "2021-09-27T13:59:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![delee\_techdeveloper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/delee_techdeveloper/32/29616_2.png) [@delee\_techdeveloper](https://community.thunkable.com/u/delee_techdeveloper)\
**Post date:** [September 27, 2021, 1:59pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731/1 "2021-09-27T13:59:34Z")

</div>

![Screen Shot 2021-09-26 at 11.23.24 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/4/24a5cefe8e1ec4a0d69609f2b5c7bb20488b4ec4.jpeg)

What do I need to change for the search to search the entire Airtable spreadsheet

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [September 27, 2021, 2:46pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731/2 "2021-09-27T14:46:32Z")

</div>

Typically, a search would be done on a single column. Why do you need to search the entire spreadsheet?

---

<div class="post-metadata">

**Author:** ![delee\_techdeveloper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/delee_techdeveloper/32/29616_2.png) [@delee\_techdeveloper](https://community.thunkable.com/u/delee_techdeveloper)\
**Post date:** [September 27, 2021, 4:28pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731/3 "2021-09-27T16:28:26Z")

</div>

If I have one column that is keywords, one for the title, one for the address, or a key word in one of the descriptions … all the columns can be searched to bring up that item.

Yes, I can search all of the columns I just need to know how to do that correctly.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [September 27, 2021, 4:57pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731/4 "2021-09-27T16:57:43Z")

</div>

The only way I know how to do it is to search each column individually. But there may be a way that’s more efficient… I didn’t see anything in the Airtable API that suggested there is.

What I would probably do is to loop through the rows in the spreadsheet and get each [row object](https://docs.thunkable.com/data-sources#read). Then, check the row contents for the search key word(s).

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:15pm UTC](https://community.thunkable.com/t/search-entire-airtable-spreadsheet/1529731/5 "2024-11-08T13:15:04Z")

</div>