beginning of content:

Higher Education Assessment Reporting Help

All SAT and SAT Subject Test scores are reported on paper or electronically in the higher education assessment reporting portal. You’ll sign in to the portal using the same College Board account you use for other College Board applications, such as College Board Search.

Electronic score files are delivered on a rolling basis through the Download Center. You’ll receive them in the format specified on your annual options form: comma-delimited or fixed-width. If you need to change your SAT preferences, contact us.

Sign in to the score reporting portal now.

Get the latest delivery schedule.

Important:

What's New

You can now access a trends report in the Report Center and view student essays in the Essay Center.

 

Ten enhanced Executive Summary Reports are available in the Report Center for Enrollment Planning ServiceTM (EPS) subscribers.

Report Center

The Report Center provides access to the SAT Trends Dashboard and, for Enrollment Planning ServiceTM (EPS) subscribers, Executive Summary Reports.

SAT Trends Dashboard

The SAT Trends Dashboard is a snapshot comparing two years of SAT data for your college. Two dashboards are available: One compares year-to-date data for this year with end-of-year data for last year; the other compares last year’s data with the previous year’s. EPS subscribers can also view archived Executive Summary Reports in College Board Search.

Dashboard data include:

  • Monthly score-send volume across cohorts
  • Monthly score-send volume by cohort
  • Sex, ethnicity/race, first-generation, low socioeconomic status, and other demographics
  • Top 10 intended majors
  • Overlap data for your top competitor
  • Top five geomarkets and feeder schools
  • Score-send volume and mean scores by state and by country
  • SAT Subject Test score-send volume and mean scores by subject

The current year’s dashboard is updated weekly.

 File for Download

SAT Trends Dashboard Report: Interpretive Guide

Use this guide to understand the SAT Trends Dashboard Report, which provides insight into students who are sharing their score reports with a particular higher education institution.

.pdf

767 KB

  • In the SAT Score Senders Volume by Month report, students who send their scores more than once in one month are counted once in that month. Students who send scores in multiple months are counted once in each month.
  • In every other report, each student who sends their scores to your college is counted once, even if they’ve tested multiple times. 
  • Statistics reported for an academic year include all scores sends for that year.
  • Statistics reported for a cohort include all score sends for that cohort, regardless of the year they were sent.
  • Mean scores are not reported for populations below 10.
  • If a student sends scores from multiple administrations to your college, only the most recent scores are used to calculate mean scores.
  • Student location for geographic reports is determined by the student’s high school address.
  • Notes on the Unique SAT Prospective Applicants to Date report:
    • The “All Students” and “Sex” sections provide data for the entire population of score senders, from all locations.
    • The “Country of Origin” section temporarily omits score sends from the U.S. territories.
    • Data in all other sections of this report include domestic students only. Students from the U.S. territories and international students are omitted.

EPS Executive Summary Reports

Executive Summary Reports summarize the data of unique SAT takers who requested an official test score be sent to a designated institution. Each student is counted once using their most recent score information. If you subscribe to EPS, ten newly enhanced Executive Summary Reports are available in the Report Center.

Executive Summary Reports for the current academic year are updated weekly to reflect changes in report volume. Previous years’ reports reflect a point in time.

