I have imported that type of field directly from a CSV export coming from a database just by using the CSV import app available in Airtable.
If you want to use this method, you may pay attention to the following:
- CSV are comma separated, so there is a chance that you may end up in an error when exporting because a confusion between fields
- To avoid that situation, try a CSV formatted like this example:
- Include the headers in the first row (just for troubleshooting) and fill the data as
type, color, item
these are red items, red, “apple, cherry”
these are orange items, orange, “orange, peach, salmon”
these are blue items, blue, “smurf”
the CSV app will pick up the item enclosed between double quotes and put it correctly into a multiselect field in Airtable.
I hope that this helps