Importing SAT Test Data

Importing SAT test data into Aware requires a certain file format. We offer support for SAT, PSAT 8/9, PSAT 10, and NMSQT files. When accessing data in the College Board platform, ensure that all file exports are saved as a CSV to import successfully into Aware. For additional information on accessing that export, refer to College Board’s help documentation. 

Note: If you make changes to your file, ensure to save the file as a CSV and that the date fields do not get overridden to another format.

SAT File Format Requirements

To ensure a successful upload, verify that all of the fields listed in the SAT Required Fields table are present, have the exact Field Header Value in the top cell of the column, and are appropriately formatted. 

Some fields require data in the column, and other fields do not. If a field does not require data, the column does still have to exist in the file. Any field that is optional can be empty. 

If additional columns exist other than the ones listed below, you can still import the file. However, not all of the data in the extra fields will be available in a data view.

There are a number of fields that come with score data that are not listed in the SAT Required Fields table that will be important to include for the import to be meaningful. For instance, these score fields are required for section performance to be linked to students. However, lacking these columns or the data in them will not stop the import from succeeding. 

Example fields: 

• LATEST_SAT_EBRW
• LATEST_SAT_MATH_SECTION

PSAT 8/9 File Format Requirements

To ensure a successful upload, verify that all of the fields listed in the PSAT 8/9 Required Fields table are present, have the exact Field Header Value in the top cell of the column, and are appropriately formatted.

Some fields require data in the column, and other fields do not. If a field does not require data, the column does still have to exist in the file. Any field that is optional can be empty. 

If additional columns exist other than the ones listed below, you can still import the file. However, not all of the data in the extra fields will be available in a data view.

There are a number of fields that come with score data that are not listed in the PSAT 8/9 Required Fields table that will be important to include for the import to be meaningful. For instance, these score fields are required for section performance to be linked to students. However, lacking these columns or the data in them will not stop the import from succeeding. 

Example fields:

• LATEST_PSAT_EBRW
• LATEST_PSAT_MATH_SECTION

PSAT 10 and NMSQT File Format Requirements

PSAT 10 and NMSQT are recognized as separate tests when importing. All PSAT and NMSQT tests will still be recognized as a PSAT test type, but the name of an NMSQT test will show NMSQT in the file name. 

Example names:

• October 2023 PSAT/NMSQT, Grade 10
• November 2023 PSAT 10, Grade 10

To ensure a successful upload, verify that all of the fields listed in the PSAT 10 and NMSQT Required Fields table are present, have the exact Field Header Value in the top cell of the column, and are appropriately formatted.

Some fields require data in the column, and other fields do not. If a field does not require data, the column does still have to exist in the file. Any field that is optional can be empty. 

If additional columns exist other than the ones listed below, you can still import the file. However, not all of the data in the extra fields will be available in a data view.

There are a number of fields that come with score data that are not listed in the PSAT 10 and NMSQT Required Fields table that will be important to include for the import to be meaningful. For instance, these score fields are required for section performance to be linked to students. However, lacking these columns or the data in them will not stop the import from succeeding.  

Example fields: 

• LATEST_PSAT_EBRW
• LATEST_PSAT_MATH_SECTION

Troubleshooting Failed SAT Imports

The file should load data as long as the following criteria are met:

• All of the fields in each respective table are present, even if the optional ones contain no student data.
• All of the fields have the correct column name in the header.
• The fields marked “Required” have data.
• The file is saved as a CSV.

If there are any required fields not present, manually add them to the spreadsheet and give them the proper label. For additional help using the SAT exporter, refer to College Board’s help resources. Fields with required data may need to be populated if they weren’t automatically.