Use CSV import to create a large number of users and assign them to groups in a single action.
Download the CSV template
Begin by downloading the CSV template from the link on the Users page.
Open the template in a spreadsheet application. If your user's names have special characters, we suggest using Google Sheets.
Your blank template should look like the following:
Add the user information
In each row, enter the information for each user that you would like to create and add to a group. The fields are as follows:
firstName: your user's first name
lastName: your user's last name
role: Learner, Instructor, or Administrator
email: your user's email or unique identifier
password: your user's password. Leave blank to generate automatically.
groups: Optional. The name of the group that you want to add the user to. If the group doesn't exist, it will be created for you.
Each row in the CSV must have user data in it. Don't leave blank rows in the middle of the document.
Your CSV should look something like this:
Once you have completed entering the user information, save your CSV file.
Note that the CSV file must use commas as the separator. If your file uses semicolons as a separator, you can do any of the following:
Open the file in Notepad or Wordpad, and use Find / Replace to change semicolons to commas
On Windows, open Clock and Region, then click Change date formats. In Additional settings, set the list separator to comma
In Excel, uncheck Options > Advanced > Editing options > Use system separators. Set Decimal separator to a period. Set Thousands separator to a comma.
Upload your CSV
On the Users Page, upload the CSV file with the import users button.
After the upload is finished, you can see the upload results in the window. Check to see if there were any errors:
You can double check that the users you created show up on the Users page:
And that the groups you created are all on the Groups page:
To be sure that your import was successful, we strongly recommend that you try logging in as some of your newly-created users.
Managing existing users with CSV import
With CSV import, existing users can be added to new and existing groups.
In CSV import, users are identified by the email field.
To add an existing user to a group using CSV import:
In the CSV, type the user's first name, last name and role. Type the user's email exactly. The password doesn't need to match, but the field can't be left empty.
In the groups field, type the name of a new or existing group that you'd like to add the user to.
Import the CSV.
If an email in the CSV matches the email of an existing user, the user will be added to the group specified in the CSV.
The existing user's first name, last name, role, and password will not be changed.