Forum Discussion
Import Excel to Sharepoint List *with choices*
Solution: Use the "From CSV" option to create the list, rather than the "From Excel" method. The format for the column in the CSV file that you want to be multi-choice in the List is ["Value1","Value2"].
For some reason if you use the ;# delimiter and the Excel option the choices will not load correctly. You can manually edit the column, allow multiple selections, and add a couple choices to see the options change from "Value1;#Value2" to a "Value1,Value2" format within the cells, which is correct for the multi-choice columns. However, those cases will not be found when filtered for those values until you manually save the choices for each of those cases manually. Way too time-consuming for a large data set.
The CSV option worked perfectly for me with no manual adjustments needed.