My teacher CSV import is not working

The teacher import lives on each night page under Import a teacher roster (CSV). Here is what it expects and how to fix the common problems.

What the file needs

• A CSV file, not an Excel file. In Excel use Save As and pick CSV UTF-8. In Google Sheets use File, Download, Comma separated values.
• A header row. The import finds columns by the words in the header: name or teacher, email, grade or subject or group or department, and room or location. Column order does not matter. Extra columns are ignored.
• Without a header, columns are read in the order name, email, grade or subject, room.
• Up to 500 teachers per file.

Error messages

• Pick a CSV file first. No file was chosen, or the file is empty.
• That file had no teacher rows. It needs a name column. The header has no column with name or teacher in it, or every name cell is blank. Rename the column to Name and try again.

Good to know

• An email without an @ is dropped quietly. The teacher is still added, just without an email.
• Importing the same file twice adds every teacher twice. Remove the extras with Edit, then Remove.
• A short list is often faster to paste into the Add teachers box, one per line.