Executive Summary Reports can include data in the following categories:

  • Ethnicity/Race
  • Mobility
  • Low SES
  • First Generation
  • Performance
  • Ethnicity/Race – Reported in aggregate. Students who select more than one ethnicity/race are counted in only one category.
  • Mobility – Students sending 50% or more of their scores to institutions outside their home state (defined by the student’s home address) fall in the “Out-of-state Mobility” category. If they send more than 50% of their scores to institutions within their home state they fall within the “In-state Mobility” category.
  • Low SES – Students identified through census and other data as likely coming from families with annual incomes below $40,000.
  • First Generation – Based on student responses when taking the SAT, students fall in one of four categories: those whose parents have no college experience (“No College”), have some college experience (“Some College”), have a Bachelor’s degree or higher (“Not First Generation”), or students who did not respond to the question (“No Response”).
  • Performance – 2016 cohort mean scores are calculated based on the old SAT. Beginning with the 2017 cohort, all SAT scores are reported on the new scale. Due to changes in the SAT, 2017 cohort reports will not contain mean score change data. Note: mean scores are calculated for any category that has at least 10 reported scores.
  • Summary of All Segments – General
    • Summarizes SAT reports by Sex, Mobility, Ethnicity/Race, Family Income, Low SES, First Generation. Shows total volume, total volume from previous year, and mean scores for each category. [3 pages]
  • Summary by Ethnic Distribution
    • Summarizes SAT reports by ethnicity. Shows SAT report volume for current cohort, for previous cohort year, and mean scores for each ethnic sub-category. [1 page]
  • Summary by Intended Major
    • Summarizes SAT reports by the 38 intended major sub-categories. Majors are reported based on students' first choice major. Shows Sex and Ethnicity/Race for each major sub-category. [4 pages]
  • Top Geomarkets – Summary
    • Summarizes institution’s top 25 geomarkets. Shows total volume of SAT takers with mean scores, and institution’s volume and mean scores for each geomarket. [3 pages]
  • Top Geomarkets – Detail
    • Details institution’s top 25 geomarkets. Shows student SAT volumes and mean scores by Sex, Mobility, Ethnicity/Race, and Intended Major. Also shows two college competitor lists for each geomarket. [200 pages]
  • Top Feeder High Schools – Summary
    • Summarizes institution’s top 50 high schools (based on volume of SAT reports). Shows volume of SAT takers, mean scores, and mean score change from previous year for each high school, as well as in total for institution. [4 pages]
  • Top Feeder High Schools – Detail
    • Details institution’s top 25 high schools. Shows SAT volumes and mean scores by Sex, Ethnicity/Race, Low SES, First Generation, and Intended Major. Compares school and institution total volumes and mean scores for each category. [75 pages]
  • Competition by Overlap Takers
    • Highlights institution’s top competitors based on overlap volume of SAT scores sent by students to other institutions. [3 pages]
  • Competition – Largest Geomarkets of Your Top Competitors
    • Highlights top 10 geomarkets of institution’s top 9 overlap competitors. Shows possible new markets for outreach. [2 pages]
  • Competition – Top Competitors in Top Geomarkets
    • Highlights institution’s top 10 geomarkets (based on volume of SAT reports). Shows top 10 competitors for each geomarket. [2 pages]

Essay Center

Visit the Essay Center to view or print individual student essays or to set up an essay batch file. You’ll need the Essay Locator ID for each essay.

Essay Center Tips

  • The Essay Locator ID is included in electronic data files and printed in the upper right section of the paper score report.
  • Each essay has a unique 8- or 12-digit ID. When you create a batch file, you’ll need to add multiple IDs for students with more than one essay. When you look up a student individually, however, you can enter just one ID and see all essays for the scores that student sent to your college.
  • On the Individual Essay screen, scores are hidden by default. Click Show Scores to reveal them.
  • If a student’s essay scores and images are unavailable, it might be because their scores are canceled or on hold.

Essay Batch Files

  • Create an essay batch file by entering anywhere from 2 to 3,000 Essay Locator IDs.
  • Check IDs carefully: You won’t see an error on the screen if you enter an invalid ID. Invalid IDs are excluded from the batch file. Invalid IDs of 8 or 12 digits are listed in the accompanying error log. If you can’t find a student in either the batch file or the error log, you might have entered an ID that was not 8 or 12 characters.
  • After you click Submit, the file should be posted to the Download Center within 24 hours unless your institution made a request earlier in the day. We fulfill only one request per institution per day. Visit the Download Center to monitor the progress of your files.

Download Center

If you have the data files management role, you can download SAT data and essay batch files from the Download Center. You’ll see a Download Center button in the top menu of the Assessment Reporting tool. You can also see an audit trail of who has downloaded the file. You’ll receive a notification email each time a new data file is ready.

Sample data files have also been posted to the Download Center so that institutions completing implementation of the SAT data file layout can use them to test their systems. You can download sample files and generate test notification emails to mimic the notification emails that the system will send when actual score files are posted. This allows for testing of automated systems.

Note: Multiple data files can be posted to the Download Center on a single day. When files are posted to the Download Center, they will be posted using a standardized file naming convention:

  • Fixed width (TXT) format: [DI CODE]_[YYYYMMDD]_[HHMMSS].txt
  • Delimited (CSV) format: [DI CODE]_[YYYYMMDD]_[HHMMSS].csv
  • Compressed format: [DI Code]_SAT_ Essays_[YYYYMMDD]_[HHMMSS].zip
