Import and Export Users

Import/Export Users is a tool that allows site admins to manage their users through a .csv file editable in spreadsheet programs like Excel. With this file, admins can quickly set up or edit the details of dozens of users and commit all changes with a single upload. It is particularly useful for sites with large numbers of users. Moreover, this tool is supported by all themes and all sites.

Export Users

Go to Tools > Import/Export Users. Click the Export Users button.

This will create a .csv file of all current users, and download that to your computer. You can then edit this file in spreadsheet programs like Excel. You can edit any information about existing users and add new users by adding new rows.

It is important that you do not rename, rearrange, add, or delete any columns. If the .csv file is not formatted correctly, the 'import users" function will not work.

Import Users

Go to Tools > Import/Export Users. Choose the .csv file that you would like to import. The file must be in the exact same format as the one created by the export tool.

Select the Import Users button and the site will update the information of all users and create new users if needed.

Related content

Importing Users to UC People
Importing Users to UC People
More like this
Manage Users in SharePoint
Manage Users in SharePoint
More like this
Remove others from a SharePoint Site
Remove others from a SharePoint Site
More like this
Bulk Import Students into Groups using a CSV - Original
Bulk Import Students into Groups using a CSV - Original
More like this
External Users in SharePoint
External Users in SharePoint
More like this
Export Form Entries
Export Form Entries
More like this