Import Data From Excel & Sheets into Glide Table

[Drearystate]

I would love to be able to take a workbook and import the data directly into Glide Sheets. Is there a roadmap for this feature. It makes sense with us migrating to Glide Sheets.

[kingzy]

Copy and paste?

[Drearystate]

Doesn’t work, it pastes it all into 1 cell.I’m not refering to the Google Sheets, but the Glide Sheets we create in Glide, it just pastes to whatever cell is selected.

[Drearystate]

@david is there currently a “in the works” for importing data directly into glide sheets? It would make us want to use the glide sheets a lot more if we could import directly to them, otherwise some of our spreadsheets just have too much data to retype.

[Drearystate]

He only replies to the ones he wants to…

[Jeremy_P]

I’d love to have this as well

[Rosewebstudio]

It’s in the original post?

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 …

[Drearystate]

I know they ar working on it. My questions is when

[Rosewebstudio]

Ahh I see,

[Drearystate]

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.

[Fabio_Leanzi]

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.

[eltintero]

YES! Let’s upvote this!!!

[Krivo]

Probably most needed feature👍

[Drearystate]

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.

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