Forum Discussion
Matt_UHB
Jan 05, 2024Copper Contributor
Change a Choice Column to a Yes/No column
Hi, I've created a SharePoint list from an Excel spreadsheet to use as a data source, and it has imported my data in some instances as Choice columns. However, I want them to be Yes/No columns. Un...
Jan 05, 2024
What you are seeing is corret, you cannot convert a choice column into a Yes/No (Boolean) column
michaelheaven
Feb 01, 2024Copper Contributor
It's not correct at all. He wants to know how to change his column type. There is no correct or incorrect. The user needs to change his column type to what he needs, not what Microsoft tells him he can and cannot have. jcgonzalezmartin
- Deb_KlenkeSep 17, 2025Copper Contributor
In order to change his column type from choice to yes/no, he needs to delete the choice field and recreate a Yes/No column.
- Rob_ElliottSep 18, 2025Bronze Contributor
Or have the options in the Choice column as Yes and No.
- Feb 01, 2024Ok,
Let me say it on a different way: He cannot change the column type from choice to boolean because it's not supported. Only solution here is the workaround provided by Neeraj.