Download Blackboard Course Roster as a Spreadsheet

Issue/Question

How do I get a spreadsheet of my course's roster in Blackboard?

Environment

• Blackboard Ultra

Resolution

1. Log into Blackboard. 
2. Navigate to the course where you wish to download the roster. 
3. Click Gradebook. 
4. Click (upper-right) to open Gradebook Settings.
5. Within Upload and download gradebook, select Download Grades.
6. Choose whether to download Full Gradebook or Grade History.
7. Under Record Details, select at least one column. You may select more if you would like that data. 
8. Under File Type ensure that Tab-separated File (.xls) is selected. 
9. Under Save Location, ensure My Device is selected. 
10. Click Download. 
11. Open the file you downloaded. You will need to edit this file to remove any grade information you do not wish to have, but the full roster of students will be contained within this file.