Forum Discussion
vanme55
Oct 23, 2022Copper Contributor
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...
fredmeissner
Aug 23, 2024Copper Contributor
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!
- CKWGAOct 07, 2024Iron ContributorWhere 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.
- k_312ceSep 19, 2024Copper ContributorCan you provide an example of what you mean. Where are you putting those values?