Skip to main content

Importing Data into a Multi Select field issues

T

Hi There,


I’ve done an export from our website and want to import into Airtable. Most of the fields are fine but there is one field that I’d like to import as a Multi Select field but having issues.


A sample of the (anonymised) data looks like:


Apple~Chicken, Beef & Lamb~Rice~Pasta~Banana

Peach~Pear

Crisps, Chocolate and Sweets~Smoothie~Pineapple

Cheddar & Stilton~Pancakes

Pancakes~Apple~Peach

Crisps, Chocolate and Sweets~Pasta


For the above records I’d like them to appear as:



There are around 50 variables for the multi select field and the data itself is around 10,000 records so want to get the import right! And whilst we are looking at the API for the future, in the short term we will have to do multiple imports to keep the data up to date.


Advice welcome!


Thank you.

2 replies

X
  • Xavier_G_Sabate
  • Participating Frequently
  • 26 replies
  • November 4, 2021

Hi Toni,


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

Good luck

K
  • Kiki11
  • New Participant
  • 2 replies
  • February 24, 2023
Xavier_G_Sabate wrote:

Hi Toni,


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

Good luck


Can you append an example sheet, or explain more about:

  • 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.

Do you put ALL of that in the header? the original poster said they had like 50 different variables…

Thanks so much!!

– Kiki

Reply


Most helpful members this week

Terms & Conditions