To import students into Alps Ascent, you will need to prepare a .csv file structured with the following columns in order: Student ID, Forename, Surname, Gender, Disadvantage, SEND, EAL, Feeder School, KS2 Scaled Score, KS2 Reading Score, KS2 Maths Score, Learning Bias, Mean SAS, Verbal SAS, Non-Verbal SAS, Quantitative SAS, Spatial SAS.

Important Note: You must include all the column headings in your .csv file, but you can leave the values blank if you do not wish to import that data. 

To access our Student template file, navigate to the Data Management tab, select Students and click the Template File button to download.

Below is an example of a Students file: 

Once you have prepared your students file, click Upload File. In the upload page, select your csv file and click Upload. 

Once the file is uploaded, it will be validated and checked for any errors. If no errors are found, a green notification will appear to confirm the upload was successful:

If your file does contain all the columns in the template file, in the set order, an error message will show and ask you to reimport: 

If a file is imported with invalid values, the file will upload but flag any errors. You can see which values contain errors by clicking View Issues.

An error message will display at the top of the screen, identifying the affected columns and rows. To fix errors, amend the data in Excel and reupload the students file.