Download Blackboard Course Roster as a Spreadsheet

Information on how to save a course roster as a spreadsheet for opening in Excel and other spreadsheet programs.

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 the Download Gradebook link in the upper-right corner, next to the settings gear. 
5. Under Grade Records, select Full Gradebook. 
6. Under Record Details, select at least one column. You may select more if you would like that data. 
7. Under File Type ensure that Tab-separated File (.xls) is selected. 
8. Under Save Location, ensure My Device is selected. 
9. Click Download. 
10. 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.