Forum Discussion
Import Excel to Sharepoint List *with choices*
I have a large table I want to import from an Excel table. Most of the columns should be "Choice" types with Yes/No/NA options. I can import the table successfully, but it appears I have to change th...
If you separate the values like this, "Value1;#Value2;#Value3" it will automatically format them as choices in a "Choice" column. I only figured this out because when you select the values the "normal" way, this delimiter format shows up in the field for a split second!
Where or how did you do this? I have data in a choice column but the data does not show up as an actual choice, and there is too much data to enter manually.