Consolidating a current list of data (countries) in Airtable with one in an excel sheet, so missing countries can be added

866 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I currently have a list of countries in one table but some are missing. I have a list of all the countries in an excel sheet that need to be added. I know there’s a work around to add the missing data by copying what you currently have with the excel sheet, but I can’t remember how to do it. Any suggestions? TIA!

1 Reply 1


and welcome to the Community,
to be honest, i’m not 100% understand the final goal, and why just don’t copy-paste full list from excel.

anyway, i suppose you need a list of unique country names from both sources.
just add whole excel list to the countries field, choose “customize field”, find “single select” but don’t press “save”, you will have a list of unique values, that you can ctrl+c (choose “cancel” to avoid field change, then paste that list where you want.
I usually use it as “lifehack” similar to Excel “remove duplicates”
For example, I just took a random list of 10 “A” countries and make some chaotic repeats.
Two more contained in other list

Annotation 2021-10-18 052316

other scenario - you need to know exactly which countries from excel are not present.
create empty second table. link countries table to it, copy-paste countries to linked field.
You will get unique countries list in second table. put some mark to the second field for all list.
then add excel data and check for unmarked.

here is a pic of 2 tables to explain better. that approach with second temporary table also may help to quickly find duplicates, number of values in a field (by adding count in second table and put as lookup in first) and so on. the key is - when you fill linked field by copy paste, airtables tries to find that value in linked primary field, and if not, it creates additional record.

Annotation 2021-10-18 054013

Second temporary table (i just forget to remove default first three empty records)

Annotation 2021-10-18 053215

I hope this example will be useful for other possible tasks