Sometimes faculty like to enter grades into Moodle using Excel rather than directly through Moodle gradebook. This method requires one first to export, then import, the gradebook.

Importing Grades into Moodle

  1. Click the Grades tab at the top of the screen from the "Settings" block. 
  2. Click on the Grade Report dropdown menu in the upper left corner and select the Export link.                                                                                                                                                                            
  3. Click the "Excel spreadsheet" link to ensure the gradebook is exported for Excel. Select the grade items you wish to export or export them all and select any other options that apply.                                                           
  4. Click the Download button below.                                                Export format options
  5. Open the downloaded Excel file and enter the grades in the appropriate columns. Do not add more columns.
  6. If a column doesn't exist in the Excel file, add the assignment or grade item first in Moodle then export it again.
  7. Save the Excel file as a CSV (Comma Separated Values) file. Excel save as menu
  8. From the course again, click the Grades tab and select Import from the Grade Report dropdown menu.
  9. Click the [Import] tab in the gradebook.                                                            Import option in Moodle
  10. Drag and drop the CSV file you just saved to the "File" box. Import CSV menu
  11. Click the [Upload grades] button.                                                                   Upload grades button
  12. Set the [Map from] field to "Email Address" and the [Map to field] to "Email Address."                             Map from menuMenu showing mapping to options
  13. Map the grade item or items to the appropriate item or items you graded in Excel.
  14. Click the [Upload grades] button to finish.