Skip to main content

Moodle Quick Help Guide

Importing grades from CSV File (Excel Spreadsheet)

  1. Create new grade items and categories for the grade information you will be importing, within Moodle, before adding grades. 
  2. Follow the instructions in Downloading rosters or grades (exporting in Excel or other formats) to get a file with your current gradebook setup and spaces to add grades.
  3. Open the file you have exported, and add grade information to the appropriate categories. Do not add columns or change headings in Excel, as these will not be understood by Moodle.
  4. Use the Save As menu in Excel to save your grade sheet as a .csv file. Excel may warn you that formatting will be lost by saving as .csv, but save in this format anyway.
  5. Go back to your course, go to the Grades menu, and look for Import > CSV File
  6. Browse to the grade .csv file on your computer, and click Upload grades to complete the upload.

For more information, see the Moodle help file on Grade Import.

Springshare's information on Accessibility in Libguides - - MHC Accessibility Barriers Form