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!

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
2
  • Awesome. I'll definitely try this out. Thank you!
    – Mike O
    Commented Jul 14, 2022 at 17:43
  • If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it.
    – Emily Du - MSFT
    Commented 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.