There is not a tool that can directly move midterm and final grades directly from Canvas to Banner. Following these steps will help minimize the number of steps you need to take to export your Canvas grades for importing into Banner. 

Please note that this process has changed slightly due to an extensive Banner upgrade in 2024. If you have any questions, please contact me or the Registrar's Academic Record unit (record-info@illinois.edu or 217-333-9774).

1. Before exporting, please assure that your Canvas gradebook is finalized and accurately calculating final scores by following the instructions in the Canvas@Illinois , Finalize Grades article. If this step is not followed, it is likely you will export inaccurate grades. It is also important to enable a grading scheme before exporting so that you are exporting a letter grade. You do not have to use the default grading scheme and can create a scheme that follows your syllabus.
   
   
2. From your course space on Canvas, click the Grades link from the left menu.
   
   
   
3. On the Grades page, click on the Export drop-down menu on the upper left of the page. Select "Export Entire Gradebook".
   
   
   
4. Open this file in a spreadsheet program. 
   
   
5. Delete the "Points Possible" row.
   
   
6. See the current instructions on importing grades to be certain which columns you need to add, delete, and retain. We recommend exporting the template from Banner in order to make this simpler.
   
   
7. You can delete all columns from the Canvas export except the Final Grade column and the necessary ID number.
   1. The ID column in the Canvas export is a Canvas-only number so you can always delete that column.
   2. Both the SIS Login ID and SIS User ID are the student NetIDs.
   3. The Integration ID is the student UIN.
      
      
8. Change column headings to match the Banner export or move the data from your Canvas spreadsheet to the Banner spreadsheet. The column headings need to match the Banner export in order to import the data.
   
   
9. If you are assigning any F or ABS grades, add a column for Last Attend Date and Hours Attended. You will need to provide this information only for students receiving a score of F or ABS.
   
   
10. Follow the instructions for entering final grades provided by the Registrar. Look for the importing tool in the Tools drop-down. Correct any errors reported.
    
    

NOTE:  It is possible to use a single spreadsheet to import grades for all sections of a course so long as the appropriate CRN for each student is included in the spreadsheet. Upon import, only the grades for the students who match the section's CRN will be imported for submission.