This message was deleted.

You can’t upload data directly to Stacker (unless using Stacker tables) So you’d need to import it through Airtable. How many records are you talking about? Create ops? Update ops? From your description, it sounds like you have a bunch of Excel sheets lying around and you’d like to import them into Airtable, potentially automatically, and/or at a regular basis. Tools like Make/Zapier might help to do that.

Thanks @sticky-night-20812 We’re still decideding which data base to use. Out of interest can you directly bill upload to stacker tables?

Not AFAIK but I’ve never really used them.

Could you export it to a .csv? You can upload a .csv directly to Stacker. Or I think you can even just copy and paste a spreadsheet in.

I wasn’t totally clear - we need our clients to do this. So we would need to do it, or trigger it from the front end of the site…

You can upload to Stacker tables via import from CSV or pasting from a spreadsheet. Sounds like your workflow may be different though? If customers have their own spreadsheet data, have you considered using GoogleSheets instead of Excel and then syncing GoogleSheets to Stacker?

Thanks @loud-magazine-63930 Peter I’ll take a look at this.

We have a number of Make automations that ingest partner data sent to us via CSV. Basically, we have a SFTP server from Couchdrop and when a partner uploads a file it fires a webhook to Make. We then retrieve the file in Make and read each row of the .CSV and send updates to Airtable. You could also watch a Google Drive folder or something instead of have a SFTP. Excel files might make this a little more complicated than CSV.