Blackboard Ultra (Faculty) - Gradebook: Upload Grades from Excel to Gradebook
To upload a correctly formatted file, first expand the instructions below to download your Gradebook. Then, edit that spreadsheet file with the grade data you want to upload and save it.
Download the Gradebook
Downloading the Gradebook
You can download the full Gradebook or select columns from your Blackboard Ultra course. When you download the Gradebook, it can be saved as a comma-separated value (.csv) file or a Microsoft Excel (.xls) file, which can be opened in spreadsheet software.
Download the Full Gradebook:
- Navigate to the Gradebook in your Blackboard Ultra course.
- In the top right corner of the Gradebook, click the Download icon (arrow pointing downwards).
- In the Download Grades side panel that appears, select Full Gradebook and check the Select All Items box to ensure that all Gradebook columns are downloaded
- Scroll down in the Download Grades side panel to select your preferred file type and download location and then click Download.
- The spreadsheet file will then be downloaded to your computer's default download location.
Download Specific Columns:
Follow the steps above until Step 3. Instead of choosing "Select All Items" in Step 3, use the check boxes to select the specific Gradebook columns you want to download. Scroll up and down to see all the column options. Once you have selected the desired columns, proceed with Steps 4 and 5 above.
Need Additional Support?
If you have any questions or need further assistance, please contact the ITS Help Desk:
- Call: (618) 650-5500
- Email: help@siue.edu
- Visit: Lovejoy Library Room 0005 during regular business hours.
This guide aims to provide useful information, but as technology changes, interfaces or steps might vary. Please use the Comment button to let us know if anything differs from your experience. Your feedback helps us keep this information accurate. Thank you!
Uploading the Excel (or CSV) File
- Open your Gradebook and select the Grades or Gradable Items tab.
- In the top right corner of the screen, click the Upload Gradebook icon.
- In the Upload Gradebook panel, drag and drop your Excel or CSV file or choose Upload a Local File to browse and select the file. The spreadsheet must be properly formatted. See the note above about first downloading the Gradebook to ensure proper formatting.
- In the next panel, review the list of columns you changed in the file you want to upload. Clear the check boxes for any data you want to exclude from the upload. Use the trash can icon to delete the file if you chose the wrong one. When you're ready to upload the file, click Upload.
- In the Grades grid view, columns with grade changes appear highlighted in pink for a few seconds to show where the changes occurred.
See this Blackboard support document to help troubleshoot any errors you may encounter: Upload a File to Gradebook
Need Additional Support?
If you have any questions or need further assistance, please contact the ITS Help Desk:
- Call: (618) 650-5500
- Email: help@siue.edu
- Visit: Lovejoy Library Room 0005 during regular business hours.
This guide aims to provide useful information, but as technology changes, interfaces or steps might vary. Please use the Comment button to let us know if anything differs from your experience. Your feedback helps us keep this information accurate. Thank you!