What's the difference between Sheets and Tables?

[Zonez_SF]

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

[Darren_Murphy]

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

[Zonez_SF]

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

[Cisco_Muratalla]

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

[Zonez_SF]

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

[Cisco_Muratalla]

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

[ThinhDinh]

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.

[Lin_Altshuler]

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.

[Eric_Penn]

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!

[Lin_Altshuler]

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

[ThinhDinh]

@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.

[Eric_Penn]

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)

[Lin_Altshuler]

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

[Eric_Penn]

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!

[ThinhDinh]

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

[Ralf]

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

[Darren_Murphy]

Two options that I’m aware of:

• This one from @Manu.n

Import Data From Excel & Sheets into Glide Table

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

Importing data to Glide by use of robot (RPA)

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.

[Ralf]

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

[Darren_Murphy]

Not sure I fully understand the question, Ralf.

Can you describe your use case?

[Ralf]

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