An administrator can bulk upload users in Moodle using a spreadsheet. This can be created in Excel, Open Office, or a similar application like Google Docs. In this section, we will refer to using Microsoft Excel.
Tip
The minimum information that is required as data in the spreadsheet includes the first name, last name, e-mail, username, and password. The password is not mandatory, and if you leave it blank, it will autogenerate the password and send an e-mail to the user immediately with their username and password.
To prepare your file for uploading perform the following:
Open Microsoft Excel.
Create five column names in the first row as the following—these should be lowercase and no spaces:
usernamepasswordfirstnamelastnameemail
Fill in the user details:
For the username, we suggest you use the first name and last name with no spaces, no special characters, and all lowercase or e-mail address in lowercase.
If you are creating manual accounts, you...