Article Number :
Published on :
Last modified :
Knowledge Base :
Canvas Knowledge Base
How do I upload changes to the gradebook?
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. New assignments will automatically be published in your course. If you do not know how to save a file in a CSV format, please check the documentation for the program you are using to create your Gradebook changes (e.g., Excel).
If you don't want to create a new CSV file, you could "Export CSV file" from Canvas, edit the scores, and upload the file into Canvas.
If you create a column for a new assignment in your CSV file, Canvas will ask how you want to import the information. New assignments upload with the following settings:
- Assignment Group: Assignments
- Submission Type: No submission
- Due date for: Everyone
- The Gradebook CSV file downloads complete/incomplete assignments as full or no credit (e.g. for a 10-point assignment, 10 or 0). Scores with full or partial credit upload as a complete assignment; scores with zero upload as an incomplete assignment.
- 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.
- When multiple grading periods is enabled, CSV file uploads cannot create new assignments. Currently new assignments must be created in the Canvas interface. Additionally, CSV files are verified against grading period close dates; grades cannot be changed for any assignment in a closed grading period.
- An upload will not recognize assignments named Current Score, Current Points, Final Score, Final Points, or Final Grade.
- To upload changes to the Gradebook with student or assignment names containing special characters, please ensure the file is saved as a UTF-8 CSV.
To import grades:
- In Course Navigation, click the Grades link.
- Click the Import button.
- Click the Choose File or Browse button (depending on your browser).
- Locate your CSV file and click the Open button.
- Click the Upload Data button.
Note: If assignments in the uploaded CSV do not match the gradebook, a warning prompt will occur.
More information on uploading grades along with a picture tutorial can be found HERE.