Import Grades from Excel to Moodle

Overview

As well as grading within Moodle, you can prepare all your grades and comments in a separate Excel file, which you can then upload to the Grader report area.

This page tells you how to upload such a file.

It is best practice to import only spreadsheets that were derived from exports from the Moodle Gradebook.

 

When to use

Enter marks and comments in an Excel spreadsheet offline, when you have a large quantity of assignments to mark, or if your in-Moodle marking is likely to be disrupted by a poor Internet connection.

Benefits

Teachers report that uploading an Excel file is a much faster and easier way of managing student marks and comments than entering them within the Moodle Gradebook, especially with large class sizes.

Guide

Step by step instructions

  1. In the Moodle Gradebook for the course, create a grade item for the uploaded grades to sit in if one does not already exist.
  2. Export the Gradebook of the grade item you just created.
  3. Open the downloaded Excel file and add the grades in the appropriate column. You can also add some feedback into the Feedback column.
  4. Save the Excel file as type a CSV file.
  5. In Moodle, in the Gradebook setup page, in the Settings block select Grade administration > Import > CSV file.
  6. In the Import file page, either drag and drop a file into the File box or click Choose a file and upload a file using the File picker. Then:
    • At Encoding, select the first option in the drop-down list.
    • At Separator, select Comma, if necessary.
    • At Verbose scales, if you marked using text (Pass, Fail, Credit etc.) instead of numeric grades, select Yes.
    • At Force import, if you wish to force importing check the box. It is recommended that you do not check this box.
    • Click Upload grades.
  7. In the Import preview page, under Identify user by:
    • At Map from, select Username.
    • Map to, by default, is set to Username.
  8. Under Grade item mappings, from the drop-down menu for the grade item you are importing, select the matching item.
  9. Click Upload grades.
  10. A "Grade import success" message will display. Click Continue to view the grades in the Gradebook.

Additional information

External resources

For more detailed information about uploading grades to the Gradebook, see this resource:

The screens in this document may look a little different from UNSW Moodle 2 screens, but the information is essentially the same.

Further assistance

If you experience technical or other issues, consult the Where to get help page.