Download Scores from the Gradebook

Scores from the Gradebook can be downloaded as a .csv file.

1. Click the Grades link on the Course Navigation Menu.
2. Click the Settings icon and click the Download Scores (.csv) link to download a Microsoft Excel file.
   
   
   

If necessary, you can edit the scores in Microsoft Excel and re-upload them into your course. Once you have made changes, you can upload it to your course using the instructions that follow.

Please Note:

• In order to re-upload your edits to the Gradebook, you must be sure to save the file as a .csv file type.
• Assignment group columns are read-only columns calculated by rules or percentages set by the course site. Any changes made to these columns will be ignored when you re-upload the file to your course. Changes made to assignment scores will automatically be included in the assignment group calculation in the Gradebook.

Upload Scores to the Gradebook

You can use a .csv file to upload changes to your course Gradebook.

Please Note: This feature should be used with extreme caution!

First, you would need to download the existing grades from the Gradebook using the instructions above. Once this has been done, you can edit the grades as necessary and re-upload the same file. Any changes you make to the file will appear in Canvas once you re-upload the .csv file. Do NOT change the file name prior to re-uploading. The file name must remain the same as the file downloaded.

1. Click the Grades link on the Course Navigation menu.
2. Click the Settings icon and click the Upload Scores (from .csv) link.

   

3. Click the Browse button at the Choose a CSV file to upload prompt to select your .csv file. Make sure the file is saved as Grades-Course_Name.csv. Click the Upload Data button.
   

   
   

   Please Note: If you are unsure what the .csv file should look like, click on the What should the CSV file look like? [3] link. An image will appear in the window (see the next step).

   
   

   The columns that you need are:

   • Student
   • ID
   • SIS User ID (if you use SIS)
   • SIS Login ID (if you use SIS)
   • Existing Assignment (###)
   • A New Assignment (if you want to create a new one in the new file outside of Canvas)

   The columns that are optional are:

   • Section
   • Current Score
   • Final Score
   
   

   

4. Review the changes made to your Gradebook.
   
   Please Note: If you upload assignments with no grade changes, there will be a sentence at the bottom of the page that reads, "Note: You uploaded some assignments that had no grade changes detected. They have been hidden."


5. Click the Save Changes button to update grades.

Once the upload process is complete, you can view the updated scores in the Gradebook.