Import Data From Excel & Sheets into Glide Table

Feature Requests
18

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)

20 Likes