Importing Grades into Canvas
If you have grades that exist outside of Canvas, follow these steps for importing grades into Canvas:
- Download the Gradebook from your Canvas course as an Excel spreadsheet
- Add the grades to the Excel spreadsheet
- Import the grades back into Canvas.
- Open your Canvas course.
- Open the Gradebook tab
- Under Actions, select export
- You should get a dialog box prompting you to open or save the file. I open the file.
- You will get an text import dialog box, it is ok to accept the defaults and simply click "ok"
- The spreadsheet will have several existing columns. Do not modify these columns. You want to add your assignments as columns to the right of the existing columns.
- For each column, Row 1 is the assignment name and Row 2 will be the number of points the assignment is worth.
- Make sure the students in your paste line up with the students already present in the spreadsheet.
- You might be prompted to change the format of the file. Do not do this, keep the file in the original csv format.
- Save the document and remember the name and location.
- Go back to canvas and now under Actions, select import
- Browse for the file you just created and select it.
- Click "Upload data" to start the upload.
- Canvas will now give you a page that lists all the new assignments. For each assignment you can will need to change the dropdown box to "a new assignment"
- Click continue. You will be given a preview panel. If you are ok with the import click "save changes"
- Once the import is complete the gradebook will be displayed and you can verify the import.
Note: Read this Canvas Community document for more details on this process.