Exporting Grades from Moodle

Export Moodle Grades to Spreadsheet

The ability to export your Gradebook to Microsoft Excel offers you great flexibility. You can export grades just to maintain a backup offline or to use Excel to manage all your grading. Once the Gradebook is saved and opened in Excel, you can make modifications, re-save the file and upload it back into Moodle.

Set Export Options

  1. Click Grades in the Navigation drawer on the left-hand side of your course page.
  2. From the drop down menu in the middle, scroll down and choose how you would like to export the gradebook:

 

    • OpenDocument spreadsheet
    • Plain text file
    • Excel Spreadsheet
    • XML file

We will use Excel Spreadsheet for this example

3. Click on the Excel Spreadsheet link.

4. The next page gives you an overview of all items to be exported. If you wish to exclude any items, uncheck them.

gradeiteminclude

5. If you would like to export Grade Feedback with grades or export display types other than the default, expand the “Export format options” link and check the appropriate checkboxes.

6. Click the Download button when you are finished.

NOTE: If you plan to import grades back into Moodle, the exported gradbook must first be saved as a .CSV file. Open downloaded file in Excel and Save as type .CSV.