Forum Discussion
Separating multiple values in Excel so that SharePoint List will recognise the different values
Hi there,
I am trying to import content from an Excel spreadsheet into a Sharepoint List. One of the fields in the List is the 'type of work' the applicant seeks, which is a 'choice' field that permits multiple selections (see attached image)
To create a similar variable from the existing Excel spreadsheet, I have had to draw from multiple columns, as we were not storing the information in one column. The result in column H (in Excel) is a string with the different 'types of work' (as named in the List) (see attached).
When I try to import the data from Excel to the List by going to 'Edit in Grid View' (in SharePoint List) and then copying and pasting the data from Excel to List all the content is correctly copied across except where there is more than one 'type of work' option in the cell copied from Excel (see below)
The error message associated with the fields in red states that '"marking work Course Coord" are not a valid value for this field'.
I have tried adding commas, semi-colons and ;# between the multiple values but the same error message appears.
Is there a way to separate multiple values in Excel so that SharePoint List will recognise the values as multiple values from those available?
Thank you in advance for any help or advice you might have.
2 Replies
- Rob_ElliottSilver Contributor
- aarontimoCopper ContributorThis is great! Thank you very much Rob_Elliott.