Importing CSV With Common ID Field

Topic Labels: ImportingExporting
1675 7
Showing results for 
Search instead for 
Did you mean: 

I use proprietary software in my line of work that allows me to export client data into a CSV file. One of the fields in this CSV file is called Household ID. Let’s call this CSV file “Household Assets”.

In airtable, I already have a table called “Households” with has the exact same Household ID field and number for each household.

Is there any way to import the CSV into its own table in airtable and automatically link both tables given they already have a common field, Household ID?

This would be useful as I could simply import once per month all my household asset updates and somehow track the trend and progress of my client assets.

Any ideas how I might be able to accomplish this? It would be great if I could even somehow automate this process too.

7 Replies 7

Hi Marco,

That’s super simple luckily. After you’ve imported the CSV with household IDs, simply turn the field with the household IDs into a linked record! Airtable will do the rest!

That’s actually not working for me right now. I have my “Households” table already with a HH ID field with the appropriate number for that household. I then imported the CSV into it’s own table. It too has a field called HH ID with the value of those fields matching what’s in the Households table. When I change the field type to Linked and link it to my HOUSEHOLDS table, nothing really happens. The numbers change to show that it’s linked but it’s not really pulling the data properly.

When I click on the linked HH ID, all the Household fields are blank.

Looking at this more closely, I just realized what it has done is created all new rows within the table itself instead of linking the existing rows based on the HH ID. That’s not the desired effect. I was hoping there would be a way to link the rows in the IMPORT table to the HOUSEHOLDS table using the existing HH ID records/rows.

For that auto-linking to work, the Household ID will need to be the primary field in the [Households] table. The fact that Airtable made new records leads me to think that your {Household ID} field is elsewhere in the table, not the primary field.

While non-primary fields can be reordered by dragging and dropping them, this won’t work if you want to move another field into the place of the primary field. You’ll have to copy whatever data is currently in the primary field into a new field, then copy the contents of {Household ID} into the primary field. Then the links coming from your other table should connect properly.