National Student Clearinghouse File Prep Tool

1. NSC Account Info

Use the account code and name from your NSC account reference sheet.

Account code (required) Account name (required) Diploma period (required) Transmission date

2. Gather and upload files

Choose your SIS, then upload certified CALPADS 1.23 and the supplement required for your profile.

Choose your student information system

Your selection determines which supplement to upload.

SIS profile Choose the SIS before uploading the supplemental file.

SIS export instructions

Upload the files

Start with CALPADS, then add your SIS supplement.

CALPADS 1.23 file Required. Provides student, demographic, SWD, SED, ELAS, and graduation/completion data. Use this file only after the CALPADS EOY2 upload is certified. No file selected. SIS supplemental query Optional. Adds FERPA block, school/ACT override, and local program flags if they are stored in the SIS. No file selected.

Add program participation (optional)

Choose one of the two options below to add program data. You do not need to upload both.

Option 1: Use CALPADS reports

Upload 15.2 for CTE pathway completion, or use 3.11 together with 3.10 for course participation. Upload the reports relevant to the programs you want to include.

CALPADS 15.2 CTE completers Use the same graduating students as your 1.23 file. Only matching SSIDs receive the CTE tag. Before exporting 15.2Set the CALPADS filter to CTE Completer = Yes (Y). No file selected.

CALPADS 3.11 course participation Optional. Use with 3.10 to find AP, IB, AVID, Honors, and Dual Enrollment. Select the past 4 years of files. Download the reports as Excel files, not CSV.

No file selected.

CALPADS 3.10 instructional levels Optional. Use with 3.11 to find AP, IB, AVID, Honors, and Dual Enrollment. Select the same past 4 years of files. Download the reports as Excel files, not CSV.

No file selected.

Option 2: Use program participation rosters

Upload individual program rosters or one combined file. Match students using the SSID from your CALPADS 1.23 file.

Download sample roster (CSV)

Keep the column headings and replace the fictional sample rows with your students. Enter Y or N under AVID, CTE, IB, AP, and HON. CTE means pathway completion; IB means an IB diploma.

Program participation roster(s) Optional. Upload individual program rosters or one combined roster with AVID, CTE, IB, AP, and HON columns. No file selected.

Each upload is checked automatically. Any file issues appear beside the upload.

3. Build, review, and export

Build your file to see validation results. Resolve any errors before downloading.

Next action

About the downloads

NSC TXT: the final tab-delimited file for your Clearinghouse submission.

Review workbook: an Excel file with the output preview, validation results, and source summary.