Naming Convention Key
File Name Element Description
[DI Code] The DI code the file is for
[YYYYMMDD] The date the file was generated
[HHMMSS] The time the file was generated

Download Using a Web Service

To download files automatically, call our RESTful web service, PAScoresDwnld. There are two ways to trigger your IT system to call the web service to download a file:

  1. Use the notification email as the trigger. Emails containing the file name are sent automatically whenever a new file is posted. You can also generate the emails manually from the portal for development and testing.
  2. If you prefer, you can look for new files by using the web service to get a file directory listing periodically.

In both cases, the web service uses your credentials (the same credentials you use to sign in to the reporting portal) and the data file name to return the pre-signed URL. The pre-signed URL enables the transfer of the file to your IT system.

We recommend requesting the pre-signed URL by passing both login credentials and file name through the web service in one step. However, if you prefer, you can obtain the pre-signed URL by first using your username and password to request an access token and then using the access token and file name to request the pre-signed URL. The API references—and code samples—needed for both approaches are available below.

Security measures:

  • The pre-signed URL is active for only 15 seconds.
  • The transporting encryption is accomplished by SSL/TLS/HTTPS.
  • There is no client-side encryption enforced once the file is downloaded, so take any and all necessary steps to secure this file appropriately and meet your institution’s security standards.

Note: The notification email has embedded html span tags. These tags can be used to identify and extract the file name from the email notification. Span tags use this format: <span id="fileName"> filename.txt </span>.

File Directory Listing Request Methods

You can use the PAScoresDwnld web service to retrieve a list of files posted for your organization. File directory listings are helpful if you don’t want to use the notification email to retrieve file names. You can request a full or partial file directory listing:

  • Full file directory listing: A list of all files posted for your organization regardless of posting date. You can compare this list to a list of files already downloaded to your system, then retrieve each file you need individually.
  • Partial file directory listing of files posted since “fromDate”: A list of all files posted since a date and time that you provide. You can obtain a list of files posted since the last successful download, then retrieve each new file individually.

You can request the file directory listing by passing both login credentials and the required parameters described in the API reference below through the web service in one step. However, if you prefer, you can do it by first using your username and password to request an access token and then using the access token to request the file directory listing. Code samples for both approaches are available below.

Note: These file directory listing methods work only if the College Board professional account used for authentication is associated with only one organization in the Managing Access tool. If you need access to multiple organizations, create separate accounts and use the Managing Access tool to assign a data files management role for only one organization in each account.

API Reference

Below are the API references for implementing the PAScoresDwnld API. We also provide code samples to get you started.

Login and File Download API

PAScoresDwnld – Login
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/login
DESCRIPTION
Login by username and password. This endpoint allows the user to get an access token that can be used in subsequent "/file" and "/files/list" endpoint calls with the token.
PAYLOAD (sample)
Content-Type: application/json
{"username": "exampleuser",
"password": "examplepass"}
RESPONSE (sample)
Accept: application/json
{"token":"45B5B7E7-1C85-DBE7-2493-DB6ECA41A707"}
PAScoresDwnld – Pre-signed URL by Filename and token
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/file?filename={filename}
DESCRIPTION
Retrieve pre-signed AWS S3 URL by filename and access token (returned from login)
PAYLOAD (sample)
{"token":"45B5B7E7-1C85-DBE7-2493-DB6ECA41A707"}
RESPONSE (sample)
Accept: application/json
{"fileUrl":"https://kmscbtest.s3.amazonaws.com/K12/00000020150717000005.csv?AWSAccessKeyId=AKIAJBDJQ3DEKEFUYOOA&Expires=1433525962&Signature=01CV0qGNGQqQ93FERYXVehyWQfU%3D", 
"filePath":"00000020150717000005.csv"}
PAScoresDwnld – Pre-signed URL by Filename and Username/Password
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/file?filename={filename}
DESCRIPTION
This is a convenient method to retrieve pre-signed AWS S3 URL by filename and username/password (do not need login first). The username and password are to be passed in a request payload in json format (similar to login endpoint).
PAYLOAD (sample)
Content-Type: application/json
{"username": "exampleuser",
"password": "examplepass"}
RESPONSE (sample)
Accept: application/json
{"fileUrl":"https://kmscbtest.s3.amazonaws.com/K12/00000020150717000005.csv?AWSAccessKeyId=AKIAJBDJQ3DEKEFUYOOA&Expires=1433525962&Signature=01CV0qGNGQqQ93FERYXVehyWQfU%3D", 
"filePath":"00000020150717000005.csv"}

