Export Grades from Moodle Gradebook

• Export a Gradebook report
• Download the grades or responses for a single quiz
• Enter grades in a downloaded spreadsheet
• Re-import grades into the Gradebook

Export a Gradebook report

To export the User Report from the Gradebook:

1. Within your Moodle course, in the Settings block, click Grades.
   
2. In the Gradebook, in the Settings block, under Grade administration, click Export, and select the format in which you want the Gradebook exported.
   
3. On the Export page, make the appropriate selections for this export operation. This will mean selecting:
   • Grade items to be included
   • which participants to include (if you have set up groups)
   • whether to Include feedback in export
   • whether to include students in the export whose enrolment has not been suspended (Require active enrolment)
   • Grade export display type
   • Grade export decimal points
   • When you have made your selections, click Download.
     
4. If asked, click open or save the downloaded file.

Download the grades or responses for a single quiz

To download a single quiz's grades or student responses:

1. Click Turn editing on at the top right of the page. 
2. On the course home page, navigate to the quiz and click Edit settings from the drop-down menu.
   
3. In the Settings block, select Results > Grades or  Results > Responses, depending on what you want to download.
   
4. From the drop down menu and checkboxes choose the options that meets your requirements.
   
5. Select a file type from the dropdown menu and click Download.
   

Enter grades in a downloaded spreadsheet

1. Open the saved Excel spreadsheet.
2. Enter the grades in the appropriate columns. Note:
   • Do not change any existing column names.
   • You can add new columns for offline activities, and enter grades in them.
3. Save the file as a Comma Separated Values (comma delimited, .csv) file.

Re-import grades into the Gradebook

Click here for instructions on how to import/upload grades.