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 list of values directly into SharePoint to save time?
3 Replies
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).
Good morning! If this is a brand new list that you're just starting to fill in, and if your Excel spreadsheet has the data you need to import, I would recommend deleting your list and recreating it "Import from Excel" so all of that existing data fills in automatically. You can then edit the columns as needed. If that's not an option, you can copy the entire column from the Excel spreadsheet and use "Edit in Grid View" to paste it into the SharePoint list.
edit the list column then copy all the rows from Excel in one go and paste the values.
