Upload Student Registration Data

Steps to Complete Registration

Schools should reserve one week to complete the initial three steps below to upload and submit student data. The following tasks all occur within the SAT Suite Ordering and Registration (SSOR) site. This week is followed by a week dedicated to reviewing and validating student data.

Need help with SSOR? Check out this short demo on how to access SSOR, order tests, and register students.

SAT Suite Data Coordinator

The SAT Suite Data Coordinator role manages registration data. See Accessing SSOR for more details.

  1. Upload Registration Data
    • Download the SSOR Registration template. You must download and use this template, a comma delimited (.csv) format.
    • You may need to work with your district or student information system administrator to extract and format student data from your systems to create your SSOR student registration data file upload.
    • Add student data to the template following the Registration Data File Upload Specifications.
    • Copy your data into the template .csv file. Please don’t try to type the same headers into your own .csv file, as you’re likely to make a mistake and encounter file upload errors.
    • Test taker data must be submitted in the correct format, or you'll receive errors in SSOR that require you fix the data in your upload.
  2. Review and Fix any Errors or Warnings
    • SSOR processes your uploaded file and checks for errors and warnings.
      • First, SSOR checks for file format errors. This is a quick process, so wait for this to complete after you upload your file.
      • Second, SSOR checks for data errors and warnings. This process may take up to 8 hours to complete, but you'll receive an email when it's completed. Wait for the email and sign back into SSOR after you receive it to see if there were any data errors and warnings identified.
    • Download and review the error and warnings report within SSOR to see any errors or warnings that are flagged.
    • Fix the errors in your original data file or in a new template and upload your corrected student data. Don't upload the error and warnings report.
    • All errors must be fixed, but it's possible some warnings don't need to be fixed. You'll be able to proceed in the upload flow once all errors are resolved.
  3. Submit Data
    • Once SSOR has validated there are no data errors in your file upload, you must submit the student data. Before you submit, SSOR will display a sample of up to 10 student records for onscreen review. Be sure to review this sample to check for any global data issues (e.g., first and last names are swapped).Important for Districts: Once you submit your data file, you cannot submit a replacement file. Ensure all data including all intended schools are included in your data file.
    • Once you've completed the submission, download and fill out the data coordinator email template. Then, email that to your test coordinator and SSD coordinator to let them know that your registration file is ready for validation.
      Data Coordinator Email Template
    • After data has been submitted, a student roster will be made available for the SAT Suite Registration role user(s) to validate in an online registration roster in SSOR (Step 2 in SSOR).

Additional Details

For additional support, download our Digital Registration Guide for Districts and Schools. This guide is intended for use by district and/or school staff whose primary role is in the registration process. Test coordinators can also find this information in their Test Coordinator Manual.

Note: Homeschooled or away students may reach out to participate in your school's administration. You will need to collect the required data to register these students so they can be included when test taker information is uploaded in SSOR.

Important: Validating the Attending AI Code on the student’s SSOR record is critical for protecting student privacy. Make sure the Attending AI Code is the code for the school the student attends, as this is the school the student’s scores will be sent to. A blank Attending AI code will default to the Testing AI code on the student’s SSOR record.

Students should be registered in SSOR for digital testing before their testing start date. SAT Suite registration is now available in SSOR for fall 2024 testing.

To access SSOR for registration, you must be assigned the appropriate role(s) by your organization's SSOR access manager. More information on this process can be found in the following Help Centers, under the Accessing section.

Registration Data File Upload Specifications

Caution: Test taker information must be uploaded and submitted using the SSOR Registration template, a comma delimited (.csv) format. If you use a student information system, we recommend exporting student data and carefully transferring it to this template in the correct format.

Important: If you export data from your student information system, you may need to update some of the values to adhere to the data file upload specifications; otherwise you'll receive errors that you must fix. Additionally, check that extra rows with empty spaces weren't appended during your data export and remove any rows added in error before you upload your file; otherwise, you'll receive errors that you must fix.

IMPORTANT TIP: These specifications are unchanged from the 2023–24 school year.

Notes about submission:

  • For data to be processed correctly, files must be submitted with columns in the correct order and with the exact Column Headers (see table below) positioned in the first row of the data.
  • Your file name may not contain special characters.
    • Acceptable file name characters: uppercase letters (A-Z), lowercase letters (a-z), numbers (0-9), period ( . ), hyphen ( - ), parentheses ( ( ) ), underscore ( _ ), space ( ).
    • If any unaccepted characters are present, you'll receive an error message and will be required to fix the file name and reupload your file.
  • The following columns are required (in the specified order) in the file upload; however, not all columns require data.
    • Required data: Testing AI Code, First Name, Last Name, Date of Birth, Gender, Grade, Test, Season.
    • Optional data (column headers still required): Attending AI Code, Middle Initial, School Student ID, District Student ID, State Student ID.

