# Google sheet vs glide table

**URL:** <https://community.glideapps.com/t/google-sheet-vs-glide-table/20787>\
**Category:** Ask for Help\
**Created:** [January 6, 2021, 8:51am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787 "2021-01-06T08:51:16Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 8:51am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/1 "2021-01-06T08:51:17Z")

</div>

My first app is nearly production ready. I have one sheet where I think that I will reach the 25000 rows limit quite fast.

Is it right that a glide table doesn’t have this limit?

Can I convert a sheet to a glide table?

I think about to only left the profile sheet as normal sheet an convert all other sheets to glide tables. Is this a good practice?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 6, 2021, 9:09am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/2 "2021-01-06T09:09:16Z")

</div>

Probably worth your time having a read of this topic…

> [@Glide table - full app building summary](https://community.glideapps.com/t/glide-table-full-app-building-summary/16695):
>
> Hi Gliders, So, for the launch of the new glide tables, I’ve decided to take a challenge and build a complete full complex app based on glide abilities only, i.e. not using the GS abilities at all and in fact, if possible I could have built the app without connecting a GS altogether. According to the glide team this will be possible in the future. The app I decided to build was an app that manages, tracks and measures the working time for customer per customer and project. I chose this due to …

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 9:19am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/3 "2021-01-06T09:19:09Z")

</div>

Thank you for your answer.  
I think i have to try it.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 6, 2021, 9:20am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/4 "2021-01-06T09:20:19Z")

</div>

I really want the ability to batch convert to Glide Tables but seems like it’s nowhere near.

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 9:26am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/5 "2021-01-06T09:26:16Z")

</div>

In my case the sheets are nearly empty. But I think when I create a glide table I have to re design the whole app to get all the references pointing to the new table. Right?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 6, 2021, 9:28am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/6 "2021-01-06T09:28:17Z")

</div>

Yes that’s true. Also if you have any rows in the old sheet you would have to manually enter them using add row/form.

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 9:33am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/7 "2021-01-06T09:33:54Z")

</div>

But i have no row limit. Right?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 6, 2021, 9:48am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/8 "2021-01-06T09:48:25Z")

</div>

yeah, that would be sweet!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 6, 2021, 9:53am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/9 "2021-01-06T09:53:04Z")

</div>

> [@ThinhDinh](#):
>
> Yes that’s true. Also if you have any rows in the old sheet you would have to manually enter them using add row/form.

heh… I just had a crazy thought…  
what you _might_ be able to do is build an external service that would fetch the data from the Google Spreadsheet, and then feed it into Glide via an app in a browser view - a little bit like screen scraping in reverse 😁

Now, _THAT_ would be a fun challenge 🤣 🤣

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 9:57am UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/10 "2021-01-06T09:57:58Z")

</div>

If the glide app make a post request to add the data it would be easy. You just need the auth key.  
A glide API would be perfect.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 6, 2021, 1:19pm UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/11 "2021-01-06T13:19:33Z")

</div>

> [@Jacktools\_Net](#):
>
> But i have no row limit. Right?

In theory, no there is no hard row limit that is currently enforced in google sheets or glide tables, but you have to consider the amount of data that’s synced between google sheets \> glide servers \> user’s device. Glide tables won’t make any difference for the sync between glide servers and the device, but it does remove the bottleneck between glide servers and google sheets. A lot of data means a lot to sync. Regardless, the sync between glide and google should be transparent to the user as long as there are no formulas in the Google sheet and all calculations are performed using glide functionality.

If you are using Row Owners, you can reduce the amount of data that’s synced to the user’s device and not overload the user with too much data. This is what truly provides you with the theoretical “no row limit”.

I recommend reading through this thread.

> [@Extremely slow load time for 41k GDE rows](https://community.glideapps.com/t/extremely-slow-load-time-for-41k-gde-rows/20739):
>
> My app’s URL: [www.trainwithmit.com](http://www.trainwithmit.com) Any help would be GREATLY appreciated. I have built a marathon club app with about 366 active users logging 5 runs per week. I’m using the GDE for this information and the app currently takes almost a minute to load a users recent workout entries. Is there ANY way to speed this up?

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 4:21pm UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/12 "2021-01-06T16:21:30Z")

</div>

Hmmm difficult decision to make. My data will be created to 100% in the app. I have no sheet magic. I did all in the gde with relations, lookups and so on. The only sheet I need in google is the profile sheet because I connected it with integromat.  
A kind of lazy loding would be nice. In my case the sale point options are displayed with an inline list with selapoint row id as filter value. It woulb be perfect if glide loads this data when it have to display them.

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [January 6, 2021, 5:42pm UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/13 "2021-01-06T17:42:09Z")

</div>

I just played around with a glide table and the gde. Looks like you could add, edit end remove data inside the gde.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 6, 2021, 10:34pm UTC](https://community.glideapps.com/t/google-sheet-vs-glide-table/20787/14 "2021-01-06T22:34:18Z")

</div>

Yeah, you can do that with single cells, but with migrating multiple rows of data it still doesn’t work. I anticipate a CSV upload some time in the future.
