How do I upload changes to the Gradebook?

You can use a CSV file to upload changes to the Gradebook.

Notes:

  • The Gradebook CSV file does not currently support entries for assignments set to display grades as complete/incomplete.
  • CSV file uploads can create assignments and update grades; they cannot update any other area of the Gradebook, such as assignment status or comments
  • Letter Grade and GPA Scale assignments do not support any entries that are not part of the assignment's grading scheme.

Open Gradebook

Open Gradebook

In Course Navigation, click the Grades link.

Open Gradebook Settings

Open Gradebook Settings

Click the Settings icon.

Upload Scores

Upload Scores

Click the Upload Scores (from .csv) link.

Choose File

Choose File

Click the Choose File to browse for your .csv file. Make sure the file is saved as Grades-Course_Name.csv.

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

View Example CSV File

The columns that you need are:

  • Student
  • ID
  • SIS User ID (if you use SIS)
  • SIS Login ID (if you use SIS)
  • Section
  • 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:

  • Current Score
  • Final Score

You can always download the CSV from Canvas, change it, and re-upload the same file and the changes you made will appear in Canvas once you re-upload the CSV file. Do not change the file name.

Open File

Open File

Click the .csv file containing the grades [1] and click the Open button [2] to upload the grades.

Upload Data

Upload Data

Click the Upload Data button to upload the .csv file.

Upload New Data

If you add a new column to the CSV file and then upload the file, Canvas will ask you what you want to do with the new column. In the drop-down menu, choose the A new assignment option [1]. Then assign the number of points possible [2]. Click the Continue button [3].

Canvas will create the new assignment with the following features:

  • Assignment Group: Assignments
  • Submission Type: No submission
  • Due date for: Everyone

Review Changes

Review the changes made to your Gradebook.

There will be a sentence at the bottom of the page if you upload assignments with no grade changes that reads, "Note: You uploaded some assignments that had no grade changes detected. They have been hidden."

Save Changes

Save Changes

Click the Save Changes button to update grades.

View Updated Grades

View Updated Grades

View the updated scores in the Gradebook.

(Optional) Lesson Feedback (0)

Please let us know if any information in this lesson appears to be incorrect in terms of Canvas functionality only (please do not submit feature requests here). This is not a help site, and submitted comments cannot be answered. If your Canvas course/account is having trouble completing any of the tasks outlined in this lesson, please contact Canvas Support by submitting a HELP TICKET via the Help Link within Canvas or emailing support@instructure.com. Thank you.

E-Mail me if a reply is posted