Before you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files
Build the PSAT/NMSQT test score files by following the format indicated below.
TestScore_PSAT(.txt or.csv)
This file contains the SAT test scores.
| Column Name | Type | Description |
|---|---|---|
| Student ID | char(15) | The unique student ID for the student. |
| Test date | Date |
Date when test was taken. Valid date in mm/dd/yyyy format |
| Grade when tested | Numeric | Student's grade when test was taken. |
| Total score | Numeric |
Total score. Valid values are between 320 and 1520 |
| Reading and writing | Numeric |
Reading and writing score. Valid values are between 160 and 760 |
| Math | Numeric |
Math score. Valid values are between 160 and 760 |
| Selection Index | Numeric |
National Merit Scholarship Corporation (NMSC) Selection Index. Valid values are between 48–228 |
Example:
Student ID|Test date|Grade when tested|Total score|Reading and writing|Math|Selection Index
123456789|01/01/2026|9|600|300|300|100