Skip to content

Teacher import

Teacher import loads many teachers at once, instead of adding them one by one from each school. It is reached from the project’s Settings.

The teacher import page with its list of expected columns, the Import teachers button and the teachers added recently

Import teachers takes a spreadsheet, and you map your columns onto the ones it expects:

ColumnNotes
Teacher NameRequired
Phone NumbersRequired; several can share one cell, separated by commas
EmailOptional
GenderRequired
School NameRequired; typed as text, and matched against the district’s schools
RoleRequired; one of the country’s teacher roles

The district is not a spreadsheet column: it is chosen from a list of the project’s existing districts (under your country’s own word for them), so it always lands somewhere real.

  • The school is matched by name within that district, ignoring capitalisation and common filler words such as “primary school”, so “Hotoro Central Primary School” and “Hotoro Central” land on the same record. If no school matches, one is created.
  • The teacher is matched within that school, either by an identical name or by any of the phone numbers in the row. A match reuses the existing teacher and adds the row’s role to them; no match creates a new teacher.

Importing creates real records, so a few minutes on the file saves hours afterwards:

  1. Spell school names exactly as they already exist in the district, since anything else creates a school.
  2. Fill in phone numbers wherever you have them, so returning teachers are recognised.
  3. Check for duplicate rows within the file itself.
  4. Check for trailing spaces in names, which stop a match without being visible.

When an import finishes, the page says how many teachers were created or updated and offers two ways on:

  • Invite the … imported teachers, which carries their number (senior managers and administrators), sends the app invitation to exactly the teachers of this import who have an email address. It follows the same rules as any other invitation, including the wait before a large send starts. See Teachers and invitations.
  • See them in Teachers opens the Teachers list showing only this import, to look them over first.

Below, Recently added teachers lists the teachers added to the project in the last 90 days, district by district. Open a district to see each teacher with their school, their roles, the training events they took part in and the date they were added. After an import, a tick box narrows the list to the teachers of that import.

Run a deduplication evaluation on the affected districts straight away, while the import is fresh. A bulk import is the single most common source of duplicates, and the candidates are much easier to judge now than in six months. Schools are worth checking first, since those are the ones an import creates silently.

See Evaluating a district.

The same pattern exists elsewhere in the dashboard: staff can be imported from a project’s Team section (name, phones, email, gender and job title; no district or school, since staff belong to the project), and training participants from a training event, whose import matches and creates schools just like this one. All of them match existing people by name or phone number.

Next: Project Staff