Create a CSV file

Before you begin

Make sure you are logged in as Manager.
Make sure you have all the necessary data of the users whose accounts you want to create. You will need to know their full names, email address, their place of residence and all the courses on which they need to be enrolled as well as the roles (e.g. student, teacher or manager).

In order to create many user accounts at once, you need to import a CSV file. In this topic, you will learn how to create such a CSV file.

Open the programme Microsoft Excel.
Open an empty Microsoft Excel sheet.
In the first row, you will write the table header information into different columns. You will need columns for username, first name, last name, email adress, city, password, course1 and role1.
Depending on the number of courses, you will need to add more columns for the course and the respective role.
Fill in each row with the data of a user.

If you do not know which username the users want to use, you can just invent one for them.

Type in some standard password. Later on during the import of the CSV file, you will force a password change so that each user can invent their own passwords.

Type in the short name of the courses.

Type in the short name of the roles.

If the users should be enrolled as students, you can leave the roles' columns blank. Only complete the roles' columns if the role is anything else but student, e.g. if the user needs to have the role of a teacher.

Figure: An example of how your excel table could look like
After you have finished filling in the table, click on File > Save as.
Click on Browse to determine the place where you wish your file to be saved.
You will see a new window.
Click on the folder in which you wish to save your file.
In the text field next to File name, type in your file's name.
In the drop-down list box next to Save as type, select CSV (Comma delimited) (*.csv)
At the bottom right corner of the window, click on Save.

Your table is now saved in a folder of your own choosing and in the CSV format.