Use the import and export feature in Moodle gradebook to import and export to and from Excel. This article will show you how to do that.
Exporting to Excel Spreadsheet
1. Go to Grades from from the red navigation menu at the top of the course.
2. From the drop-down menu in the Grades page, click Export under More.
3. From the export page select Excel spreadsheet from the Export drop-down menu.
4. Select the Grade items to be included in the spreadsheet.
5. Format the spreadsheet from the Export format options.
6. When complete, click the download button at the bottom of the page.
Importing Excel Spreadsheet to Moodle
1. Open the spreadsheet, click File.
2. From the file page, click Save As.
3. Save the spreadsheet as a CSV (Comma delimited) file.
4. Go to Grades from from the red navigation menu at the top of the course.
5. From the drop-down menu in the Grades page, click Import under More.
6. Upload a file by dragging and dropping into the drop box.
7. Once uploaded, click Upload grades.
8. Map the grade item to the item in the spreadsheet.
9. Once complete, click Upload grades.
This work by Kwantlen Polytechnic University (KPU) is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.