Add Many Students / Import Students

You can create many student accounts to TypeTastic by uploading a CSV formatted file (CSV = Comma Separated Values). Students can be enrolled in the classes that you have already created or, if the classes in your file do not yet exist, they'll get created and assigned to you in the process automatically.

If your account is set to use Google Sign-In you can also import your classes and students from Google Classroom.

NOTE!

You will not be able to import students to classes where you are co-teacher, but you can add students manually to these classes using the Add Student button.

Preparing your CSV file and importing

1. First, prepare a spreadsheet of your classes and students (using Excel, Google Sheets, or Numbers, for example) with these column headers: class_name, last_name, first_name, username, password, email. You can create a file for each class or include all classes in one file.
2. If you want to use Google or Office 365 single-sign-on, make sure that the student’s Google or O365 email is in the ‘username’ column and leave the password empty.
3. Once your spreadsheet is ready, you will want to save it as a CSV file. The name of the CSV file can be anything, e.g. student-upload.csv.
4. On your home page, click on the Import Students button. Click on Browse and select your CSV file. You can also drag and drop it to the file name field. Click on Upload Students and the import process starts. If there are errors in your file, you will see red notifications that guide you to fix them.
5. Once the importing is completed successfully, go to Class Settings, and select the correct grade level for the class. This way our grade-appropriate curriculum gets applied (can be modified later).

The columns can be in any order, but all need to be included, even if they are empty. Column headers are case insensitive.

Download sample CSV file here.

Column name	Required / optional	Description
class_name	Required	Name of the class where the student is enrolled Length: 5-50 characters Allowed characters: a-z, A-Z, 0-9, space, hyphen, apostrophe, # If already created, the name needs to be an exact match to an existing class If not yet created, a new class will get added automatically
first_name	Required	Length: 1-50 characters Allowed characters: a-z, A-Z, 0-9, hyphen, apostrophe
last_name	Required	Length: 1-50 characters Allowed characters: a-z, A-Z, 0-9,  hyphen, apostrophe
username	Required, case insensitive	Length: 3-50 characters Allowed characters: a-z, A-Z, 0-9, hyphen, period, @ Your account is ready to use Google or Office 365 sign in if respective buttons are visible on the login screen. If you'd like your students to use either of these options, use their Google or Microsoft email address as username.
password	Password is required if your account's logon type is Username & Password Password is optional if your account's logon type is Google or 0365	If your login page has Google or O365 sign-in option, you do not need to have passwords in the file. For security reasons, never include the real Google or 0365 passwords in your file as they are maintained by your IT support and should not be shared with third parties.
email	Optional	Max. length 60 characters

Error notifications

Value is not unique notifications

These errors refer to values in your file that should be unique. The error message includes row numbers so that you can easily find and correct them.

Exists already notifications
You'll see these errors if users with the value already exist in TypeTastic. The error message includes row numbers so that you can easily find and correct them. You can choose to delete the row from your file (not create the user account) OR you can change the value to a unique one to create a user.

We recommend the first option to avoid creating duplicate user accounts. If the user is enrolled in other teacher's class but should be in yours or you are a co-teacher you have a couple of options:
- contact the teacher and ask them to add you as co-teacher to their class
- give class code to the student so that they can switch to your class

Username is already in use
Usernames are unique per account. User with this username already exists on the account, but not necessarily in any of your classes. If you use emails as usernames, it can also be that a user with the same email already exists. Note that You can only view students in your school who are enrolled in your classes or are not enrolled in any class.

Email is already in use
Emails are unique per account. User with this email already exists on the account, but not necessarily in any of your classes. You can only view students in your school who are enrolled in your classes or are not enrolled in any class.

Class already exists
Class names are unique per account. If your file has class names that already exist on the account and you are not the owner or co-owner of that class, you will be notified. If many schools use the same account (=district account), the class name can be reserved also in another school.

Other possible notifications

Required column is missing from your file

Wrong column header

Number of values in user record does not match the number of columns in your file