# How to add a table to a local DB?

**URL:** <https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871>\
**Category:** Questions about Thunkable X\
**Created:** [June 3, 2021, 5:03pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871 "2021-06-03T17:03:59Z")\
**Posts on this page:** 6\
**Page:** 1

<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:** [June 3, 2021, 5:03pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/1 "2021-06-03T17:03:59Z")

</div>

I’ve seen projects where the local DB has multiple tables. But I can’t figure out how to add another table besides the default one. Below is a screenshot of a project someone else made followed by one of my projects. You can see there is only one tab in the second screenshot and no visible way to add another tab/table. Any tips?

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/8/f8d1d8866dd3f3f652cfdbd07b8a182aba1306e1.png)

vs.

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/0/e0dbcf078612f3eb76786f07b97a2fb31e3f081e.png)

---

<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:** [June 3, 2021, 7:43pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/2 "2021-06-03T19:43:28Z")

</div>

I know. I used a trick but quite cumbersome.

I attach a Google sheet with all required tables then I remove the Google sheet connection. Once the connection is deleted, Thunkable will convert it to local dB with all the tables and column names in your original Google sheet.

The drawback is that you lose the content and you get the standard text injected by Thunkable.

---

<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:** [June 3, 2021, 9:09pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/3 "2021-06-03T21:09:50Z")

</div>

Thanks, @muneer. Good to know.

There hasn’t been any movement on this feature request in the past 6+ months:

> <https://github.com/thunkable/thunkable-issues/issues/675>
>
> When creating a new data source you have the choice of "Create your own table" /… "Airtable" / "Google Sheets".
> 
> Selecting "Create your own table" creates a local data base, and when you click on it there is one "Table1" inside:
> 
> !\[grafik\](https://user-images.githubusercontent.com/7669660/94434370-fb240d00-0199-11eb-835a-b81de7111267.png)
> 
> 
> I request a way (button? block?) to create \*\*more tables\*\* inside a local data base. And maybe an option to rename them.

---

<div class="post-metadata">

**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\
**Post date:** [June 4, 2021, 3:35am UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/4 "2021-06-04T03:35:17Z")

</div>

i found out about that “trick” inadvertenly. I was working on an app that was based on google sheet and i made a copy of it for backup. when i opened the backup, the sheet was gone but the tables were still there although the data source had changed to local data.  
i was a little disappointed because the live spreadsheet formulas i had depended on were not there anymore!

---

<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:** [June 4, 2021, 5:08pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/5 "2021-06-04T17:08:48Z")

</div>

> [@manyone](#):
>
> i was a little disappointed because the live spreadsheet formulas i had depended on were not there anymore!

I know the feeling. I got disappointed too at first but then I decided to turn the disappointment to an opportunity. It’s a good tool to recreate the tables all at once, if you think about it.

---

<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:22pm UTC](https://community.thunkable.com/t/how-to-add-a-table-to-a-local-db/1323871/6 "2024-11-08T13:22:09Z")

</div>


