Roster columns for U.S. higher education institutions
Alternatively, see Roster Columns for Institutions Other Than U.S. Higher Education.
Your roster file must include the following columns with the indicated column headings specified in the first row:
Heading | Description |
|---|---|
Required: Student's email address is used as the student's username. | |
firstname | Required: Student's given name, up to 32 characters. |
lastname | Required: Student's surname, up to 32 characters. |
password | Required: Enter initial passwords for students with no preexisting account. Must be 6-17 characters and include at least one number and one capital letter. |
student id | Optional: Student's institutional ID, up to 20 characters. |
- Column headings are not case sensitive.
- Columns can be in any order.
- Columns with other column headings are ignored.
- Students can be listed in any order.
- Student data must not contain empty rows.
- Student data is case sensitive.
Valid roster file formats
Your roster file must be saved in one of the following formats:
- .xlsx Excel spreadsheet
- .xls Excel 1997-2004 spreadsheet
- .ods OpenDocument spreadsheet
- .csv comma-delimited text file
- .tsv tab-delimited text file
Example Roster Spreadsheet email firstname lastname password student id dmwhite@example.org Daniel White dW250708 250708 jgrodriguez@example.org John Rodriguez jR340067 340067 mrallen@example.org Mary Allen mA242052 242052 psgarcia@example.org Patricia Garcia pG306586 306586 bsnguyen@example.org Betty Nguyen bN326098 326098 Download as OpenDocument roster file Download as Excel roster file Example Comma-Delimited Roster File Download comma-delimited roster file Example Tab-Delimited Roster File Download tab-delimited roster file