0

I am currently in the process of migrating data from a previous SharePoint list to a new SharePoint list outside our organization's network. One of the fields in the original list is multiple choice column labeled as "keywords". When I export it to excel, all the keywords export in one column separated by a comma.

With that said, when I import the data to a new SharePoint list, is there a way to get those keywords appear as multiple choices? Or do I have to manually enter them one-by-one? This is not ideal as there are around 500 items.

Any help would be very much appreciated!

1 Answer 1

0

I suggest you use save list as a template to migrate list data.

Reference:

https://www.enjoysharepoint.com/save-list-as-a-template-in-sharepoint-2013/

===================================

If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it.

2
  • Awesome. I'll definitely try this out. Thank you!
    – Mike O
    Jul 14, 2022 at 17:43
  • If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it. Jul 18, 2022 at 2:43

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.