File Directory Listing API

Request RESPONSE Data Key
Element Description
"fileType" Identifies the file type as Scores File, Essay File, or Other.
"assessment" Identifies the assessment as one of these:
  • SAT
  • SAT with Essay (for certain types of essay image files)
  • N/A
"adminDate" The month and year of the test administration where applicable. Can be N/A for certain file types.
"deliveryMethod" Identifies the delivery method as one of these:
  • Score Release
  • Post Score Release
  • Student Rush
  • One Time
  • N/A
Essay image file delivery methods include:
  • Score Release - Auto Batch
  • Post Score Release - Auto Batch
  • Rush - Auto Batch
"deliveryDate" The date the file was posted.
"fileName" The name of the file. Used to request a pre-signed URL.
"batchId" The batch identifier for the run that posted the file. Use this when you contact customer service for help. Can be N/A for certain file types.
"recordCount": Numeric value identifying the total number of records in the file.
"fileSize": The size of the file in bytes.

 

PAScoresDwnld – Full File Directory Listing of all files posted using Authentication Token
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/files/list
DESCRIPTION
Retrieve data on all the files posted for your organization using the access token returned from login.
PAYLOAD (sample)
{"token":"45B5B7E7-1C85-DBE7-2493-DB6ECA41A707"}
RESPONSE (sample)
{
    "files": [
        {
            "fileType": "Scores File",
            "assessment": "SAT",
            "adminDate": "June 2016",
            "deliveryMethod": "Post Score Release",
            "deliveryDate": "2016-09-01",
            "fileName": "1234_20160901_000030.txt",
            "batchId": "123456_30",
            "recordCount": 50,
            "fileSize": 15853
        },
(repeats for each file)
    ]
}
NOTES:
1. For this request, the http headers – ACCEPT and CONTENT-TYPE needs to be set with application/json as values.
2. When no files have been posted, the RESPONSE will contain"files": null
PAScoresDwnld – Full File Directory Listing of all files posted using User Name/Password
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/files/list
DESCRIPTION
Retrieve data on all the files posted for your organization using the user credentials (User Name/Password).
PAYLOAD (sample)
Content-Type: application/json
{"username": "exampleuser",
"password": "examplepass"}
RESPONSE (sample)
{
    "files": [
        {
            "fileType": "Scores File",
            "assessment": "SAT",
            "adminDate": "June 2016",
            "deliveryMethod": "Post Score Release",
            "deliveryDate": "2016-09-01",
            "fileName": "1234_20160901_000030.txt",
            "batchId": "123456_30",
            "recordCount": 50,
            "fileSize": 15853
        },
(repeats for each file)
    ]
}
NOTES:
1. For this request, the http headers – ACCEPT and CONTENT-TYPE needs to be set with application/json as values.
2. When no files have been posted, the RESPONSE will contain"files": null
PAScoresDwnld – File Directory Listing of all files posted since “fromDate” using Authentication Token
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/files/list?fromDate={fromDate}
DESCRIPTION
Retrieve data on all the files posted for your organization since a date and time you provide using the access token returned from login.
PAYLOAD (sample)
{"token":"45B5B7E7-1C85-DBE7-2493-DB6ECA41A707"}
RESPONSE (sample)
{
    "files": [
        {
            "fileType": "Scores File",
            "assessment": "SAT",
            "adminDate": "June 2016",
            "deliveryMethod": "Post Score Release",
            "deliveryDate": "2016-09-01",
            "fileName": "1234_20160901_000030.txt",
            "batchId": "123456_30",
            "recordCount": 50,
            "fileSize": 15853
        },
(repeats for each file)
    ]
}
NOTES:
1. For this request, the http headers – ACCEPT and CONTENT-TYPE needs to be set with application/json as values.
2. {fromDate} follows standard ISO 8601 Date/Time syntax as follows:  yyyy-MM-dd'T'HH:mm:ssZ where “Z” indicates the time zone offset from UDT/GMT.  Example:  2016-01-30T23:11:55-0500 would be used for New York, NY EST.
3. File data for files posted AFTER the {fromDate} will be returned.
4. If an incorrect {fromDate} syntax is used, the RESPONSE will be:
	"message": "Invalid fromDate(yyyy-MM-dd'T'HH:mm:ssZ) value provided: {fromDate}"
