Export and Import the Gradebook

Last updated on June 4, 2024

The Gradebook within Canvas can be exported as a spreadsheet. You can modify that spreadsheet in a program like Microsoft Excel and then import it back into Canvas to make changes to the gradebook. You can save the export for your own records or use the spreadsheet to create an email list for your course if you like.

Related Resources

• Create an Email List for Your Canvas Course

Directions

Export the Gradebook

1. Go to MSU Denver’s Faculty and Staff Hub.
2. Click Canvas in the Teaching & Learning section.
3. Log in to your Canvas Account.
4. Select the Course you’d like to work in.
5. Click Grades on the navigation menu on the left side of the page.
6. Click Export in the top right-hand corner.
7. Click Export Entire Gradebook.
   • Alternatively, you can click Export Current Gradebook View to maintain any filters you currently have active.
8. Locate the Exported Gradebook in your downloads folder.
9. Open the File with any spreadsheet editing software, such as Microsoft Excel.
   • Please note that Canvas can only accept gradebook data in the CSV file format. After editing the spreadsheet, make sure it is saved in that same format.

Import the Gradebook

1. Click Grades in the left-hand course navigation menu.
2. Click Import in the top right-hand corner.
3. Click Choose File.
4. Locate and double-click the CSV File you would like to upload.
5. Click Open.
6. Click Upload Data.
   • A list of the data changed will be displayed.
   • Note: If columns were added to the CSV, you will receive a prompt that they should either be added to the course as new assignments or disregarded. Please view our “Add Items to Modules” or “Edit an Existing Assignment” tutorials for more information on managing the assignments.
7. Click Save Changes in the bottom left-hand corner.