CSV Import Multiple Select Values

[Shomrei_Emunah]

Trying to import via CSV file Multiple Select Values. I want to import Value1, Value2, Value3 as three separate multiple select items. If I separate the values in the cell of the CSV file with commas I get one item “Value1, Value2, Value3”.

is there some delimiter i need to use between seperate values?

Thanks.

[M_k]

Hi Shomrei_Emunah

Just to clarify. Do you want one field with different selections or three different fields with one selection?

Where is the data originating from: spreadsheet, another database app or Word document?

I have Imported a CSV file from another database app, with a field with selections, and once I have Imported the CSV file into Airtable, I just create a field with multiple selections and all my choices shows up.

MK

[Shomrei_Emunah]

thanks, one field with multiple selections as data.

[M_k]

Hi Shomrei_Emunah

What source is the CSV file created from?

I was asking the above question because if you were exporting/importing from another database, it should be easier to do.

I managed to find this information about deliminatirs on Wikipedia. If you continue to read the whole article, it will get into CSV files, too:

en.m.wikipedia.org

Delimiter-separated values

Formats that use delimiter-separated values (also DSV):113 store two-dimensional arrays of data by separating the values in each row with specific delimiter characters. Most database and spreadsheet programs are able to read or save data in a delimited format. Due to their wide support, DSV files can be used in data exchange among many applications. A delimited text file is a text file used to store data, in which each line represents a single book, company, or other thing, and each line has fie...

The other idea I had, was to place all your choices into one spreadsheet cell (a spreadsheet would be the best way to do a CSV Import) instead of each choice in a seperate cell and you can start with a few choices, to test the import, You could try with a space deliminator and create a test base, if that does not work, try the other deliminaters, continue until you find what does the trick. You don’t need to keep creating new bases, you can import in the same table. Or maybe you did this. If so, try to place the choices in seperate cells.

I am curious to know how this works, I may need to do it this way myself.

Hope it helps. If not, perhaps someone in the community might have some suggestions.

MK

[Shomrei_Emunah]

found my own workaround. have to import the field in to a temporary field formatted like this:

“value1”, “value2”, “value3”

Then once the import is complete, select the field and copy paste into the filed formatted for my multi-select list. then each value is separate.

[Jeff_Solomon]

Here are steps to do this:

1. Make a single column in Excel/Google Sheets of the values you want to convert to dropdown options in Airtable
2. Copy that list into an online free tool to convert list to comma separated string (NOTE: we can’t include links in Airtable community, so just go to Google and search “convert list to comma separated string” then choose the result from convert.town/column-to-comma-separated-list
3. Create a type = MULTI-SELECT field in airtable (you can change this to SINGLE SELECT later)
4. Paste the formatted list from step 2 into a new record > that field (i.e. not from “customize this field”, but within the actual column for a new record. This will create all of the items as selection options and add them for that record
5. Just delete all the values for that record
6. Change the field type to SINGLE SELECT if you want

Done.

[nikolaibogdanov]

Thanks, Jeff, your solution worked nicely for me.

[Bob_Stevens]

Jeff_Solomon:

convert list to comma separated string

I used the TEXTEJOIN command and it worked

[Trevor_Bechtel]

Thanks Jeff, this really helped me. I think I’ve found an even easier approach.

1. Make a single column in Excel/Google Sheets of the values you want to convert to dropdown options in Airtable
2. Create a type = SINGLE LINE TEXT field in airtable
3. Paste the list from the spreadsheet into the new field (it will paste into many cells/rows/records)
4. Convert the type to MULTI-SELECT and it will invite you to create new options for everything
5. Just delete all the values for the cells/rows/records you previously entered
6. Change the field type to SINGLE SELECT if you want

[Joyce_Chia]

In case anyone is looking at this post - the simplest way is:

1. In your single Excel/Google column, use a comma to separate your tags (eg family violence, child protection) - don’t have tags with commas in them and trim whitespace so you don’t have extra spaces in front of any tags
2. Copy and paste directly into a multi-select column.