Do you have many classes to import and add to groups on Helpful Games? Use our function to create student accounts from Excel. You can find the import function by following the steps below.
Do not use this feature to add students from an existing group on Helpful Games – the students will then get two different accounts on Helpful Games! Instead, use the function to add student from another group.
- Sign in as a teacher or parent.
- Click on Students.
- Choose to create a new group or click on the name of an existing group.
- If creating a new group: Enter class or group name and school name followed by clicking on the button Save.
- Make sure you are on the Students tab. Click the Add student button, then New and then Import Excel.
- Choose data file for import, grade of the students and how they should be able to access games.
- Click the Create student accounts button.
- The accounts are now created and added to the group. Passwords are not shown during the import. On the group page you’ll see a box such as “28 students have not yet received their login details”, with the buttons Print login cards and Download in Excel format. Passwords are created when you click one of them. The box stays until the cards are printed, even days later and from another computer. If you sign in through Google or Microsoft, you can skip this step. See Print login cards.
Format of data file
The import file must contain certain columns. The columns that must be included in the file are:
- First name
- The student’s first name. Must be included for each student.
- Last name
- The student’s last name. Not mandatory to fill this column with data.
- E-mail address
- The student’s e-mail address. Not mandatory to fill this column with data.
The columns Username and Password are ignored if they are present in the file.
The first row must contain the above values, which are then used to match the subsequent rows of the import file. We have also created an template for creating student accounts on Helpful Games.
