We have an Excel file with 300 rows of data and would like to copy & paste into a SPO list. However one of the field is "Choices" field with multiple selection. When paste into SharePoint edit grid it keep prompt me for format error.

How can I reformat my excel in order to copy & paste into Choices field with multiple values?

2 Answers 2


For example, you should format date ;A;B;C;D; in the excel file.

enter image description here


I had this issue and when I used PowerShell to upload from the CSV.

I needed ;# between choice values. A ; didn't work for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.