5. When no files have been posted since {fromDate}, the RESPONSE will contain"files": null
PAScoresDwnld – Full File Directory Listing of all files posted since “fromDate” using User Name/Password
METHOD
POST
REQUEST
https://scoresdownload.collegeboard.org/pascoredwnld/files/list?fromDate={fromDate}
DESCRIPTION
Retrieve data on all the files posted for your organization since a date and time you provide using the user credentials (User Name/Password).
PAYLOAD (sample)
Content-Type: application/json
{"username": "exampleuser",
"password": "examplepass"}
RESPONSE (sample)
{
    "files": [
        {
            "fileType": "Scores File",
            "assessment": "SAT",
            "adminDate": "June 2016",
            "deliveryMethod": "Post Score Release",
            "deliveryDate": "2016-09-01",
            "fileName": "1234_20160901_000030.txt",
            "batchId": "123456_30",
            "recordCount": 50,
            "fileSize": 15853
        },
(repeats for each file)
    ]
}
NOTES:
1. For this request, the http headers – ACCEPT and CONTENT-TYPE needs to be set with application/json as values.
2. {fromDate} follows standard ISO 8601 Date/Time syntax as follows:  yyyy-MM-dd'T'HH:mm:ssZ where “Z” indicates the time zone offset from UDT/GMT.  Examples:  2016-01-30T23:11:55-0500 would be used for New York, NY EST and 2016-01-30T23:11:55+0100 would be used for Paris, FR CET.  +0000 should be used to indicate UDT/GMT.
3. File data for files posted AFTER the {fromDate} will be returned in RESPONSE.
4. If an incorrect {fromDate} syntax is used, the RESPONSE will be:
	"message": "Invalid fromDate(yyyy-MM-dd'T'HH:mm:ssZ) value provided: {fromDate}"
5. When no files have been posted since {fromDate}, the RESPONSE will contain"files": null

Code Samples

These code samples will help you set up your system to download and process data files using the web service.

JavaScript

Attached is a .zip file containing sample JavaScript code to download score reporting files and retrieve a list of data for files posted for your organization: pascoredwnld-javascript-sample.zip.

To run the sample JavaScript client (download.js):

  1. Download and install node.js version 4.4.2 (or later)
  2. Test node.js installation -- run 'node --version', it should display 'v4.4.2'
  3. Open download.js, check configurations and make proper modifications in initConfig:
var initConfig = {
scoredwnldHost: 'scoresdownload.collegeboard.org',
scoredwnldPort: '443',
localFilePath: 'C:/TEMP/',
username:'exampleuser',
password:'examplepass'
};
  1. Run the script: 'node download.js', this would provide how to use the script file.
  2. Run the script: 'node download.js list', to get the list of files.
  3. Run the script: 'node download.js download <filename>' to download the file.

Java

Attached is a .zip file containing the sample Java project to download score reporting files and retrieve a list of data for files posted for your organization: pascoredwnld-java-sample.zip.To build the project, gradle is needed. Gradle can be obtained from gradle.org

To build and run the sample:

  1. Unzip the files.
  2. The config.properties file can be updated with the login credentials, and file download path.
  3. Build the project by 'gradle clean install'
  4. Go to ./build/libs folder
  5. Run the code below to get information on how to use the Example:
'java -classpath pascoredwnld-client.jar;"lib/*" org.collegeboard.scoredwnld.client.Example
  1. To obtain the list of downloadable files, run the following:
'java -classpath pascoredwnld-client.jar;"lib/*" org.collegeboard.scoredwnld.client.Example list
  1. To download a specific file, run the following with the filename at the end replacing <filename>
'java -classpath ../..;pascoredwnld-client.jar;"lib/*" org.collegeboard.scoredwnld.client.Example download <filename>

Note: “../..” in the classpath, would allow the config.properties file to be read. The file can be located anywhere, but referring to it appropriately in the classpath would allow the code read the contents from it and override the default that is hardcoded.

