# Column Limit of Local DB?

**URL:** <https://community.thunkable.com/t/column-limit-of-local-db/438036>\
**Category:** Questions about Thunkable X\
**Created:** [January 31, 2020, 2:35pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036 "2020-01-31T14:35:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![junjoseph](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/junjoseph/32/42730_2.png) [@junjoseph](https://community.thunkable.com/u/junjoseph)\
**Post date:** [January 31, 2020, 2:35pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/1 "2020-01-31T14:35:48Z")

</div>

Hi!  
is there is an update of a column of the local DB that can be inserted up to 20 columns?

 ![Screenshot_2020-01-31_22-23-59](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/3/f3bf181748f9e67ab5abfdd94afdb3dba0ae1424.png)  
Thanks for your response 🙂

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [February 27, 2020, 5:38pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/2 "2020-02-27T17:38:18Z")

</div>

Hey @junjoseph,

I’m not aware of any limit (but perhaps you’ve discovered it)

Do you have an idea of how many column you’re going to need here?

---

<div class="post-metadata">

**Author:** ![junjoseph](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/junjoseph/32/42730_2.png) [@junjoseph](https://community.thunkable.com/u/junjoseph)\
**Post date:** [March 10, 2020, 9:40am UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/3 "2020-03-10T09:40:44Z")

</div>

I can only put 10 columns on it as maximum for row of data.

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [March 10, 2020, 11:16am UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/4 "2020-03-10T11:16:33Z")

</div>

Got it.

So, do you know how many columns you’ll need in your app?

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [March 10, 2020, 11:40am UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/5 "2020-03-10T11:40:39Z")

</div>

Hi, I easily added 35 columns and this was not the limit.

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [March 10, 2020, 12:28pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/6 "2020-03-10T12:28:46Z")

</div>

Any ideas why @junjoseph is finding it difficult to add more than 10?

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [March 10, 2020, 12:42pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/7 "2020-03-10T12:42:27Z")

</div>

The path will try to do this: first copy 50 columns of data from Excel to Local DB, and then create the desired number of columns in Local DB

---

<div class="post-metadata">

**Author:** ![junjoseph](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/junjoseph/32/42730_2.png) [@junjoseph](https://community.thunkable.com/u/junjoseph)\
**Post date:** [March 10, 2020, 3:25pm UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/8 "2020-03-10T15:25:24Z")

</div>

anyway @domhnallohanlon I decided to create a spreadsheets database for more data of customization and to fully customize for data. Thanks for help!

---

<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, 11:40am UTC](https://community.thunkable.com/t/column-limit-of-local-db/438036/9 "2024-11-08T11:40:28Z")

</div>


