Adding your pupil records by CSV import

    Follow

    If you are setting up MARK manually, we advise that you use our CSV import to upload your pupil records into their year groups and classes. You can also add an individual pupil through this quick method here, but the CSV import will allow you to upload multiple pupils in one go. 

    Please ensure that you have set up your year groups and classes, as described here or the upload will not work. 

    To upload your pupils via CSV, you will need to use our template. To download this, ensure you are on the blue 'Pupils' tab in the Admin Hub. Select 'Import CSV':

    mceclip0.png

    Then, select ‘Download Template’ button:

     mceclip1.png

    This will export the template as a CSV file. Open this up, and you will see the following column headings:

    mceclip2.png

    It is vital that you do not make any amendments to this header row - you can leave columns blank if you are not using them, but do not delete any of them. Your pupil information will be entered in the rows underneath this first row. 

    Below is a guide of what to include in each column.  Please make sure that you fill in all of the mandatory columns, marked with an asterisk (*) 

    Column Action Input
    A* Action Insert the letter 'A' to add the pupil to the platform if you're adding an entirely new pupil record to the system.
    B User ID Leave blank.   
    C* Type Add 'S' for student.
    D* First name First name of the pupil.
    E Middle name

    Optional, can be left blank. 

    F* Last name

    Last name of the pupil

    G* Year group

    This must match the year group of the class on MARK.  The AC can check what has been set up by clicking on the 'School' tab in the Admin Hub and going to 'Year group' tab. 

    H* Class

    Class name – this must match the class name on MARK.  You can check what has been set up on the 'Classes' tab within Admin Hub. 

    I* DOB

    Pupil’s date of birth, which needs to be inputted in DD/MM/YYYY format.

    J* Gender F for female, or M for male. 
    K Home Language Optional, can be left blank. 
    L UPN Optional, can be left blank. 
    M Pupil premium Optional, can be left blank.
    N Service children Optional, can be left blank.
    O Free school meals Optional, can be left blank.
    P Ever 6 free school meals Optional, can be left blank.
    Q SEN status Optional, can be left blank.
    R More able Optional, can be left blank.
    S Traveller status Optional, can be left blank.
    T Looked after Optional, can be left blank.
    U Ever looked after Optional, can be left blank.
    V* Access to application Add 'Y' for yes to enable the pupil to appear in class listings and marksheets.

    You can upload CSVs containing up to 250 pupils at a time, however, successful upload of this many pupils at once can vary depending on your schools’ bandwidth and connectivity. If you do not have strong or fast connectivity we would advise uploading smaller sets of data at a time. You can download as many templates as you need - just ensure that you save the file(s) somewhere on your computer where you can easily find it again. 

    Once your file is completed, you are ready to import your CSV. To upload, select ‘CSV import’ again in the 'Pupils' tab: 

    mceclip0.png

    Use ‘Select your CSV…’ to select your file on your computer: 

    mceclip1.png

    Then, select ‘Upload the CSV’. You will see a spinner on the screen whilst your data is uploading.  Depending on how many rows you are uploading, this may take a few minutes.  

    The next dialogue screen will advise you of the success of this upload. If any mandatory information is missing or there are errors in the information supplied. Select 'Download errors CSV' to get a list of the errors and details of the pupils that did not successfully upload to MARK: 

    mceclip0.png

    Column W of the errors report will provide the reason(s) as to why the upload failed. You can amend the exported spreadsheet (containing only those that did not upload successfully) as necessary, save it and re-upload.

    Any uploaded pupils will then appear under the blue 'Pupils' tab, and you can now use them for marking tests, assigning interactive tests, etc. 

    Back to: Pupil records: adding, editing and deleting

    Was this article helpful?
    2 out of 2 found this helpful

    Comments

    Get Additional Help

    Ask for help from our Digital Support team by submitting a ticket request.