Forum Discussion
Import Excel to Sharepoint List *with choices*
I have a large table I want to import from an Excel table. Most of the columns should be "Choice" types with Yes/No/NA options. I can import the table successfully, but it appears I have to change th...
I am having the same issue as yours. It is very strange that the list of choices was successfully imported when you try editing existing rows but when you edit the column settings, the choices are just not there. Looks like a bug to me
This is a known limitation/issue with the SharePoint lists while creating a new list by importing an excel file.
Choices/Options in the choice column settings will not be added automatically. Also, choices will not be shown in Grid view (quick edit view) even when those are shown while creating new lists.
You have to get the unique values from excel column and add those manually to your choice column settings. Follow: Excel - filter for unique values or remove duplicate values
You can raise a support ticket with Microsoft directly and report this behavior at: Get M365 Support - Online Support
And add new feedback/idea on SharePoint feedback portal to save choices in choice column as well so that Microsoft will implement it in near future: SharePoint Feedback Portal
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- If this is a known issue with Sharepoint 365 is there a known issue/incident I could look at for it in the MS365 admin center? And if not, why not?
