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. See Setting up a gradebook for more information on doing that. 
  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.

Want more help?

For any time, 24/7 help on your own:

For help Monday-Friday 9-5:

MHC Accessibility Barriers Form