Completing the NZCER Assist school data input file

Use the attached workbook if your school cannot export student information in a format supported by NZCER Assist.

NZCER will use the completed workbook to prepare the required Assist upload file.

How to complete the workbook

1. Download and open NZCER_Assist_School_Input_2026.xlsx in Microsoft Excel.
2. On School details, complete the yellow cells. Select the testing term as 1, 2, 3 or 4.
3. On Classes, enter each class once.
4. On Students, enter one student per row.
   • SMS ID and NSN are required.
   • Select year level, gender, ethnicity and class from the provided dropdowns.
   • Additional class columns are optional.
5. Check that each completed class and student row displays Ready.
6. Save the completed file in .xlsx format and return it using the method provided by NZCER.

Important

• Do not rename or remove worksheets, headings or columns.
• Do not change formulas or add new dropdown options.
• Blank unused rows can remain in the workbook.
• Subjects do not need to be entered. These are determined by your school’s NZCER Assist subscriptions.
• Please handle the workbook securely, as it contains student information.

If a row does not display Ready, check the status column for the field that needs correcting.