cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Niels_T
Helper II
Helper II

Importing a lot of choices in a Microsoft Lists column

Hello,


I have a column called "Country" in this column I would like to add a full list of all the countries in the world.

Is there a way to add a huge list instead of doing it one by one?

Niels_T_0-1631540266073.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @Niels_T 

 

  • Go to List Settings
  • Select the country choice column to edit
  • Copy from excel or notepad
  • and replace the values all

StalinPonnusamy_0-1631548645744.png

 

View solution in original post

1 REPLY 1
StalinPonnusamy
Super User
Super User

Hi @Niels_T 

 

  • Go to List Settings
  • Select the country choice column to edit
  • Copy from excel or notepad
  • and replace the values all

StalinPonnusamy_0-1631548645744.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,756)