Moodle 3.2: Import Grades into the Gradebook

Applies to: Moodle 3.2

Importing data from a spreadsheet can be an efficient way to get scores and short feedback into the Gradebook for large classes and some activities. For information on how to upload bubble-sheet tests from Office of Measurement Resources, see Import Results of Paper Exams into the Moodle Gradebook.

Note: Importing directly into the gradebook will add a lock on all imported grades. If grades have been uploaded for a Moodle activity, you will no longer be able to change the grades from the activity page. If you need to change the grades after importing, see Remove an Override Grade within the Gradebook.

Grades can be imported into the Moodle Gradebook from a Comma Separated Value (CSV) formatted file. Many spreadsheet programs (e.g., Excel) can save a file to CSV file format using the Save as command.

Columns with number values can be imported into existing Gradebook columns or as a new grade item. Columns with text will be imported into the feedback section of a pre-existing Moodle Gradebook column. Feedback text must be kept short.

The data on the CSV file can be imported in two ways:

  • CSV file - a full file import
  • CSV Import Plus - a copy and paste of selected cells

Preparing a CSV file for grades import

  1. Create the column(s) in the Moodle Gradebook if necessary.
    1. Set the grade type and maximum value for each item.
      WARNING: If you do not create and define columns in Moodle first, new columns imported from your spreadsheet will have a maximum value of 100 points. Changing the maximum value after grades are imported will cause errors.
      Create the Grade Items in the grade book first
  2. Export from the Moodle gradebook only the activities for which you want to upload scores. This will give you a template file that includes the necessary student information and column headers for a proper upload.
    1. In the gradebook, select Export > Plain text file (csv) from the dropdown menu in the upper right.
    2. Click Select all/None underneath all activities to take off all checked activities. Then choose only the activities you will be supplying scores and then importing into the gradebook.
      Select the None option underneath the gradebook activity listing.

      Select only the few activites to export that require imported scores.
  3. If you plan to import text comments with a score:
    1. Click Export format options to see the options.
    2. Check the Include Feedback in export checkbox.
    3. The export file will include a column for the values (numbers) and another for the feedback.
  4. Scroll down and click Download.
  5. Open the file with an appropriate program such as Excel.
    The exported activites will open in the Excel spreadsheet program.
  6. Only make changes to grade and feedback columns:
    1. Grade columns are titled with a standard format: "Activity type: [Activity name] (real)." Example: "Assignment: Research Paper (real)". Enter appropriate scores in these columns.
    2. Feedback columns are titled with a standard format: "Activity type: [Activity name] (Feedback)." Example: "Assignment: Research Paper (Feedback)". Enter appropriate short text feedback in these columns.
      Enter scores for the activities you will import into the grade book.
  7. Save your file.
    Note: do not change the filename. If you are using Excel you may see a warning about saving in the "selected file format." Go ahead and continue to save the file as-is.

Uploading a CSV file with grades

  1. Go to the course homepage.
  2. Find the Administration block:
    • Click Gradebook setup
  3. Select Import > CSV file from the dropdown menu in the upper right.
  4. Click Choose a file... and follow the directions to find and upload your file.
  5. Scroll down and click Upload grades. A preview displays.
  6. Verify the preview is correct.
  7. Under Identify user by:
    1. Change Map from to Email address
    2. Change Map to to Email address
  8. Under Grade item mappings:
    • Skip all non-activity items (First name, Last name, Email address, Groups)
    • For every activity that you are uploading grades for, choose the corresponding activity name in the menu below it.
    • For every activity that you are uploading feedback for, choose the corresponding activity name in the menu below it.
  9. Scroll down and click Upload grades again.
  10. Review the gradebook to make sure your grades imported correctly.

Note:  If an error message appears, the upload has failed and no grades have been transferred. Double check that all usernames and assignment names in the file match the Moodle site.

Copying and pasting grades from a CSV file

  1. Go to the course homepage.
  2. Find the Administration block:
    • Click Gradebook setup
  3. Select Import > CSV Import Plus from the dropdown menu in the upper right.
  4. Click Switch to Paste Data if necessary.
  5. In the csv spreadsheet on your computer, select and copy the full username or email address column and the cells with data you want to import. You MUST have the column headers included in the selection.
    Enter scores for the activities you will import into the grade book.
  6. In Moodle, paste your copied data in the Data box.
  7. Scroll down and select Tab under Separator.
  8. Click Upload grades.
  9. Verify the preview is correct.
  10. Under Identify user by:
    1. Change Map from to Email address
    2. Change Map to to Email address
  11. Under Grade item mappings:
    • Skip all non-activity items (First name, Last name, Email address, Groups)
    • For every activity that you are uploading grades for, choose the corresponding activity name in the menu below it.
    • For every activity that you are uploading feedback for, choose the corresponding activity name in the menu below it.
  12. Click Upload grades.
  13. Click Update.
  14. Click Continue.
  15. Review the gradebook to make sure your grades imported correctly.