πŸ†• Import Excel, ODS or CSV data to Glide Tables

Announcements
1

image
image2426Γ—910 164 KB

image
image1360Γ—978 32.3 KB

image
image1358Γ—898 21.5 KB

Originally confirmed by David here.

27 Likes
2

Excellent. Thank you

2 Likes
3

Thanks Glide team! :champagne:

1 Like
4
5

Great improvement :clap: :+1: :ok_hand:

1 Like
6

Blocking the entire weekend for updating β€˜them templates’.

3 Likes
7

Perfect! :ok_hand: :pinched_fingers:

1 Like
8

What’s your approach in regard to computed columns?

1 Like
9

Haven’t thought about it yet. I guess we will have to recreate them once the import is done. Will know more once I do a couple of these.

10

Love this. Super helpful. But it would be 10x more helpful if the import could either (1) generate a new Glide table, or (2) Refresh an existing Glide table, e.g. overwrite the previous import without corrupting any computed columns.

In short, (2) would be a manual sync for Excel files. Soooooo useful because it avoids the need to grant Glide access to my professional MS account. I encounter this message when I try to connect an Excel file:

image

1 Like
11

:heart_eyes:

12

For recreating templates, exporting CSV and importing CSV saved a bit of time, but the real time sucker is recreating all the computed columns and then assigning the Glide Table columns to the existing screens/components/actions…still took me an entire day for one of my templates.

Hopefully a convert app to glide tables is still in the works?

9 Likes
13

Hey all,

I need to add about 100 rows into one of my Glide Tables and I wanted to know if I can import them instead of doing it one by one.

I see there is an import feature but it seems it only works for β€œusers” table

Thank you

14

Try copy/paste.
That usually works okay for a small(ish) number of rows. You might have to copy them in 3 or 4 batches.

15

I tried but nothing happens. I have a google sheets file with the new data. I see now a meesage regarding Glide API

β€œThe Glide API allows you to add, edit, and delete rows in Glide Tables. Upgrade to Pro for API access.”

I am not yet a Pro user. I need to upgrade in order to copy/paste items in my tables?

16

No, copy/pasting into tables has nothing to do with the API.

How are you pasting?
You should use cmd-v (MacOS) or ctrl-v (Windows).

17

Yes, like that :slight_smile:
When I paste on a row nothing happens, but if I double click on a cell, I can paste the text inside

18

Works for me :man_shrugging:

Note that you have to first add enough empty rows in your Glide table to accept the data being pasted.

1 Like