Import Data From Excel & Sheets into Glide Table

If they want us to rely more on Glide Sheets this should be in the fore front of development. They are quicker and cleaner. I would like this greatly.

I’m developing an e-commerce with over 30,000 products, and the only way I can bypass the 25,000 row limit is through glide tables.
Being able to Bulk Copy / Paste a whole table would be really handy.

3 Likes

YES! Let’s upvote this!!!

3 Likes

Probably most needed feature👍

2 Likes

With this it would be nice to have something similar to what Power Bi has where the data is linked like it is now but we pull it into glide sheets as a bulk. So if the excel sheet or google sheet has values that get updated it will still reflect in the glide tables. That would probably be the easiest way to implement it for Glide since they already have the majority of that system worked out.

This should also include a “convert to glide sheets” option. Copying or importing into a glide sheet is nice, but I’d rather not have to rebuild all of the relations and lookups, which are pretty complex in my app

5 Likes

I can’t find any decent info on glide tables. Has the tables project been abandoned?
There has to be a way to either copy and paste data onto the table or ideally link the table to a google sheet so that it updates automatically. Unlimited data would open up a whole new world of possibilities for Glide Apps. Please give us more feedback for glide tables.

Far from it, as I understand.

Unfortunately, not yet. But there have been hints of it being in the pipeline.

There is a whole thread on Glide Tables - I assume you’ve seen that?

1 Like

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.
  1. Add a column to your Sheet Source “Copy ok” of type boolean.

  2. Create a List style tab with the Sheet Source as the source.
    And as filter “Copy ok is not 1”

  3. Then use a custom action

  • ADD row, with as Sheet “Glide Destination” then match the fields.
  • Set Columns “This Item” row : “Copy Ok” column with the value 1.

So when you click on an item in the list you copy.

The “Copy Ok” column is just to avoid duplicates.

Okay, you probably need a spare mouse with a large number of copies !!

But, I agree with you, this is an important function to transfer from Google Sheet to Glide Sheet.

(sorry for my english)

16 Likes

Haven’t yet. Thanks, I’ll check it out.:ok_hand::+1:

Wow, sounds complex, but if it works would still be worth learning your method. Are you able to show a video of how you do that? Would be much appreciated.:pray:

Voilà une petite vidéo pour l’exemple.

Vidéo

17 Likes

WOW!!! That’s Awesome. You’ve showed me many new tricks now. I will definitely use this. Thanks so much​:+1::ok_hand::call_me_hand:

1 Like

Great tip @Manu.n !

It is another use case where a Set Column action can be more useful if this is able to use a multiple relation instead of only simple one!

But still I don’t know why it is impossible!!

Saludos

thank you @gvalero

yes that’s what I did for my application, but I wanted to keep it simple for the example.

1 Like

WOW, Thanks

1 Like

Thank you for sharing this

1 Like

Thank you, this is awesome.

2 Likes

Hey @Manu.n thanks for sharing the video. But unfortunately it is not accessible/ playing for me. would it be possible to re-share the video? thanks in advance :slight_smile:

(post deleted by author)