Moodle Help Guide

Downloading Rosters or Grades (Exporting in Excel or Other Formats)

Go to your course site and choose “Grades” in the menu bar.
By default, you will see the Grader Report. Use the drop-down arrow next to Grader Report to switch to More > Export
To the right of the Export heading, choose the format you would like to export in. Options are Open Document spreadsheet, Plain Text File, Excel Spreadsheet, XML file, and Key Manager.
Once you have made your selections, Click the "Export" button at the bottom of the page to download the spreadsheet.
By default, this spreadsheet export will contain all grades that have been collected at the time of download. You can review and prepare this export for submission to the Registrar at the end of the semester when it is time to submit grades. Please consult with the Registrar's office regarding the formatting they require.
If you would like a roster without grade information, scroll down and click the “select all/none” option before pressing Export.

Before adding grades, set up your Gradebook within Moodle to include all your planned grade items. (See the Gradebook Basics page for more information).
Follow the instructions above to export a file with your current gradebook setup and spaces to add grades.
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.
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.
Go back to your course, go to the Grades menu. Use the dropdown that defaults to ‘Grader Report” to switch to More > Import.
Drag your saved .csv file to the box to upload it, or click "Choose a file", then browse to the grade .csv file on your computer, and click Upload grades to complete the upload.
Click "Upload grades" in the bottom right corner of your screen.