How to upload your student data

How to use a CSV to move your students for the new year

Anna Wallis avatar
Written by Anna Wallis
Updated over a week ago

You can upload a spreadsheet to add your students or make set changes all at once. To do this, you'll need a spreadsheet with the following information:

  • First name

  • Last name

  • Year

  • Class

  • Subject

We also recommend including this information:

  • UPN (to make sure students don't end up with duplicate accounts)

  • Email address (for resetting passwords)

If a student is in more than one class, (for example, a Science class and a Geography class), use a second row.

__________________________________________________________________

We add students for you

Step 1: To upload your spreadsheet to our secure data area, log in to Educake and click "Add or move students in bulk" in blue. Click "Choose files" and select your spreadsheet.

Step 2: This will upload it to our secure area and from there we will import your students and set up your classes for you. You will receive confirmation from Educake that we have your data and a confirmation once students have been added.

Add students yourself

Want to upload your students yourself? Click "Prefer to add your own classes". Click "Choose file" and select your spreadsheet. The uploader will walk you through several steps to make sure it can match up any returning students with their accounts.

__________________________________________________________________

Why do we ask for UPN?

We highly recommend you include a unique identifier for each student. This can be unique to your school, but each student should keep the same one throughout their entire time at your school. This allows you to quickly move students into their new classes when the next school year starts, and ensures that their progress and completed quizzes stay associated with their accounts.
​   

Why do we ask for student email addresses and mobile numbers?

We recommend you include an email address or mobile number for each student you upload. This is so students can reset their own passwords if they ever forget them. It's not required, but it does mean that students don't have to wait until the next class time to ask you to reset their passwords.

If you choose not to include students' contact details with your spreadsheet, students can still add their own contact details when they've logged in to Educake. 

For information on how to disable this and how student password resets work, read this article:
http://help.educake.co.uk/en/articles/2765447-can-students-reset-their-own-passwords

Did this answer your question?