Create PSAT/NMSQT test score files

userXello Admin Xello productAccounts Time2 minutes

Before you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files new tab

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

Scroll to view table contents

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