Adding students using a spreadsheet

Prefer a video? No problem! Watch our handy how-to video here.

Top tip: If you're just adding your own students, it's simpler to add them as classes. Find out how here.

To start with, you need to get your excel file in the right format to upload!

        Open up a blank Excel document.

        Type in the following column headers: First name, Last name, Email address/username, Password, Class.

The Class column is optional, but highly recommended. If you aren’t going to include a class name then remove this column. If you are going to use it then make sure you Add a class (follow steps 1 - 4 and then click through to the end) to your account beforehand and that the name in your spreadsheet exactly matches the name of the class.

        Add your student data to the spreadsheet. You can copy and paste the details from whichever source you normally use (SIMS etc.)

If your students don't have email addresses, choose a username for each of them.

Set the password to whatever you like - your students will be able to change it once they log in.

        Click on Save as.

        Give your file a name and make sure that you save it as a .xlsx file! Click Save.

You're now ready to upload the file!

        Log in to my.thisisschool.com, click on your name in the top right, and select Student Roster.

        On the Student Roster page, click Advanced student upload.

        Select your excel file.

        Click Upload.

Your students can now log in with the email address/username and password given in the spreadsheet.

• Related Articles

• Adding students and classes

  Whether your students have used the site before or not, here's how to set up your classes: Log in to my.thisisschool.com. Hover over your name and click My Classes. Click Add a Class: Enter the class details and click Save. On the next screen you can ...

• Adding students to an existing class

  Whether your student has used the site before or not, here's how to add them to an existing class: Log in to my.thisisschool.com. Click on your name and click My Classes. Select the class in question and click Students. Click Add/Remove Students. On ...

• Using This is School with your VLE/LMS

  Using This is School alongside a VLE/LMS, like Google Classroom, Schoology or Canvas, is a great way to maximise efficiency. Tip 1: Getting students logged in If your school has access to a VLE/LMS, you can use it to help your students access their ...

• Setting up students and classes for a new school year

  Part 1: Remove last year's classes Hover over your name in the top right-hand corner and select My Classes. Click on the class you no longer need and select the Edit Class tab. Click Archive Class. Part 2: Add new classes Hover over your name in the ...

• Archiving students who no longer need their accounts

  Archiving old students before the start of the new academic year makes space for adding new ones and prevents login problems for students moving to a new school. There are 2 different ways to archive students who no longer need their accounts. Option ...