Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

[SOLVED] Import, Match and Update Existing Records

cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Lfr
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve been digging around the forums, and I’m not totally clear on the answer, so I’ll ask the question here.

I have an existing Base with a Primary, unique field. I simply want to update the records via an import from a CSV which would require matching the columns and primary field. I do this all the time in QuickBase, but not sure if that’s possible here. Kind of a basic database function, IMO.

Is that possible with Airtable?

Thanks!

6 Comments
AL1
4 - Data Explorer
4 - Data Explorer

bump.

Would also love to know if there’s a way to bulk import records via a CSV file in AirTable, match them based on a key field and then update the corresponding columns (after ensuring they line up).

Thanks!

Katherine_Duh
Airtable Alumni (Retired)

Our CSV import block supports bulk importing/upserting of records from a CSV into an existing Airtable base:updated.gif

Status changed to: Already in product
MaddieJ
Community Manager
Community Manager
 
Miles_Mitchell1
4 - Data Explorer
4 - Data Explorer

Can someone confirm if this can only be done via extensions? When I use the import function, it just adds new rows - but no way to merge with existing records.

robirahman
4 - Data Explorer
4 - Data Explorer

I'm also having the same issues as Miles_Mitchell1. I want to import data to a new column from a csv, where some of the record names in the csv are the same as some of the record names in my Airtable base.

kendallodom
5 - Automation Enthusiast
5 - Automation Enthusiast