Forum Discussion

vanme55's avatar
vanme55
Copper Contributor
Oct 23, 2022

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...
SharePoint Online
guswid's avatar
guswid
Copper Contributor
Jul 12, 2023
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
ganeshsanap's avatar
ganeshsanap
MVP
Jul 12, 2023

guswid vanme55 JamesEpp 

 

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.

  • JamesEpp's avatar
    JamesEpp
    Iron Contributor
    Jul 12, 2023
    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?

Resources