Roster Import Layout Instructions

Last Updated on May 6, 2026

This topic shows you how to complete the CSV roster file layout, shown above. First, download the CSV roster file and save it to your system.
Note: The file downloads as an .xlsx file. You must save it as a CSV file after downloading it (see Save the Excel File as a CSV File).

Use the table and rules listed below to help ensure the CSV roster file is completed correctly and will upload to Rostering.

When the CSV is completed and saved to your system, you can import the roster into Rostering.

Roster Import File Layout Guide and Rules
Ref# Column Name Maximum Length Required (Y/N) Acceptable Values Description
A State Student ID 15 Y
    • A-Z, a-z
    • 0-9
 The State Student ID must already exist in DRC INSIGHT Portal
B Student Last Name 35 N
    • A-Z, a-z
 The Student Name fields are included in the layout to assist the user creating the file, or DRC staff researching file errors. The fields are not used in the upload process.
C Student First Name 35 N
    • A-Z, a-z
 The Student Name fields are included in the layout to assist the user creating the file, or DRC staff researching file errors. The fields are not used in the upload process.
D Teacher First Name 35 N
    • A-Z, a-z
 The Teacher Name fields are included in the layout to assist the user creating the file, or DRC staff researching file errors. The fields are not used in the upload process.
E Teacher Last Name 35 N
    • A-Z, a-z
 The Teacher Name fields are included in the layout to assist the user creating the file, or DRC staff researching file errors. The fields are not used in the upload process.
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
 Enter the roster name

Rules for the CSV roster file:

  • Teachers can import rosters for multiple schools by including the rosters in the CSV file and selecting a district instead of an individual school. They must also include each school’s roster in the CSV file.
  • 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 student 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.

Save the Excel file as a CSV file:

Open file in Excel.

On the menu bar, click File, then Save As… The Save As dialog box displays. The line at the bottom of the dialog reads: Save as type:

  1. Click on the down arrow to the right of the line to open a drop-down menu.
  2. Scroll down and select CSV (Comma delimited) (*.csv).
  3. Click Save.