Import Excel to Sharepoint List *with choices*

Occasional Visitor

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 the column type for each column manually to "Choice" and also manually edit the options. Is there a way to import this information from the Excel table or is there a way to automate the input of the choice options?

1 Reply

@vanme55 when you select New list and From Excel,  once you upload your list you will presented with a "preview" where you confirm the data type. By default it is Single line of text, so for each of your choice columns just change it to Choice and it will preserve the choice options from the Excel column for existing items and will allow you to select the choice for new items.

importChoice.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)