# Copy data from Google Sheet to Local Table

**URL:** <https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995>\
**Category:** Questions about Thunkable X\
**Created:** [May 26, 2024, 10:54am UTC](https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995 "2024-05-26T10:54:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tiny\_apps](https://avatars.discourse-cdn.com/v4/letter/t/3d9bf3/32.png) [@tiny\_apps](https://community.thunkable.com/u/tiny_apps)\
**Post date:** [May 26, 2024, 10:54am UTC](https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995/1 "2024-05-26T10:54:29Z")

</div>

This seems to be simple but I am having difficulty to understand concept:

I have a google sheet with 100 rows and I want to copy only certain row numbers to a local table e.g. Row numbers 5,10,12,28.  
Can someone please provide me example block/project. I am not able to figure it out.

Thank you

---

<div class="post-metadata">

**Author:** ![pacecode](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/pacecode/32/209017_2.png) [@pacecode](https://community.thunkable.com/u/pacecode)\
**Post date:** [May 27, 2024, 12:55am UTC](https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995/2 "2024-05-27T00:55:46Z")

</div>

You can Use Count with i Block to do so, add an IF condition to the Row IDs you want

---

<div class="post-metadata">

**Author:** ![marion.dorsett](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/marion.dorsett/32/175129_2.png) [@marion.dorsett](https://community.thunkable.com/u/marion.dorsett)\
**Post date:** [May 27, 2024, 6:46pm UTC](https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995/3 "2024-05-27T18:46:20Z")

</div>

@tiny_apps I assume the Google sheet is defined as a data source. With that in mind this setup appears to have worked.

 ![import-rows-to-local-00](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f7db7d4bb9917dfbe8f0836d9c6fece365f85d7.png)  
 ![import-rows-to-local-02](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/7/874f27f6307c773e8d54e144a9fe4825ca765eda.png)  
 ![import-rows-to-local-03](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/5/f5c3571e09ee470713386e1b5b2aa4ffc86879cd.png)  
 ![import-rows-to-local-04](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cf86e62df24226223d054837f4af0c4c11a82395.png)

---

<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:** [August 25, 2024, 6:46pm UTC](https://community.thunkable.com/t/copy-data-from-google-sheet-to-local-table/3024995/4 "2024-08-25T18:46:50Z")

</div>

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