How to modify Canvas Gradebook export for import into Axess

Instructors can import a CSV file into Axess* to submit final course grades. The CSV file must have two columns: SUID and grade. Below are steps on how to export and modify a Canvas grade CSV file before importing it into Axess:

1. Finalize grades in Canvas. You must have set up a grading scheme so each student has a letter grade.
2. Export grades from Canvas by going to Grades> Actions > Export Entire Gradebook. 
3. Open the downloaded CSV file in Excel. 
4. Make the following adjustments to the Final Grade column, as needed:
   • If student has S, NC, or other non-grade notation, edit grades to match the acceptable notations
     • Note: If you attempt to import letter grades for students who opted for S/NC in Axess, you will receive an error for those students, but you can manually enter acceptable entries later.
   • If you use grade override and have overridden student grade, move cells from the Override Grade column into the Final Grade column for rows with an override grade.
5. Delete all columns except SIS User ID (SUID) and the Final Grade columns.        
6.  Change the SIS User ID column title to Student ID and the Final Grade column title to Grade. Delete the second and third rows, so that your resulting layout is similar to the compliant layout* below:
          
7. Save your two column CSV file to your hard drive. You can now import this properly formatted CSV file into Axess.