We have SharePoint Enterprise 2016 at my work. All users from all departments and units are already in the Global AD which is connected to SharePoint. I want to create a user group in bulk from a file (Excel, CSV, etc.) that contains a certain list of users in my department. These users are already in the list of all users from my work. I can't use PowerShell. If you have any suggestions, I'd very much appreciate it.

Thank you.

1 Answer 1


You could just copy display names or email addresses of multiple users to the people picker field when adding users into one group in SharePoint 2016.

It will resolve the users if the display names or email addresses are right. The format of multiple users like below, use semicolons to separate the multiple users.

Use email address: [email protected]; [email protected];

Use display name: test1 zhang; test2 fan;

  • Thank you very much, especially for pointing out the semi-colons rather than commas.
    – rockower
    Nov 9, 2017 at 21:58
  • If the reply is helpful to you, you could mark the reply as an answer. Thank you for your understanding.
    – Amy_MSFT
    Nov 9, 2017 at 22:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.