1

I want to change a SharePoint Choice column to a single(or multi)-line text, Can I do this without data loss?

What will happen to the data if I change it?

2
  • Yes, you can change choice to single line of text column without any loss. Just to make sure it will work, you can create a test list in your site & try the same in test list from your side. Commented Aug 1, 2022 at 5:40
  • Is this single selection choice field or multiple selections choice field? Commented Aug 1, 2022 at 7:27

2 Answers 2

0

As per my research, If you are using single selection choice column, you can change choice column to single line of text column without any loss.


If you are using multiple selection choice column and trying to convert it to single line of text, you should see the confirmation pop up like:

enter image description here

When I clicked on "Save" button, I was not able to see the column data in list view:

enter image description here

But, when I open the edit form of list item, I can see the previous selected choices semicolon separated like:

enter image description here


Note: Just to make sure it will work at your end, you can create a test list in your site & try the same in test list from your side.

0

Others have given useful answers but I have also discovered something:

you can change just about anything to text, including choice and the data will remain HOWEVER it may become hidden, if this is the case you need to hit "edit column", scroll down to more options and scroll down again and hit column validation, where you will likely see a whole bunch of nonsense, if you delete that the raw data that was held there will be available as text

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.