Import Data From Excel & Sheets into Glide Table

[Jeremy_P]

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

[ToOFa_Apps]

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.

[Darren_Murphy]

@ToOFa_Apps

I can’t find any decent info on glide tables. Has the tables project been abandoned?

Far from it, as I understand.

@ToOFa_Apps

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.

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?

Glide Tables

Introducing Glide Tables [image] Glide Tables are like Google Sheets, but they live in Glide and have some exciting properties: They can hold much more data than a Google Sheet. You can share tables between apps. They don’t cause sheet edits/sheet reloads. There are also some limitations They are not yet as easy to edit as your Google Sheet. You cannot import or export data in bulk, but we are working on that. Only basic columns and user-specific columns are shared when you share a Glide …

[Manu.n]

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)

[ToOFa_Apps]

Haven’t yet. Thanks, I’ll check it out.

[ToOFa_Apps]

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.

[Manu.n]

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

Vidéo

[ToOFa_Apps]

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

[gvalero]

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

[Manu.n]

thank you @gvalero

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

[Riza_Lesmana]

WOW, Thanks

[Pratik_Shah]

Thank you for sharing this

[ThinhDinh]

Thank you, this is awesome.

[go_dash]

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

[ThinhDinh]

Here’s the URL.

https://streamable.com/6j6suo

[Robert_Petitto]

Improvements made 12/9/2021:

Glide Data Editor Updates! Copy/Paste + Insert Right!

Fantastic Improvements! Copy/Paste Multiple Rows/Columns Clear Multiple Rows/Columns Insert Right Duplicate > To the right (instead of at the end) Duplicate > [Column] Copy (instead of Copy of [Column])

[drascon]

Hey everyone,

There are two topics addressing this issue - this one and the one below :

Convert existing Sheets-based tab (data, computed columns) to Glide Table

+1, Hope they pay attention to this request

The other one seems to be a bit more active and has more upvotes. Maybe we should combine forces and add the 24 votes here to the 29 there to move it to the top of the Feature Request list?

[Elmer_Dubon]

thanks!

[david]

This is now shipped! You can import Excel, ODS, and CSV.