This article is intended for schools that import their classes and students via CSV (see this article if your school uses MIS import).
Before you begin
If you want to bulk-add students, you'll need to prepare a CSV file containing your student data.
Use our CSV template to ensure that your data is structured correctly.
You'll need to observe the following formatting rules in your CSV file:
Dates of birth must be provided in yyyy/mm/dd format
Year groups must be in the format 'Year X' (e.g. 'Year 7', 'Year 11')
Important consideration: students can only belong to one class in Sparx Maths. You can't specify multiple classes for a student in your CSV file.
Tip: it's likely that you'll need to make updates throughout the year as students join and leave the school, so keep a master copy of your original CSV file to more easily make changes throughout the year.
Importing students via CSV
Importing students via CSV
If you're adding multiple students, it'll likely be easiest to do so via CSV import.
Upload your CSV:
Go to 'Management' → 'Student Manager'
Click 'Add/update students'
Click 'Add/update students via CSV'
Select your CSV file
Wait for the upload to complete
Review and Confirm:
Check for any errors flagged in the preview
Correct any errors in your original CSV if needed
Click 'Preview Student Changes'
Click 'Import/Update Students' once you're happy
Adding students individually via Student Manager
Adding students individually via Student Manager
If you only need to add a small number of students, it'll likely be easiest to do so manually via Student Manager.
Go to 'Management' → 'Student Manager'
Click 'Add/update students'
Click 'Add single student'
Enter the student's details
Click 'Save'
Frequently asked questions
I'm seeing error messages after uploading my CSV file. What should I do?
I'm seeing error messages after uploading my CSV file. What should I do?
Error messages after import typically mean that your CSV data isn't correctly formatted, or there's an error in your data that you need to resolve
Check that your CSV file has a header row
Ensure that your CSV file contains the necessary columns, in the correct order, as proscribed by our CSV template
Check that all dates are in yyyy/mm/dd format (if you're using Excel, it will sometimes try to autocorrect these to your local date format, so you might need to undo this)
Check that all email addresses are correctly formatted (watch out for unnecessary spaces; commas instead of dots and missing domain names)
Check that year group names are correctly formatted (should be 'Year X').
How do I add students to a registration group?
How do I add students to a registration group?
It is not possible to assign registration groups using CSV upload, however, these can be assigned once the students have been imported.
In Class Manager, you can add registration groups in the Registration Groups tab. You can then move students into these groups in Student Manager by ticking the students and then clicking Move selected students -> To a registration group.