Import or update your student roster from a CSV

Bring your students and their families into the Front office from a CSV file. You see a preview before anything is saved, and you can import a newer file later to update the roster.

Before you start

• You need to be an owner, an admin, or a Principal on your team. FrontOfficeGo comes with the School plan ($1,999 a year per site) and the District plan.
• Save the file as CSV, 5 MB or smaller. Bigger files can be split and imported in parts.

Steps

1. Go to Front office, then Roster and settings.
2. Under Import a roster CSV, choose your file and click Preview.
3. Read the counts: new students, students with changes, students already up to date, guardian emails, and students with no family linked. Rows with a problem are listed by row number. Everything else still imports.
4. Add a tag if you like, such as fall-2026.
5. Tick Email the new families their family page link only if you want new families emailed now. It starts unticked.
6. Click Apply import and confirm.

Columns it reads

Column	Also accepted
student_first (required)	student_first_name, first_name, first
student_last	student_last_name, last_name, last
grade	grade_level
classroom	homeroom, teacher, class
sis_id	student_id, sisid, student_number
dob (YYYY-MM-DD)	birth_date, birthdate, date_of_birth
guardian_name	parent_name, guardian, parent
guardian_email	parent_email
guardian_phone	parent_phone
sms_consent (yes, y, true, or 1)	sms, text_ok
relationship

Good to know

• Use one row per student, or one row per guardian. Rows for the same student are joined.
• Importing again updates in place. A student matches on SIS id, or on name plus a guardian email already linked. Grade, class, SIS id, and birth date update. Nobody is ever deleted.
• A guardian you removed or restricted stays removed after any import.
• A row with no student first name is skipped. A student with no guardian email comes in with no family linked.
• The preview lasts one hour. After that, upload the file again.