/
Bulk add Users to SharePoint

Bulk add Users to SharePoint

Owners of SharePoint sites can bulk add many users at once by utilizing Outlook or Excel.

1) Gather the list of users

Choose a method of gathering the users to be added are Outlook and Excel.

Outlook

You do not need to send the emails described below.

Either compose an email with all the desired users, or click “Reply to” on a email that has the desired users; you need an email with the desired users in the “To” field.

Once you have all the recipients in the “To” field, while you have your cursor in the “To” field, press Ctrl + A to select all of the recipients and then Ctrl + C to copy the selected users.

Continue down to Step 2.

Excel

Open excel and create a single column spreadsheet with all of the desired users.

Press Ctrl + H to bring up the “Replace” window and replace all “.edu” with “.edu;” in order to add a semicolon to all rows.

Select all the rows press Ctrl + C to copy them.

2) Add users to SharePoint

  1. Visit the SharePoint home page at s.uconn.edu/sharepoint

  2. Click on the desired site to open it.

  3. Click on the settings gear in the top-right corner then click on Site permissions. Next, click on Advanced permissions settings.

  4. Click on the desired user group, or create a new one.
    To learn more about custom groups, visit https://uconn.atlassian.net/wiki/spaces/IKB/pages/26043613189

  5. Click on New to open the Share popup window.

  6. Click on SHOW OPTIONS and uncheck “Send an email invitation” if you do not want to email the users.

  7. Press Ctrl + V to paste in the copied users

  8. Click Share to finish.