cURL

Attached is a .zip file containing the sample cURL scripts to call the different service endpoints using cURL: pascoredwnld-curl-sample.zip.

To run the sample cURL scripts:

  1. The .zip files contain login.sh, list.sh and fileurl.sh files.
  2. Extract the zip file content.
  3. In each of these files, change the values for the username and password.
  4. Run the login.sh script, this should provide the login token as response.
  5. Run the list.sh script, this should provide the list of files as response.
  6. In the fileurl.sh, change the filename to a filename that is available in the previous response, and run the fileurl.sh. This should provide the fileUrl as response. The fileUrl can be used to download the file.

Manage User Access

The Manage Access Application

A designated institutional administrator, the Access Manager, can give their colleagues control and manage access to the College Board tools their colleagues use, including the SAT Suite integrated reporting portal.

Watch our webinar for help using the Manage Access application.

Initial Access

The first time the designated Access Manager uses the Manage Access application, they need an access code. Access codes are not required for later sign-ins. If you haven’t received your access code, email Higher Ed Reporting Support or call 855-475-3636.

  1. Sign in to your College Board account or create a new one by going to the professional dashboard.
  2. Under “Add Additional Tools and Services” in the General section, click Get Access next to Managing Access to support Higher Ed Assessment Reporting.

Screenshot indicating where users will find HE reporting link.

  1. On the next page, enter your institution and access code. It is only valid for the institution specified when you received the access code.
  2. After entering the access code, the Manage Access application will be in the My Tools and Services list.

Actions

You can use the Managing Access tool to take the following actions:

  • View current users assigned to roles, revoke access for current users, and renew access by extending a user’s access expiration date.
  • Assign roles to existing users who already have College Board professional accounts.
  • Invite users without College Board accounts, or users new to your institution, to access your reports or data files. An email will be sent on your behalf to new users.
  • Review outstanding invitations, and resend or cancel them as needed.

Get detailed help for the Managing Access tool by clicking Help in the upper right corner of the page.

Assigning Roles

Access Managers can assign multiple roles to any user; in fact, complete access to the reporting portal requires both the data files management role and the reporting detail role. Available roles:

  • DAT for Assessment Reporting: Allows the Access Manager to grant colleagues access to the reporting portal and assign additional users to the Manage Access role. The DAT role allows for coverage if the primary Access Manager is unavailable or is leaving the organization.
  • Assessment Reporting Data Files Management: Provides access to score data and essay batch files in the Download Center. This role is usually given to individuals in charge of uploading results into local data systems. Users with this role may be IT vendors hired by institutions, institution technology staff, or other institution staff. Assigned users will receive email notifications when new files are posted. This role does not include access to the Report Center or the Essay Center.
  • Assessment Reporting Summary: Provides access to the SAT Trends Dashboard in the Report Center. Limited to summary data only, with no access to individual student information. Summary reporting should be given to staff who don’t need student-level information, but may need aggregate reporting. This role does not include access to the Essay Center or the Download Center.
  • Assessment Reporting Detail: Provides complete access to the Report Center and Essay Center. Includes the ability to drill down to individual student score data and other personally identifying information. Detail reporting should be given to staff who benefit from seeing student-level results, such as Admissions staff. This role does not include access to the Download Center.

You can set up and maintain unlimited users, but be sure to manage accounts as people join and leave your organization.

Each role is independent. For example, you may assign data files access separately, or in conjunction with summary or detail reporting. If an individual is assigned both detail and summary reporting, detail reporting will preside.

Additional Information

Reference Files

To prepare for processing the new SAT data, we have provided detailed data field layouts and cross-walks between prior score data files.

Get the reference files.

Opening a CSV file

A CSV file is a comma-separated value that can be easily imported into a spreadsheet application such as Microsoft Excel: Click the file and allow Excel to open it automatically or use Excel’s Data Import from Text feature.

When you double-click a downloaded file, Excel detects column types and assigns number-based columns as numbers. This could result in improperly formatted columns, for example if a Student ID column is defaulted to number, it will remove any leading zeros in the data cell. To avoid this, use the Data Import from Text feature to open the import wizard, and set all columns as Text.

Contact

For help with Higher Ed SAT Reporting:

Phone: 855-475-3636

Email: hedreports@collegeboard.org