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...
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.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
