# Saving a local DB?
**URL:** https://community.thunkable.com/t/saving-a-local-db/879689
**Category:** Questions about Thunkable X
**Created:** [October 6, 2020, 8:47pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689 "2020-10-06T20:47:51Z")
**Posts on this page:** 16
**Page:** 2
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [October 16, 2020, 7:29pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/21 "2020-10-16T19:29:02Z")
Your solution sound fine , but exactly where do you keep this local data that you will update when online?
Is it, local DB or Variables or Can fire base keep data offline?
Here is where in need clarity,
Thanks
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [October 16, 2020, 7:40pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/22 "2020-10-16T19:40:20Z")
> [@drted](#):
>
> strategy with a Google sheet data source for permanent storage and refresh locally when online or on demand.
this is my approach when I want to save data primarily on a local device but have a backup just incase!
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [October 17, 2020, 10:30am UTC](https://community.thunkable.com/t/saving-a-local-db/879689/23 "2020-10-17T10:30:30Z")
Please forgive my lack of comprehension, are you saying that I can save data on a google sheet locally on my device?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 17, 2020, 3:06pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/24 "2020-10-17T15:06:24Z")
> [@general](#):
>
> Please forgive my lack of comprehension, are you saying that I can save data on a google sheet locally on my device?
@general No. Rather that you have the most up-to-date data in a Google Sheet and any time the app is online, it downloads that data. Otherwise, it uses the local data source within the app.
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [October 20, 2020, 4:30am UTC](https://community.thunkable.com/t/saving-a-local-db/879689/25 "2020-10-20T04:30:57Z")
Understood but to what does it dowload data to?
1. Variable?
2. List
3. Local db?
4. Local CSV?
Which of these do you think can handle a lot of data seamlessly?
---
### Author:  [@tbcguytb](https://community.thunkable.com/u/tbcguytb)
#### Post date: [March 19, 2021, 5:20pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/26 "2021-03-19T17:20:07Z")
> [@appspark.uk](#):
>
> You could _even_ use the Web API to email a copy of the table perhaps as XML or **even CSV** , a bit complex, but do-able.
I can’t seem to find any answers on how to do this. I can send a csv but it exports in columns, not rows as it appears that is the only way to access the data…by columns. so when i get the data, it is difficult to deal with. For me, I can figure it out…but most of the people getting my data want it in a readable format right off the hop
---
### Author:  [@webmasterjocum](https://community.thunkable.com/u/webmasterjocum)
#### Post date: [June 3, 2021, 2:57pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/27 "2021-06-03T14:57:22Z")
I need that clarification too 😉
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 3, 2021, 4:24pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/28 "2021-06-03T16:24:58Z")
This is a long topic. Can you state your actual question?
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [June 13, 2021, 12:13pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/29 "2021-06-13T12:13:58Z")
how to save data offline in thunkable x
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [June 13, 2021, 1:02pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/30 "2021-06-13T13:02:49Z")
Save it to Local DB or to `stored variable`.
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [June 13, 2021, 2:11pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/31 "2021-06-13T14:11:06Z")
apparently its not possible to save data to the local DB
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [June 13, 2021, 2:20pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/32 "2021-06-13T14:20:37Z")
i have a quiz app, almost 5000 records for primary level school. i am currently storing them in the local db. which works fine because i preload them during app design(copy paste). but during app run time any new data stored in the local db , is erased when the session is off, so if you restart the app the data is not there.
i was advised to use variable, but still trying to figure out how (local db is so convenient but with that shortcoming)
also i need to work offline, so airtable, google docs are not an option
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [June 13, 2021, 3:05pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/33 "2021-06-13T15:05:07Z")
Apparently your mistaken and assuming the old Local DB be the local storage is persistent.
---
### Author:  [@general](https://community.thunkable.com/u/general)
#### Post date: [June 13, 2021, 3:44pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/34 "2021-06-13T15:44:06Z")
your right, but what is mean is if during app design you enter data in the local db, once the user intalls the app, that data is intact. i have a fully fuctional quiz app in thunkable, with over 500 questions i had preloaded. but whenever i need to add new questions, i am forced to push an update, for the user to get the new questions. i had also wanted the user to be able to add their own custom questions
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [June 13, 2021, 3:51pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/35 "2021-06-13T15:51:57Z")
You can always create an **update screen** where you connect to, for example, a Google sheet and copy what’s in it to the local DB. This way you avoid pushing updates.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:22pm UTC](https://community.thunkable.com/t/saving-a-local-db/879689/36 "2024-11-08T12:22:00Z")
[Previous page](https://community.thunkable.com/t/saving-a-local-db/879689.md?page=1)