Help

How to add field options in bulk?

Solved
Jump to Solution
2197 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Redfern
4 - Data Explorer
4 - Data Explorer

I need to add a list of countries and languages as options for a few different fields. When I open the Single Select field, it forces me to add each option one by one. This would be extremely time consuming.

Surely there is a way to add options in bulk? Would really appreciate it if someone could tell me how to do this efficiently.

Thanks,
Alex

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto
  1. Temporary convert the field type to single line text.

  2. Paste in a column of values so that Airtable creates new rows, one per value.

  3. Convert the field type back to single select. Airtable will convert the values in the new rows to field options.

  4. Delete the rows you created in step 2.

See Solution in Thread

4 Replies 4
kuovonne
18 - Pluto
18 - Pluto
  1. Temporary convert the field type to single line text.

  2. Paste in a column of values so that Airtable creates new rows, one per value.

  3. Convert the field type back to single select. Airtable will convert the values in the new rows to field options.

  4. Delete the rows you created in step 2.

You can also check out the Eazyfields app to create a field with every option.

Thanks so much, you saved me from wasting a lot of time. Would make sense for Airtable to allow users to add options in bulk, one per line.

Can you please help me understand how to do step 2.  How do I paste the column of values ? Are you referring to a google sheets column of my own data that /I want in the field as a single select ?