Importing excel data into list with multiple selection choice column

Question

_{Wednesday, November 14, 2012 9:55 PM}

I have a spreadsheet with over 1K entries, converting it to a sharepoint list. I want to be able to assign each item multiple categories, so I set up a Choice column with multiple selections and created choice items for each category. I put the list in Datasheet view an pasted the content from Excel. It took it fine but it only identifies individual categories properly, any item with multiple categories gets listed in the "Fill-in" box and isn't indexed properly. Is there a way to get SP2010 to recognize this and tick multiple category checkboxes when I import the content?

All replies (3)

_{Wednesday, November 14, 2012 11:33 PM ✅Answered | 1 vote}

Short answer is no - I've run into this issue as well. To get around this scenario, I generally write a PowerShell script to create the list items within a SharePoint list as defined in a spreadsheet. There are also third party solutions available to achieve this functionality if you don't want to write a script/code to do the import.

Kind regards,

Craig

Senior Systems Engineer / SharePoint Architect | MSDN Profile | Blog | Twitter
Microsoft Community Contributor Award 2011 Recipient

_{Friday, May 30, 2014 2:57 PM | 1 vote}

For anybody that runs into this need in the future, the following outlines a method to bulk import while retaining the multiple category selections.

http://officepowerups.com/2014/04/28/import-to-sharepoint-from-excel/

No code needed.

_{Thursday, September 25, 2014 7:33 PM}

For anybody that runs into this need in the future, the following outlines a method to bulk import while retaining the multiple category selections.

http://officepowerups.com/2014/04/28/import-to-sharepoint-from-excel/

No code needed.

Thanks - this is awesome.