Roster Import File Layout

Last Updated on August 21, 2026

This topic shows you how to create the CSV roster file for import. First, download the TerraNova Roster Sample File CSV and save it to your system.

Use the table and rules listed below to help ensure the CSV roster file is completed correctly and will import successfully to Rostering. When the CSV is completed and saved to your system, you can import the roster into Rostering (see Importing Rosters).

Roster Import File Layout Guide and Rules
Ref# Column Name Maximum Length Required (Y/N) Acceptable Values Description
A State Student ID 10 Y
    • A-Z, a-z
    • 0-9
 The State Student ID (also called Student ID) must already exist in Student Management for the current academic year at the selected district and/or school.
B Student Last Name 35 N
    • A-Z, a-z
 Student Last Name as recorded in Student Management.
C Student First Name 35 N
    • A-Z, a-z
 Student First Name as recorded in Student Management.
D Teacher First Name 35 N
    • A-Z, a-z
 Teacher First Name as recorded in their User Profile.
E Teacher Last Name 35 N
    • A-Z, a-z
 Teacher Last Name as recorded in their User Profile.
F Teacher Email 50 Y Must match the teacher’s email address (username) as it is defined in User Management The Teacher Email must already exist in DRC INSIGHT Portal User Management in order to be assigned to a Roster.
G Roster Name 50 Y
    • Alphanumeric
    • A-Z, a-z, 0-9, “-“, “‘”, space
 The Roster Name within the CSV file must be unique for your site. If a file is uploaded with the same Roster Name and the same Teacher Email, the students imported in the new CSV file will be added to the existing Roster.

Rules for the CSV roster import file:

  • The Roster Name within the CSV file must be unique. If a file is uploaded with the same Roster Name and the same Teacher Email, the students imported in the new CSV file will be added to the existing Roster.
  • The CSV file must contain a header row that includes all the Column Name titles in the table above.
  • The CSV file must contain data in the order listed in sample CSV. 
  • The fields cannot be longer than the value in the Maximum Length column in the table above.
  • The file must be in comma delimited (.csv) format. Commas are not allowed in any field. 
  • In the Portal, students and teachers must already exist within the district and school for which the teacher/class roster is being created. 
  • In order to update an existing roster, the teacher email and roster name must be an exact match to the roster being updated.
  • If using Teacher/Class Rosters for populating Roster Name on printed Home Reports (if ordered), ensure that the first roster a student is placed in is the one you want represented.