Uploading student information via spreadsheet (CSV file)

Quick Reference Guide

1. Add student information to the Excel template, and save a copy (you should have received a copy via email, but if not you can get the document at the bottom of this page). Note – please ensure the format remains as csv when you save.
2. Log in to CEM Secure
3. Select ‘Assessment Centre’ from the blue banner at the top
4. Select the relevant product and assessment (the most recent for the current assessment), and click ‘ok’
5. Select the ‘import’ icon from the banner across the top
6. Click ‘Choose File’ and select your csv document (You will see an option, "Does the file contain column headers?" This should remain as ‘yes’)
7. Click ‘Upload’.
8. Check that the column headers have mapped over correctly (use the drop downs to make changes as necessary), scroll down to the bottom of the page and click ‘next’. Note – columns left as ‘ignore’ will not be loaded to our system
9. You’ll see a summary of candidates you have imported. You can make changes or delete students if you need to. When you’re ready, click ‘next’
10. If the system detects any duplicate students against records you have already added, you will see a ‘Candidates Matching’ screen. Select ‘Include’ to add as a second entry, or ‘update’ to amend the current record for that student. Click ‘Finish’ to complete the upload.

Detailed Guides and Supporting Information

CSV spreadsheet template for uploading BASE student details

Full PDF Coordinator guidance document for BASE