Exporting a Classlist to Excel

In the ever-evolving landscape of digital education, D2L's Classlist feature stands out as a powerful tool for educators, offering a seamless blend of functionality and convenience. This feature not only simplifies class management but also enhances communication and organization within the digital classroom.

The Classlist in D2L Brightspace is a versatile component that provides educators with a comprehensive overview of enrolled students. This intuitive feature allows for easy monitoring of student engagement, facilitates direct communication, and, importantly, supports exporting the entire class list for printing or saving as a PDF. This export functionality is particularly useful for maintaining offline records, preparing for classes, or tailoring individualized educational approaches. By integrating such capabilities, the Classlist feature becomes an indispensable part of managing and interacting with students in the digital education environment.

Note: This option is offered as an option to obtain a spreadsheet of the Classlist, as that can only be obtained via Grades and not from Classlist itself.

Step 1

From the NavBar -under Assessments (or from Course Admin), select Grades. 

Step 2

Select the Enter Grades tab.

Step 3

Select the Export button. 

Step 4

(Optional) If you want to export out students in specific sections or groups, Using the dropdown under Export Grade Items For, select either Sections or Groups Sections and then select Apply.  Select the group or section you want to export out, and select Apply one more time.

Step 5

Select the radio button for Both under Key Field and use the available dropdown under Sort By to choose a spreadsheet sort option, if desired.  

Step 6

Uncheck the box for Points grade.
 

Step 7

Under User Details, select the checkboxes for Last Name, First Name, and Email; select the checkbox for Section Membership, if desired, as well. 

Step 8

Select either the individual checkboxes to the left of each item or select the select-all checkbox in the upper left of the table and uncheck the checkboxes for all grade items. 

Step 9

Select Export to CSV or Export to Excel; when the green status bar says Complete, select Download and retrieve your file from your device’s designated download folder. 

Step 10

Select the Close button when finished, and then select the Cancel button to leave the Export Grades menu.