How do I get an excel sheet of enrolled students?

If you need a list of student names or list of emails for all students enrolled on a Moodle course:

First make sure that group mode enabled in Course settings

  • Go to course > Settings > Course administration
  • Click Edit Settings
  • Scroll down to Group mode
  • Select and click ‘Visible’
  • Scroll to bottom of page and click ‘Save Changes’

Now generate a list of all or a group of students:

  • Go to course > Settings > Course administration
  • Click: Grades
  • From drop down box under Grader Report heading select All particpants or group
  • From dropbox top left of screen -slelect and click export : excel spreadsheet
  • Uncheck all checked items
  • Click submit
  • Preview or download list

You will now see a screen showing all student names and their emails – If you want the download in a different format – select from drop down box top right of screen

Leave a Reply

Your email address will not be published. Required fields are marked *