Forum Discussion
Import picklist values for SharePoint List choice field
I have a column in a SharePoint List that uses the choice field type. I'm able to manually enter each choice value by copying/pasting text from an Excel spreadsheet. Is there a way to import a long ...
If you're only trying to populate the Choice values (not import list items), another option is to use PnP PowerShell. You can import the values from a CSV or Excel file and update the SharePoint Choice column programmatically. It's a great option if you have hundreds of values or need to repeat the process across multiple lists.
For a one-time import, though, the simplest approach is still to copy the entire column from Excel and paste it directly into the Choice field settings (one value per line).