Announcements
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?
Hi @Niels_T
I do not have this option to do. Is that because I'm using a different version of Microsoft Lists?
I have 1000 choices to add and I cannot do them individually.
I feel that i am stuck but i need to do this for next week.
Is there another way?
There are two ways to access list settings and they're a bit different. When the above poster refers to the list settings, he means to click the gear (top-right of the screen). Choose List Settings and on the List Settings screen, select the name of the column that you want to add the choices to. That should take you to the screenshot the above user included, which will allow you to paste the thousand choices.
The other list settings, which don't allow pasting a thousand options, are accessed by clicking on the column title, choosing Custom Settings, and then edit. There, it seems like you can only add one choice at a time.
Good luck, James!
If you are using Lists within your M365 Personal subscription, you won't have the option to go to List Settings, as StalinPonnusamy mentioned. In case you have a corporate one (not sure about the Education sub), it will be available, but only if you have the correct rights to the list.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1
