Export the roster to a CSV File
Updated 22 May 2024
You can export your roster to a comma separated value (CSV) file. The exported roster includes the student name, username, email, and the most recently saved status, role, roster access, and subscription type information. Roster access is automatically set to FALSE in the CSV file for both Student and Teaching Assistant roles.
- Select the enrolled number for the course on the My Courses page.
For example, Enrolled: 10.
The roster opens.
- Select . The exported file saves to your computer with the name course ID-roster.csv.
To open the CSV file use any text editor or spreadsheet application that supports CSV files, such as Microsoft® Excel.
Subscription types do not display in the roster list. They only display in the exported CSV file, and might include:
- Temporary access (Temp) — Allows full access to the course for a limited time.
- Time-based access (TBA) — Lasts for less time than the full duration of the course at a reduced price.
- Life of edition (LOE) — Gives access to the course materials until they are no longer available in the catalog. The student pays once and can enroll in multi-semester courses that use the same course materials for as long as it takes to complete the curriculum.
- None — No access to the course materials.
If applicable, the exported roster might include course access expiration dates for temporary access and time-based access subscription types, or payment types for LMS courses.
If your institution or school lets students opt in or opt out to pay the school for access to Pearson materials through your learning management system (LMS) course, one of the following payment types shows for each student listed in the roster export file.
- Opted in to institution payment — The school bills the student for access to the course materials.
- Opted out: paid to Pearson — The student completed online payment with an access code, credit card, or, if available, PayPal or Apple Pay.
- Opted out: not yet paid to Pearson — The student is inactive. To access the course, the student can pay Pearson or opt back in to pay the school, unless the opt-in period has expired.