How to Download a Class Roster to Excel from Your Blackboard Course

    You can download your class roster into an Excel spreadsheet from your Blackboard course to keep a hard copy of the names of your students enrolled in your course or to manually track class attendance.  (To take attendance electronically within your Blackboard course, use Qwickly Attendance). 

    The spreadsheet will list your students first name, last name, NetID (username), G number (Student ID), last access date and availability.  

    *Please note that your official class roster can be found in Patriot Web. Click here for more information.

    Under the Control Panel, click on Grade Center and then select Full Grade Center.


    Grade Center Full Grade Center Access

    Point to Work Offline and select Download.

    Download Roster Work Offline Download

    On the Download Grades page, click in the radio button next to User Information Only. Under Options, select either the tab delimited (.XLS) or comma delimited (.CSV) delimiter type. Choose comma delimited for importing to third-party applications that do not support Excel. Submit the page.

    Download Roster Work Offline Select Options

    On the Download Grade page, click on the Download button. 

    Download Roster Grade Page

    This will download a CSV or tab-delimited spreadsheet which lists one student per row. You can open this file in Excel.