Whether you'd like to upload grades to Moodle (including from external activities) or backup the grades, here's how you can import and export grades.
This refers to Moodle 3.2 from September 2017 onward
Grades 4 - Exporting and Importing Grades into the Grade book
There are several help sheets in this series. Start with Grades 1 - Introduction & Overview
To add grades to the Grade book
If you want to add a new set of grades to the Grade Book unrelated to any assessment or assignment in Moodle, then follow the following steps:
Step 1. add a new grade item (see Grades 3 - Adding a grade item (or column in the gradebook)
Step 2: Export the grade book as a spreadsheet
Step 3: Edit the spreadsheet to add the grades and save as CSV
Step 4: Import the amended file as CSV
If you wish to edit - outside Moodle - grades for existing assignments and assessments without creating a new column, miss Step 1.
Note: It is not advisable to attempt to upload grades into a Turnitin assignment column - these assignments should be graded from within the Turnitin Grademark tool.
- In your module find the Navigation block and click on Grades.
- The page will refresh to show you the Grader Report containing each student’s grade for each assignment and assessment. Students’ names are down the left column and assignments across the top – you will need to scroll (using the scroll bar at the bottom) to see all the assignments/assessments if you have several
- Now find the Administration block, and click on Administration > Export [choose required export document format]. We recommend Excel Spreadsheet (XLS file)
- The editing page appears for "Export to Excel spreadsheet"
- Choose the required information to be included in the export (see below for a description of each type of information). If you are exporting because you are later going to edit the grades and then upload them again, the defaults are fine to use.
- Click the Download button to start export. A pop-up will then appear (depending on your browser).
- Select the location for the file and click Save. (It will save to your Downloads folder if you do not choose a location.)
If you intend to use this export file to import grades later:
- You can now open this file in Excel and add the grades to the relevant column
- Save the file – but as a csv (Comma Separated Values) not an XLS file
Importing into Grades
If you are importing grades it is best to start from a spreadsheet exported from the module into which you want to add grades, then it will be in an appropriate format. So Export Grades first and then populate the saved document with the new grade information. Then import as follows:
- In your module find the Navigation block and click on Grades. This will open the Grader report
- Scroll down to the Administration block again and click on Import this time
- Choose the correct import document format. CSV file is recommended.
- Click ‘Choose a file…’ and browse for the document you wish to import, then use the Upload this file to load the data. Once this is done you will be returned to the previous screen. All other fields can be left as the default values, then click the Upload grades button. You will then be shown a preview which you can check to see if the data and grades look as you expect.
- During Import Preview, in the Identify user by section select ‘email address’ in the Map from drop-down box and ‘Email address’ from the Map to drop-down box. You can also use student ID number or Username to map the import to the student Moodle account, as long as the two fields are mapped accurately together in both drop downs
- You may also need to map some grade items, i.e, link columns in the spreadsheet to grade items in Moodle, see example below
- Click the Upload grades button
- Click the Continue button to go back to Grades to view the information imported.
Note: If you receive an error message stating The export date is invalid because it is more than a year ago, or in the future, or because the format is invalid then delete the column titled Last downloaded from this course in the csv file and try uploading again.
See also: How to export grades and download assignments from Turnitin