Importing Participants and Registrations

Last Updated on May 12, 2026

Users can access data for all Missouri Testing Programs.

  • All imports are program agnostic.
  • Records successfully uploaded using the Participants and Registration file are automatically registered for a test session. For this reason, DRC recommends uploading the Participants and Registrations file after uploading the Accommodations file.
  • Restricted Access will default to off. To turn on, see Register Participants for an Assessment.
  • If you only need to import Participants, see Importing Participants Only.

After you have created the Participants and Registrations File Import file, follow these steps to import them into the Portal

To import a Participant and Registration file, do the following:

  1. Confirm (change if needed) the district and enter the name or code of the school or district to which you want to import.
    • Note:
      • Users can import for multiple schools by selecting a district instead of an individual school. They can then include student records for each school in the district in a single CSV file.
      • If users want to import for a single school, the CSV file must contain student records for only that school.
  2. On the Import Management page, click the Start New Import button and the New Import window displays.
  3. Complete the fields as follows:
    • Import Job Title: Enter a recognizable name.
    • Select Import Type: Select Participants and Registrations.
    • Select a Registration Window.
    • Click Browse to navigate to the files on your system or you can drag and drop the files into the drag and drop area of the window.
  4. Click the Start Import button to import the files into Import Management. The import job displays in the Import Management grid. While the job is being processed, the status for the job displays as In Progress.
  5. When the import job completes, the status is COMPLETED or VALIDATION ERRORS.
    • If the job is in VALIDATION ERRORS status, click the job to display the error report. Update your CSV file to fix all of the errors shown in the error report. Once you have corrected the errors in the CSV file, restart the import process (return to Step 2). Although the records that do not have errors are not required to be uploaded again, it is often faster and easier to simply upload the entire file again.
    • If the job is in COMPLETED status, click the job to display the Details report, which includes information about each imported record.

Participants and Registrations Import Layout Instructions

The file layout is provided in the table below and the sample import file is provided here (link). Note, the sample import file downloads in Excel (i.e., XLSX) format rather than in CSV format. If districts wish to use the sample import file for a test run, they must first re-save it as a CSV file.

This topic shows you how to complete the Participants and Registrations Sample Import File. First, download the Participants and Registrations Sample Import 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 Import file is completed correctly and will upload.
When the CSV is completed and saves to your system, you can import the Participants and Registrations file into Import Management.

Participants and Registrations Import File Layout Guide and Rules
Ref# Data Field Max Length Required (Y/N) Acceptable Values Description
1 District Code 6 Y Numeric – 0-9
Including leading zero(s) as applicable		 Assigned 6 digit district code

The district code must match the district code displayed in the Portal District dropdown menu.

The district code must be the same for all records in the file
2 School Code 4 Y Numeric – 0-9
Including leading zero(s) as applicable		 Assigned 4 digit school code

The school code must match the school code displayed in the Portal School dropdown menu.
3 MOSIS ID 10 Y Numeric – 0-9
Leading zero(s) are not applicable for MOSIS IDHome / Private ID
#6 Digit District ID# 4 digit Student ID		 Student’s State ID

For home/private IDs only, the max length is 12.
4 Last Name 60 Y A-Z, a-z, hyphen (-), underscore(_), apostrophe (‘), period (.), space ( )
60 character limit		 Last name of Student
5 First Name 60 Y A-Z, a-z, hyphen (-), underscore(_), apostrophe (‘), period (.), space ( )
60 character limit		 First name of Student
6 Middle Name 60 N A-Z, a-z, hyphen (-), underscore(_), apostrophe (‘), period (.), space ( )
60 character limit		 Middle name of Student
7 Suffix 10 N A-Z, a-z, 0-9, hyphen (-), underscore(_), apostrophe (‘), period (.), space ( )

May be blank

 Suffix of Student
8 Date of Birth 10 Y MM/DD/YYYY
MM/DD/YY
M/D/YY		 Student Date of Birth
9 Grade 2 Y 00,01,02,03,04,05,06,07,08,09,10,11,12 Grade Level in which the student is currently enrolled for the current school year.

EOC: 00,01,02,03,04,05,06,07,08,09,10,11,12
Grade-Level: 03,04,05,06,07,08
10 Gender 1 Y F = Female
M = Male		 Indicates student’s gender
11 Race American Indian or Alaska Native 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
12 Race Asian 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
13 Race Black or African American 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
14 Race Hispanic or Latino 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
15 Race Native Hawaiian or Other Pacific Islander 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
16 Race White 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
17 Race Multi-race 1 N Y = Yes,
or Blank		 A race field must be selected. Only 1 race field is allowed and if more than 1 race is selected, record will error.
18 Testing Program 11 Y EOC = End-of-Course Assessments
Grade-Level = Grade-Level Assessments		 This field identifies the test administration.
19 Registration Name 100 Y Alphanumeric
A-Z, a-z, 0-9, hyphen (-), underscore(_), apostrophe (‘), period (.), space ( )		 Name of Registration to be used to group or sort students.

To include Educator First Name Last Name and Period (if applicable)
20 Subject 6 Y EOC
ALGEB1 = Algebra I
ALGEB2 = Algebra II
GEOME1 = Geometry
ENGLI1 = English I
ENGLI2 = English II
BIOLO1 = Biology
PHYSC1 = Physical Science
AMHIS1 = American History
AMGOV1 = Government
PERSFN = Personal FinanceGrade-Level
ELA = English Language Arts
MATH = Mathematics
SC = Science		 Subject in which the student will be assessed (1 Subject Per Row)

American History and Physical Science are not applicable for the EOC Fall Summative assessment.

Geometry, English I, Physical Science, and American History are not applicable for the EOC Summer Summative assessment.
21 Testing Codes 4 N HMS = Home School
PRIV = Private School		 Only 1 Testing Code should be selected.

This field is only applied when a registration is created. It will not update previously created registrations.

This field applies to Summative assessments only, not applicable for Practice Forms or Testlets.

Save an 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.