# \[Solved\] Thunkable Data Source not Working Properly **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** data-source, google-sheets\ **Created:** [December 15, 2023, 6:45pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750 "2023-12-15T18:45:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![arshmaan.ali24975d1y](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@arshmaan.ali24975d1y](https://community.thunkable.com/u/arshmaan.ali24975d1y)\ **Post date:** [December 15, 2023, 6:45pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/1 "2023-12-15T18:45:37Z")
I have just created a new project and add a google sheet data source. I added a data viewer list and select my google sheet as data source. The problem is I can’t select table in data viewer properties. I can’t select title property and subtitle property. Message showing is “Pick a data source first to fill in the data!”. Please help me in this regard. ![Screenshot1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/4/04fc517f6a954d29b64bf96ee1402a0b358e50d8.png) ---
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [December 16, 2023, 1:11am UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/2 "2023-12-16T01:11:37Z")
Can you show us what the Google Sheet looks like? ---
**Author:** ![arshmaan.ali24975d1y](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@arshmaan.ali24975d1y](https://community.thunkable.com/u/arshmaan.ali24975d1y)\ **Post date:** [December 16, 2023, 2:58pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/3 "2023-12-16T14:58:01Z")
My Google Sheet Looks Like this: Sheet # 1 (SearchName) ![sheet1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a0c1475d6e625503079c3bb8205d2559075b307b.png) Sheet # 2 (SearchMonth) ![sheet2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/9/69ba148f7ee72f42f0a5f8f1fcf65460a0c216de.png) Sheet # 3 (Dec-2023) ![sheet3](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/7/77273a8b601a61c6f277cc920e75e17429a359f6.png) I have 24 more sheets just like Dec-2023 Sheet (Dec-2023 to Dec-2025) and one hidden sheet named Lists. ---
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [December 16, 2023, 5:08pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/4 "2023-12-16T17:08:31Z")
Try going back to the Google Sheet in Datasources and click Sync with source at the bottom of the screen to see if that makes any difference. ---
**Author:** ![arshmaan.ali24975d1y](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@arshmaan.ali24975d1y](https://community.thunkable.com/u/arshmaan.ali24975d1y)\ **Post date:** [December 16, 2023, 6:08pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/5 "2023-12-16T18:08:12Z")
There is no option in Datasources (Sync with source) at the bottom or anywhere on the screen. ---
**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\ **Post date:** [December 17, 2023, 2:01am UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/6 "2023-12-17T02:01:24Z")
![2023-12-16 21 57 57](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/b/7bd47e751faca942af1e539d0d3f3b7f3761f246.png) I would suggest deleting the source and recreating it to see what happens. ---
**Author:** ![arshmaan.ali24975d1y](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@arshmaan.ali24975d1y](https://community.thunkable.com/u/arshmaan.ali24975d1y)\ **Post date:** [December 17, 2023, 8:10am UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/7 "2023-12-17T08:10:23Z")
Problem is solved. I opened the .xls file in Google sheets and save as the file as Google sheet. The .xls or .xlsx files are not working we have to save the file as Google sheet. Google sheet as data source now working perfectly. Thanks Steve for your response. ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [December 18, 2023, 7:32pm UTC](https://community.thunkable.com/t/solved-thunkable-data-source-not-working-properly/2751750/8 "2023-12-18T19:32:19Z")