Skip to content

SIS Data Format

To ensure TKG Analytics processes your Student Information System (SIS) data correctly, all uploaded files must meet our standard format requirements. This allows the platform to align your student, staff, and school data for accurate reporting and accountability calculations.

District admins are managed only in the app, through the invite flow and onboarding, never by CSV. For a few district or school users, the UI invite flow is the lighter-weight alternative. CSV import is still the right tool for bulk onboarding and nightly SIS syncs.

Required File Names and Formats

All SIS data files must be in CSV format (.csv) and named exactly as listed below.

File names must exactly match the list below. If the file name is different the system will reject the upload.

district_users.csv

school_id first_name last_name email title (optional)

enrollments.csv

school_id teacher_id student_id grade subject course_code period term

fay_students.csv

school_name state_code ada_grade first_name last_name enrollment_status enrollment_days total_fay_days percent_enrolled

fay_4x4_students.csv (if applicable)

school_name state_code ada_grade first_name last_name enrollment_status enrollment_days total_fay_days percent_enrolled

schedules.csv

school_id teacher_id student_id term course_code subject short_name long_name period

school_users.csv

school_id first_name last_name email title (optional)

schools.csv

sis_id name short_name low_grade high_grade principal_first_name principal_last_name principal_email address city state zip

students.csv

school_id student_id first_name last_name email ada_grade gender is_sped is_scd is_ell is_gifted

teachers.csv

teacher_id school_id first_name last_name email title (optional)

This one file provisions both the Teacher record and the teacher's login. A row carrying teacher_id, school_id, first_name, and last_name creates the Teacher record used for score attribution, enrollments, and impact reporting. If that row's email is also on your district's staff email domain, it creates the login as well.

A row missing school_id, first_name, or last_name creates neither. It cannot create a Teacher record, and a login with no Teacher record behind it would have nothing to report on, so it is skipped rather than half-created.

The email column is required, even for teachers who will not sign in.

On the onboarding Current SIS Files step, a teachers.csv without the column is refused as you upload it, with an error naming email. Nothing is stored and nothing is imported, so add the column and upload the file again. The Historical SIS Files step does not require it, because the prior-year file builds Teacher records only and never creates logins.

On an ongoing SIS upload, a file without the column still imports your Teacher records, because a Teacher does not need an email. The login import is the part that stops, with an error naming the missing column, and it stops before changing any login, so no existing login is changed. Add the column and upload again to bring the logins across.

Because the login import runs last in the nightly sync, the steps scheduled after it do not run on a night this happens. Uploading the corrected file brings everything back in line, so submit a Helpdesk Ticket if you spot it rather than waiting for the next night.

Individual values may be blank. A row with a blank email, or an email outside your staff email domain, still creates the Teacher record but no login. See Teacher Users.

Getting Your SIS Data

If you need assistance with exporting these files from your SIS (for example SAM7 or PowerSchool), please contact our support team:

Our team can guide you or coordinate directly with your district technology staff to ensure files are prepared in the correct format.

Automating Your SIS Data Uploads

For districts looking to streamline this process, TKG Analytics supports nightly automated uploads via our API.

With API integration, your SIS data can be securely transmitted each night without manual uploads. This keeps your dashboards, reports, and accountability metrics up to date.

Accurate SIS data is the foundation for reliable insights. Keeping it current ensures TKG Analytics reflects the most recent student performance information.