Previous  Next

Import users from a spreadsheet

This option is available to Teacher administrators and Organization administrators.
 
Organization administrators can import users with any role.
Teacher administrators can import students and teachers only.
Teachers cannot import new users.

 
The import feature allows you to create a large number of users and place them directly into a class.

 
To import users you will first need to set up your user details in a spreadsheet. To do this:

1.Click Manage users on the left.

2.Click the Import new users button.

3.Click the Template file button to download a sample file in Excel or CSV format.

Note:
Your user details will need to be entered into the spreadsheet in exactly the same format as the sample file.

4.Delete the sample data and then enter your users' details into the file.

View explanation of columns

5.Save the file on your computer and then return to the site.

Note:
We do not recommend importing more than 100 users in one spreadsheet as this could take a long time to upload.

 
Once the file has been created you can import it into your account. To do this:

1.From the Import new users page, click the Browse button and find your file.

2.Click the Import button.

3.Check the information and click Save.

4.The status of the import will be shown onscreen. When the status is Completed, the users have been imported.

 
If there are any errors in the file, you can correct them by following these additional steps:

1.Click the link in the Error report column to download the report file.

2.Check the Error message column to confirm the problem.

3.Correct the information which caused the error.

4.Delete the Error message column from the file and save it to your computer.

5.Upload the user(s) again following the steps above.

Hint:
You do not need to stay on the page while the import is processing. Depending on the number of users, the import could take a long time. You can come back later to check the import status.

 
Once you have created your user(s) you will need to let them know their details. For more information see Distributing users' details.