# What's the difference between Sheets and Tables?

**URL:** <https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334>\
**Category:** Community Resources\
**Created:** [December 27, 2020, 5:20am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334 "2020-12-27T05:20:32Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Zonez\_SF](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zonez_sf/32/26294_2.png) [@Zonez\_SF](https://community.glideapps.com/u/Zonez_SF)\
**Post date:** [May 18, 2021, 4:41pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/22 "2021-05-18T16:41:59Z")

</div>

Thanks for the info @Darren_Murphy . But I thought there was a data export function somewhere? Any thoughts or opinions on it?

---

<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:** [May 18, 2021, 4:48pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/23 "2021-05-18T16:48:51Z")

</div>

Yes, there is.  
I’ve not used it, but I’d expect that it probably just gives you a full dump of every table.

---

<div class="post-metadata">

**Author:** ![Zonez\_SF](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zonez_sf/32/26294_2.png) [@Zonez\_SF](https://community.glideapps.com/u/Zonez_SF)\
**Post date:** [May 18, 2021, 4:53pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/24 "2021-05-18T16:53:08Z")

</div>

Thanks Darren. I see. A full dump but unorganized vs a Google sheet where it’s all set up exactly how you like it?

I’ll try and play around with that feature later this week myself as I’m trying to use a single Google sheet as database to power multiple front ends with Glide being one of them. But based on some of the user experiences I’ve read, am also thinking to might be good to just start with Glide tables for performance. Thanks again

---

<div class="post-metadata">

**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\
**Post date:** [May 18, 2021, 4:53pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/25 "2021-05-18T16:53:18Z")

</div>

Jumping in, I’ve used the export, you get an email with all data in Excel.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0af65cb64cdc746bfa7f3a396755269294ea925a.jpeg)

---

<div class="post-metadata">

**Author:** ![Zonez\_SF](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zonez_sf/32/26294_2.png) [@Zonez\_SF](https://community.glideapps.com/u/Zonez_SF)\
**Post date:** [May 18, 2021, 4:57pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/26 "2021-05-18T16:57:31Z")

</div>

Thanks @Cisco_Muratalla ! But obviously the images wouldn’t be there unless they were pointing to a URL somewhere?

---

<div class="post-metadata">

**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\
**Post date:** [May 18, 2021, 6:10pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/27 "2021-05-18T18:10:10Z")

</div>

Sorry I don’t recall, not sure how or if the image(s) came over.

---

<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:** [May 18, 2021, 11:09pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/28 "2021-05-18T23:09:22Z")

</div>

I believe every image you upload will be stored to Glide’s firebase and show up as a link so in the exported Sheet it would show up as a link.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 11:33am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/29 "2021-09-10T11:33:08Z")

</div>

Is it possible to stack a Glide tables with data?  
do row in Glide tables count as rows till the limit of 25,000  
for pro?  
If I link a Glide table to several apps, the rows are counted in all apps or just in the original app?  
Is there a way.  
When exporting data is the data from Glide tables exported as well?  
I have a table with 5K rows I need sheared in several apps. Not sure how to do that.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [September 10, 2021, 11:55am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/30 "2021-09-10T11:55:35Z")

</div>

1. I’m not sure what you mean

2. All rows used in your app in anyway count towards your row count. (The 25,000 rows is a suggestion not a hard limit. If your app is not too complex you should be able to exceed that comfortably)

3. I believe glide tables connected to several apps will add row counts to each one respectively. (Haven’t tried)

4. No, exporting app data will not export the data from glide tables. (There’s a few posts in this forum about using a robot 🤖 w/ glide tables to do that)

5. If you need to share a table between apps then you could do that with a glide table.

I hope this helps!

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 11:58am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/31 "2021-09-10T11:58:51Z")

</div>

1. I have a table in GS with 5K rows. Its for products and their nutrition values/ I nees to use it in more than one app. I was considering whether I use it from GS as is or convert to a Glide Table if there were any pros or cons to each

---

<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:** [September 10, 2021, 12:02pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/32 "2021-09-10T12:02:09Z")

</div>

> [@Lin\_Altshuler](#):
>
> I was considering whether I use it from GS as is or convert to a Glide Table if there were any pros or cons to each

Glide Tables will enhance your app performance since the data does not need to be synced back and forth. However you can’t mass delete or mass upload yet.

If you have integrations to update the data from outside, let’s say a Zapier or Integromat scenario then Glide Tables is a no go.

> [@Lin\_Altshuler](#):
>
> When exporting data is the data from Glide tables exported as well?

It does get exported, alongside all user-specific columns @Eric_Penn.

> [@Eric\_Penn](#):
>
> If you need to share a table between apps then you could do that with a glide table.

Adding to this, only normal columns can be synced. Computed columns can’t be shared.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [September 10, 2021, 12:04pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/33 "2021-09-10T12:04:16Z")

</div>

One thing I’ve learned from Glide/ app building is that everything is possible.

Glide tables are your fastest option so I would use that as my first choice.

You could use a webhook with zapier or integromat and write the data to multiple GSheets at once in all of your apps (this is a little clunky and will be much much slower than synching with glide tables)

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 12:05pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/34 "2021-09-10T12:05:20Z")

</div>

The 5K Table is a read only table.  
So I dont have any option to upload all the data to the Glide table?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [September 10, 2021, 12:07pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/35 "2021-09-10T12:07:03Z")

</div>

Thank you @ThinhDinh for pointing out that the data from glide tables DOES in fact get exported. And apologies to @Lin_Altshuler for the incorrect information.

I love learning from the experts here!

---

<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:** [September 10, 2021, 12:23pm UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/36 "2021-09-10T12:23:22Z")

</div>

At the moment it’s a no, you can’t mass upload a CSV or something like that yet. This might change in near future though.

@Eric_Penn I think this must be noted that computed columns won’t get exported 😉

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [October 24, 2021, 8:27am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/37 "2021-10-24T08:27:26Z")

</div>

@Darren_Murphy What is the best way to move Sheet data to a Glide Table?

---

<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:** [October 24, 2021, 8:33am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/38 "2021-10-24T08:33:09Z")

</div>

Two options that I’m aware of:

- This one from @Manu.n

> [@Import Data From Excel & Sheets into Glide Table](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/18):
>
> Hello, Failing to have an import function. I used a fairly simple method to import 3 tables of around 400 rows each, it’s not ideal, but it’s better than editing everything. For simplicity You have a Sheet Source table and a Glide Destination table. Add a column to your Sheet Source “Copy ok” of type boolean. Create a List style tab with the Sheet Source as the source. And as filter “Copy ok is not 1” Then use a custom action ADD row, with as Sheet “Glide Destination” then mat…

- And this one from @Krivo

> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go. 
> 
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \<a href="https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/…

The first option is a lot easier to implement and would probably be my preferred choice if the dataset isn’t too large. But for very large datasets then option 2 may be better.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [October 24, 2021, 8:53am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/39 "2021-10-24T08:53:20Z")

</div>

@Darren_Murphy Thank you!  
What is the best way to link a Glide Table Column to Google Sheet?

---

<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:** [October 24, 2021, 8:56am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/40 "2021-10-24T08:56:08Z")

</div>

Not sure I fully understand the question, Ralf.

Can you describe your use case?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [October 24, 2021, 9:01am UTC](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334/41 "2021-10-24T09:01:46Z")

</div>

I am planning to move the members register to a Glide Table. I need the column Members-ID in Google Sheets for various calculations.

[Previous page](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334.md?page=1)

[Next page](https://community.glideapps.com/t/whats-the-difference-between-sheets-and-tables/20334.md?page=3)
