You can export a Moodle grade book to a text file that you can open with Excel, edit, and then save with changes for importing back into Moodle. If you want to export grades and associated comments, you have to perform the actions in a very particular and often non-obvious way. The procedure differs slightly for Mac and Windows. Both operations are demonstrated below, and you can find a written summary of the steps at the bottom of the page.
Import and Export on a Mac
Import and Export on Windows
- From the main screen for your course click Grades to go to the "Grader Report" area for your course.
- Click on the Export tab.
- Choose Plain text file
- Check the option to Include feedback in export
- Change the Seperator option to "Tab"
- Select the items for export. (Hint: there's a toggle switch at the bottom to de-/select all items.)
- Click Submit
- Click Download
- Save the .txt file in a convenient location
- Editing with Excel
- Start by opening Excel
- Choose Office > Open
- Navigate to your text file and open it. (Hint: make sure to select "All files" from the "Files of type" drop-down in order to see the .txt file)
- In the Text (Import) Wizard make sure that "delimited" is selected
- On Windows, switch the "File Origin" to UTF-8
- Click Next
- On the next screen set "Text qualifier" to none
- Click Finish
- Make your edits
- When you save, be sure to keep the file in the .txt format
- In the "Grader Report" area, click on Import
- Choose CSV File
- Browse to your file and select it
- Switch the "Separator" to Tab
- Click Upload grades
- Map from Email address
- Map to useremail
- Map your grade item field to the appropriate item in Moodle. (Hint: You do not need to map the first several "grade item" fields corresponding to the user information.)
- Map the grade item "feedback" field to the appropriate item under "comments." (Hint: You may have to scroll down to see the comments area.)
- Click Upload grades
- If you see the message "Grade import success" then all has gone well, and you can click Continue
- If you get an error message, you could try again or contact your Academic Computing Manager for help.