Here is a complete layout of the columns in the template. Review the layout below so you understand the expected data values you should provide in each column of your file. Additionally, be sure the data in your file doesn't include any leading or trailing spaces or you'll receive errors and need to fix before proceeding.

Column Position in .csv File Column Header (to use in your file upload) Description Required? Allowable Values
A Testing AI Code The Testing AI Code is the 6-digit AI/CEEB code (which may include a leading 0) of the school where students are testing. This value will determine which school's registration roster to upload the student's data to in SSOR. The Testing AI code must be a valid or existing code and should match the submitting organization's AI/CEEB Code (for schools) or must be a corresponding AI/CEEB Code of a school included in a district's SSOR order (for districts). Required Length: 6 characters
Format: Numeric
B Attending AI Code The Attending AI Code is the 6-digit AI/CEEB code (which may include a leading 0) of the school the student currently attends. This field is used for reporting scores to the student's school after test day. If the school the student attends is the same school the student is testing at (the AI/CEEB Code used in the Testing AI Code field), then you can leave this field blank. Otherwise, you must provide the valid or existing AI/CEEB Code that corresponds to the school the student attends. If a homeschooled student is testing at your school, you will need to enter the appropriate AI/CEEB code for their state. Read more about registering away students. Optional Length: 6 characters
Format: Numeric
C First Name Provide the student's legal first name in this field. You must provide their legal first name and should not provide a preferred name. Any names provided that are longer than the maximum number of allowed characters will be truncated. Required Length: Maximum of 20 characters
Format: Alpha (A–Z), hyphen ( - ), space ( ), apostrophe ( ' )
D Middle Initial Provide the student's middle initial. This is an optional field and may be left blank. Don't delete this column in your .csv data upload even if you don't plan to provide data in this field for any students. Optional Length: 1 character
Format: Alpha (A-Z)

Leave blank for no response.
E Last Name Provide the student's legal last name in this field. Any names provided that are longer than the maximum number of allowed characters will be truncated. Required Length: Maximum of 35 characters
Format: Alpha (A-Z), hyphen ( - ), space ( ), apostrophe ( ' )
F Date of Birth Provide the student's date of birth in this field.

IMPORTANT: You may need to update the formatting of this column in your .csv file to ensure that the correct format is retained.
Required Length: 10 characters
Format: MM/DD/YYYY, MM/D/YYYY, M/DD/YYYY, M/D/YYYY
G Gender Provide the student's gender in this field. Required Length: 1 character
Format: Alpha

F = Female
M = Male
A = Another
H Grade Provide the student's grade in this field. You can only provide a grade that is covered by the school or district order for which you are uploading data. Required Length: 2 characters
Format: Alphanumeric

Acceptable grades:
6 = 6th grade
7 = 7th grade
8 = 8th grade
9 = 9th grade
10 = 10th grade
11 = 11th grade
12 = 12th grade
N = No longer in high school
1C = First year in college
2C = Second year in college
I Test Provide the test the student is taking in this field. Reminder: When uploading student data, you can only do this one test at a time. You cannot have a .csv file upload that includes more than one test. Required Length: Maximum of 3 characters
Format: Alphanumeric

PNM = PSAT/NMSQT
P89 = PSAT 8/9
P10 = PSAT 10
SAT = SAT School Day
J Season Provide the season when the student is testing. The season provided must be the season that is covered by the school or district order for which you are uploading data. Required Length: 1 character
Format: Alpha

F = Fall
S = Spring
K School Student ID Provide the student's school ID in this field. We recommend you provide a student ID for purposes of data matching when scores are delivered after test day. You shouldn't use the student's Social Security Number in this field. Additionally, if there are two students with the exact same details (e.g., twins), you should use this field to distinguish between the two students. If you decide not to provide this data, don't delete this column in your .csv upload, just leave all fields blank. Optional Length: Maximum of 30 characters
Format: Alphanumeric (A-Z, 0-9), No spaces allowed

Leave blank for no response
L District Student ID Provide the student's district ID in this field. You shouldn't use the student's Social Security Number in this field. If you decide not to provide this data, don't delete this column in your .csv upload, just leave all fields blank. Optional Length: Maximum of 30 characters
Format: Alphanumeric (A-Z, 0-9), No spaces allowed
M State Student ID Provide the student's state ID in this field. You shouldn't use the student's Social Security Number in this field. If you decide not to provide this data, don't delete this column in your .csv upload, just leave all fields blank. Optional Length: Maximum of 30 characters
Format: Alphanumeric (A-Z, 0-9), No spaces allowed

If you attempt to upload a student registration data file, but you receive errors in SSOR, review the Registration Guide for more information on resolving data upload errors, including troubleshooting steps.

For more information on registration, check out our Help Center: