Preparing a CSV to import students, teachers and classes

The first step to preparing the import CSV is to export the following information from your student information or timetabling system. You can download a sample import template below.

Please note, you do not need to send us information about which students have left existing Literatu classes. When you prepare an import sheet, please ensure all current students appear in the listing for each class. If the class exists in Literatu, we will repopulate the class according to that information, and any students not in the class list will be removed.

2KB

Literatu-import-sample.csv

Literatu CSV Import Sample

COLUMN	DESCRIPTION
Class name	We suggest you import your classes so that you can assign activities and report by class groups. If you don’t want to assign or report at a class level, then simply enter the cohort name in this field (e.g. Year 7).
Teacher name	The name of the teacher of that class. If the class has more than 1 teacher, list additional teacher details in the next rows for that class E.g. Class name Teacher Name Teacher email etc... 7ENG-A Mr Barnes [e-mail] 7ENG-A Mrs Adams [e-mail]
Teacher email	The teacher’s email address. Teachers will login with their email address. Email is mandatory for teacher accounts. Note: If you are using single sign-on (SSO) with linked email addresses, please use the email address that is used by your SSO provider.
Teacher password	A default password for the teacher. Please make sure it is at least 6 characters with an uppercase letter and a number. Please note, an initial password is mandatory even if teachers will be logging in using Google or Microsoft SSO.
Student name	The student’s name. Apostrophes, hyphens and spaces are allowed. Note: Some schools prefer firstname lastname format, and some prefer lastname firstname format. Please ensure the student name is in the order your teachers expect to see it.
Student email/login ID	The student’s email address. This is our preference, and is used as the login ID. If your students do not have school emails or are too young to login with email, then please use a login ID that is a single word plus a 2 or 3 digit number. We suggest you use the format of the first 3 characters of their first name, the first 3 characters of their surname plus a 2 digit number, e.g. Mary Anderson - marand45
Student password	A default password for the student. Please make sure it is at least 6 characters with an uppercase letter and a number. Please note, an initial password is mandatory even if your students will be logging in using Google or Microsoft SSO.
Class subject	The subject of the class. Subject is used in reporting.
Class year	The cohort the class belongs to, using just the number (e.g. 7 for Year 7)
Gender	Optional: The gender of the student in the format of M, F or X for gender X. This is an optional field.
LBOTE	Optional: Language Background Other Than English, in the format of Y (yes) or N (no).

Before importing, please make sure there are no blank fields or incorrect data.