Importing Data from Excel into existing Glide Table

Ask for Help
1
  1. When adding new records do I need all the columns in the glide table or just the columns I will be updating in the Excel file.’
  2. Do I need to include the Row ID column even if it will be automatically assigned by the system?
  3. I get error 1001 when importing into an existing glide table which does not provide much detail.

image
image700×425 32.5 KB

image
image1259×161 28.4 KB

2

You don’t need all columns, but please understand that these will always be new rows. The system won’t detect a “key” column to update “existing” rows.

No, you don’t.

Please try again to see if you still see the 1001 error.

3

It’s possible, but I would suggest you do that with Make or N8N. It would be much simpler.
To start with, put your Excel sheet in the cloud in Google Sheets or such. Your IT manager can upload your Excel sheet on a defined schedule. For ex, everyday at 12@am.

4

Tried importing again with just 1 column with 5 records. Still got the same error 1001.

5

I’ve never had much success with importing, exporting is great but I had 5 tables yesterday, one magically worked (I don’t know why) but for the others, I had to do column by column manually. If it’s a daily data dump I would agree with @FrancoisDigico and use an external

1 Like
7

I let the team know about this. Will see how we can help.

8

A couple possibilities that I can think of:

  • Does the existing data already include > 25K rows?
  • Does the CSV include any special characters?
  • Can this same CSV file be imported as a new table without issue in a separate app?
1 Like