Excel to SharePoint List: How to have a Choice column with multiple values?

Question

I want to do the inverse of this post. What do I need to type in my excel field to automatically create a Choice column in SharePoint with multi values when importing the Excel file via the Import Spreadsheet App.

a;#b and a,#b

do not work.

Thanks! Fabian

Answer 1

I don't think that's supported by the import spreadsheet wizard. PowerShell can certainly do this, though that's a bit of a different skill set. Another option that may work for you is documented here, which involves setting up a workflow to update the multi-value field.

Answer 2

Yes, you can import into SharePoint from Excel with Multiple choice values separated by ;# (semicolon and hash).