Bulk Enrolments plugin

Bulk Enrolments plugin

Bulk enrolments allows you to enrol students and add them to groups in a Moodle course using an excel file containing the students' email address or userid. Before you start, you will require an excel file containing a complete list of the students' email address or userids in the first column. Subsequent columns contain the names of any groups you want to add each student to.

Create your CSV

In order to upload your students successfully, you will need to create a CSV file with the students details. CSVs are simple to create - one way is in a spreadsheet package, making sure to save it as a .csv file type. At minimum, your CSV file should contain one column for the main student identifier, usually their email address but it can also be their userid, or student ID number. Ensure you have column labels - this is because Moodle anticipates these and so ignores the first row of CSV file. In other words, don't put any actual student data in your file's top row. If you are using email then put 'email', if you are using user IDs then put 'userid'. If you want to enrol the students into Groups, include a second column which gives the group name for each student. Be careful to type these exactly. Give it a column heading 'group'. You can add subsequent groups in subsequent columns.

Create your CSV using google forms (Alternative method)

  • Step 1: Create a google form to get the usernames
  • Step 2: View the responses from 'Responses' menu (Figure 1)
  • Step 3: Go to the three dots menu (Figure 2)
  • Step 4: Click save as CSV (Figure 3)
  • Step 5: Use the CSV file as the input for next step (Please note first column is timestamp in google form)

Enrol the Students

In the Settings block on your course, under Course administration, click Users > Bulk enrolments.

  • Step 1: Go to the course and select participants tab. [4]
  • Step 2: Click on the down arrow in enrolled users. [5]
  • Step 3: Click on bulk enrolments. [6]

  • Step 4: Click choose a file [7].

  • Step 5: Click on browse [8] and select your CSV file. Click on upload.

  • Step 6: Scroll through the bulk enrolments page, go to mapping section and select the relevant column for the username. [9] If the column is not relevant or empty select respective column as none. If you need groupings, you can select relevant options.

  • Step 7: Click on Enrol them to my course [10]