Can you configure a multiple-choice column in SharePoint?
Can you configure a multiple-choice column in a SharePoint list to have the answers be exported into individual cells in Excel 2013? We’re allowing more than one answer in the multiple-choice column, but when it exports into Excel all of the answers get combined into one cell with a hash tag in-between them, which makes reporting a hassle.
How to make a list in SharePoint Excel?
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.
Is there way to import data into list with multiple selection?
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?
How to export list to same sheet in Excel?
Now we have ‘MS Excel Web Query File’ files for both lists. Open new excel application. Go to Sheet1 and click on any cell. Click on ‘Browse for More’ and go to the location where ‘’MS Excel Web Query File’ files are saved. Select List A’s Query File and click Open.
How to import Excel spreadsheet into SharePoint list?
General questions about SharePoint 2013 can be answered here: http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral and for versions prior to 2010 here: http://social.technet.microsoft.com/Forums/en-US/sharepointgenerallegacy 2 3 I have a spreadsheet with over 1K entries, converting it to a sharepoint list.
How to create a list with multiple selections in Excel?
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.