What's the easiest way to add a Country column?

#1

I want to create a Single Select field with a list of all countries so that users can fill it out in a form. What’s the easiest what to do this without having to add every single country individually?

Thanks!

#2

A somewhat not so clean option: Create a Single table with a single Field. Copy and Paste country names so each country is a record. Use the link record functions and make sure to turn off multiple links options.

#3

I’d love a option like this for States too!

#4

Thanks! But yeah the idea of creating a table with no use that’ll stick around forever doesn’t feel great.
Is there really no way to paste multiple choice options?

#5

Get all of the country names in a text editor (or a spreadsheet) with each country on a separate line (or row). Select all and copy. Now go to your airtable base. Go to the record at the bottom of the table. Click on the single select country field. Paste the country values in. Choose to expand the table. This will create a new record for each country. You can now delete those records and the single select options will remain in the field.

2 Likes
#6

Here’s a thread where the first link may be helpful (at least for the US states):

#7

David_Skinner You are the best!! Thank you! Thank you! Thank you! You have solved the biggest problem I’ve had with Airtable. This works beautifully! Airtable MUST add this to their tips and tricks. Will use it for other information like state/provinces and more

#8

David_Skinner you rock!!! It works. There is a God. :slight_smile: