I need to upload (edit: currently trying via import spreadsheet) a table from excel where one of the columns needs to be a multiple choice selection field.

By adding a ";" separator into the excel column and then uploading it SP then converting the text column to a checkbox choice column SP seems to automatically know which values are the selected ones.

The only problem is that this does not work for filtering. When I click on the column to filter by and select a value the list will return 0 items.

Going into quick edit mode and opening the choices for that column on that item will then update the list so that when I filter by one of the selected values that item will appear.

I am looking for a quicker way of updating the columns so that I do not need to touch each row individually.

column data example:







1 Answer 1


You should first change column type and then import data (I assume that you are importing it via Quick Edit mode). I have tried such a scenario and using ; seperator works fine with filtering, but when I tried to convert column with data within it to multichoice column, filtering did not work(same behaviour as you described).

  • Unfortunately the amount of data I'm passing means that instead of copy pasting lines in i am importing the table instead
    – Roland
    Commented Aug 28, 2017 at 6:45

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.