How can I edit student accounts in bulk/by CSV export?

    Follow

    Please note: this option is only available to the Access Coordinator and Teacher Admins. 

    To update student accounts already within the Admin Hub, use our CSV export function.

    Start with an exported CSV for your centre by going into the Admin Hub Pupils section, and clicking on 'Export CSV'. 



    An 'E' for edit should be added to each row that you want to alter in the action column.  You'll see a User ID for each entry. Keep these IDs exactly as they are, changing only the data you want to alter.

    An example is provided below - we can see that the records for Lucy, Rebecca, Emma & Priya will be amended according to any changes made in the file, whilst Mark and Naomi will have their row ignored. 



    If you alter an email address, an email will be sent to the new email address and the database will reflect the change only when it has been verified (i.e. when the student has clicked the link in the activation email).

    Remember that the changes you make will apply to all the Hodder Education Group applications for which the student has access.

    Once you have made any applicable changes, save the amended file to your computer. 

    To upload, when your CSV is ready:

    • Click ‘Import CSV’ in the Admin Hub ‘Students’ tab
    • Use ‘Browse to CSV’ to select your file on your computer
    • Click ‘Open’
    • Click ‘Upload your CSV’

    If any mandatory information is missing a ‘Validation results’ dialog box will appear.

    • Click ‘Download errors CSV’ to get a list of the errors
    • Amend the spreadsheet as necessary and re-upload
    Was this article helpful?
    1 out of 1 found this helpful

    Comments

    Get Additional Help

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