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.

 

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, selecting the grade item you just created.
  3. Open the downloaded Excel file and add the grades in the appropriate column. If you wish, you can create an additional column for comments—in row 1, add the column heading Comments.

Grade Import 3

  1. Save the file as type CSV (Comma delimited).

Grade Import 4

  1. In Moodle, in the Gradebook for the course, in the Settings block select Import > CSV file.

Grade Import 5

  1. 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 Windows 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.

      Choose import options
  1. In the Import preview page, under Identify user by:
    • At Map from, select Username.
    • Map to, by default, is set to Username.
  2. Under Grade item mappings, from the drop-down menu for the grade item you are importing, select the matching item.
  3. Click Upload grades.

Grade Import 7 8 & 9

  1. A "Grade import success" message will display. Click Continue to view the grades in the Gradebook.

Additional information