Hi Karl, I had the same question. So, by “copy and paste” function, do you mean that I’d do the following:
Thanks! I’m brand new to Airtable as of last night! Feeling my way around, and so far, I LOVE it!
I’ve wondered this as well. Copy and paste is a workable solution but there are a bunch of other reasons why Airtable needs the ability to import from a spreadsheet into an existing table. This additional import functionality would need to be able to set up data keys, driving an update for any existing records with the same key and creating new records for ones that don’t already exist in the table.
Airtable would be able to address more of my clients’ CRM use cases if it had this functionality. Lead management is an example. Over time a company gets batches of leads in a spreadsheet that they need to be able to import into a Leads app. Duplication detection and record updates are key features that ensure the lead qualification process ends up being as efficient as possible.
I’m going to add this into the feature request forum.