Help

How to paste data in a "Multiple select field" and get multiple choices, and not single ones

Topic Labels: ImportingExporting
807 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andres_Felipe_V
4 - Data Explorer
4 - Data Explorer

Hello,

I have a table with +400 records, and I want to ask a question about a “Multiple Select” column. How can I upload (or paste) separate records that I have in a CSV file, and put all of them as different categories in a “Multiple Select” column?

The context of this is that I have a Form in FormAssembly and currently in the Multiple Select column I have countless records of unique categories, that include records that merged several categories (we had pre-defined 12 options).

Here is a screenshot of how it currently looksCaptura de Pantalla 2021-03-15 a la(s) 5.44.01 p. m. Captura de Pantalla 2021-03-15 a la(s) 5.44.35 p. m.

I’m trying to solve this in a separate Spreadsheet where I created a CSV file with this column, I separate it but with formula and manually into different columns, and now I want to go back to Airtable and organize the “Multiple Select” column.

Does someone have any advice for how to do this?

2 Replies 2
arielleroot
4 - Data Explorer
4 - Data Explorer

Bump.

Did you ever figure this out? I have this same question.

Oh I figured it out! You just needed your semicolons to be commas.