Import Final Grades in Banner from Spreadsheet

Auditors enrolled in a course will cause the grade passback from Canvas to Banner process to fail. In that case, you need to enter grades directly into Banner.

If you have a large class, it is possible to import the grades to Banner from a spreadsheet. You will still need to import the spreadsheet for each section in Banner so the spreadsheet import option may not save time in the long run from manual entry unless you have significant experience working with Excel. 

Optional: Steps to import grades to Banner via spreadsheet

1. Download the Grade Template from Banner

The first step is to download the spreadsheet template from Banner.

1. Go to the Faculty Grade Entry page, click on the course section.
   
   
2. Click on the gear icon in the top right-hand corner, then click on Export Template from the dropdown menu.
   
3. Select your preferred spreadsheet file and click Export to download the file.
   

2. Enter Grades in Excel

Open the downloaded file in Excel and enter the grades in the Final Grade column. Then, save the file.

3. Import Saved Spreadsheet into Banner

1. Go back to Banner and click on the appropriate course section, then click the gear icon and choose Import.
   
2. Select the saved file with the final grades.
3. Click Upload, after it is successfully uploaded click Continue.
4. The Preview file should look like your Excel gradebook, click Continue.
5. The Columns should have been mapped automatically, click Continue.
6. Once Validated, a summary of what will be imported, not imported, and has errors will be displayed, click Continue.
7. When it is finished importing click Finish. You can download the validation report to see the full list of changes that were made to the Banner grade book.
8. Review the changes in the entry form and make any manual corrections needed.
9. Click Save at the bottom of the page.

If you have grades in Canvas, you can work from a Canvas Gradebook Export

For single section courses:

1. Download the Canvas gradebook
2. Open the csv file in Excel and save as xlsx or xls
3. Remove all columns except for the following:
   
   1. SIS Login ID
   2. Final Grade
4. Remove the 2nd row containing Points Possible
5. Remove the Student, Test (last row) if it exists
6. Add a new column at the beginning and call it Term Code. Fill it with the current term code (YYYY## - 4 digit year and either 20 for spring semester, 30 for summer semester, or 40 for fall semester)
7. Change the column label SIS Login ID to Student ID
8. Add a new column between Student ID and Final Grade and call it CRN. Fill each row of the column next to the Student IDs with the course section CRN.
9. Add a new column after Final Grade and call it Last Attended Date.
10. Enter Last Attended Date for each student with an F Grade. The date format should be MM/DD/YYYY and cannot be after the last day of the semester. (For online classes, you can get this date next to the student's name on the People page in Canvas.)
11. Save the gradebook spreadsheet.
12. Log into Banner and go to the Faculty Grade Entry form and click on the section where the grades will be imported.
13. In the upper-right corner, click the Tools menu next to your name and click Import.
14. Click Browse and locate the Excel gradebook on your computer.
15. Click Upload. After it is successfully uploaded click Continue.
16. The Preview file should look like your Excel gradebook, click Continue.
17. The Columns should have been mapped automatically, click Continue.
18. Once Validated, a summary of what will be imported, not imported, and has errors will be displayed. Click Continue.
19. When the import is done click Finish. You can download the validation report to see the full list of changes that were made to the Banner gradebook. Review the changes in the entry form and make any manual corrections, as needed.

For crosslisted courses:

1. Download the Canvas gradebook
2. Open the csv file in Excel and save as xlsx or xls
3. Remove all columns except for the following:
   
   1. SIS Login ID
   2. Final Grade
   3. Section
4. Remove the 2nd row containing Points Possible
5. Remove the Student, Test (last row) if it exists
6. Add a new column at the beginning and call it Term Code. Fill it with the current term code (YYYY## - 4 digit year and either 20 for spring semester, 30 for summer semester, or 40 for fall semester)
7. Change the column label SIS Login ID to Student ID
8. Replace the column label Section with CRN. Replace the section name with the appropriate course section CRN from Banner.
9. Add a new column after Final Grade and call it Last Attended Date.
10. Enter Last Attended Date for each student with an F Grade. The date format should be MM/DD/YYYY and cannot be after the last day of the semester.
11. Save the gradebook spreadsheet.
12. Log into Banner and go to the Faculty Grade Entry form and click on the section where the grades will be imported. (You will need to upload grades for each section separately.)
13. In the upper-right corner, click the Tools menu next to your name and click Import.
14. Click Browse and locate the Excel gradebook on your computer.
15. Click Upload. After it is successfully uploaded click Continue.
16. The Preview file should look like your Excel gradebook, click Continue.
17. The Columns should have been mapped automatically, click Continue.
18. Once Validated, a summary of what will be imported, not imported, and has errors will be displayed. Click Continue.
19. When the import is done click Finish. You can download the validation report to see the full list of changes that were made to the Banner gradebook. Review the changes in the entry form and make any manual corrections, as needed.