How do I upload changes to the Gradebook?

Canvas recently introduced a new page design called the New Canvas User Interface (UI). Depending on your Canvas view, your page design may vary from the images shown in this lesson. However, the functionality and location of the components remain the same.

You can use a CSV file to upload changes to the Gradebook. You can upload information for existing assignments, or you can also use a CSV file to create new assignments in the Gradebook.

If you don't want to create a new CSV file, 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.

If you create a column for a new assignment, Canvas will ask how you want to import the assignment. New assignments upload with the following settings:

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

 

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.
  • Read-only columns are automatically ignored in the upload.

View Example CSV File

For new files, save the file as Grades-Course_Name.csv. For downloaded Gradebook CSV files, do not change the file name.

Required columns

  • Student Name
  • Student ID
  • SIS User ID (only required if you use SIS)
  • SIS Login ID (only required if you use SIS)
  • Section
  • Assignment (this can be for an existing assignment or a new assignment; retain IDs for existing assignments)

Optional columns

  • Current Score
  • Final Score

Open Gradebook

Open Gradebook

In Course Navigation, click the Grades link.

Upload Scores

Click the Import button.

Choose File

Choose File

Click the Choose File or Browse button (depending on your browser).

Open File

Open File

Locate the .csv file [1] then click the Open button [2].

Upload Data

Upload Data

Click the Upload Data button.

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].

Review Changes

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.

View Updated Gradebook

View Updated Gradebook

View the updated data in the Gradebook.