If your school cannot connect your MIS to Seneca via Wonde, you can still keep your data up to date by sending us a spreadsheet in our approved format.
This process ensures teachers, students, classes, and (optionally) parents are correctly set up in Seneca.
1. Download the Spreadsheet Template
Download the official Seneca spreadsheet template here: Download Template (XLSX)
The template contains multiple tabs, each for a different type of data:
Teachers
Students
Classes
Class Enrolments
Parents
2. Fill Out Each Tab
General Rules
Bold columns = required
Non-bold columns = optional — delete them if you don’t use them
Every row must have a unique ID for that record type (e.g. Teacher ID, Student ID, Class ID, Parent ID)
Column names and tab names must match exactly — otherwise the file will be rejected
The order of columns does not matter, but do not rename them
File must be saved as .xlsx (Excel format)
Understanding and Creating IDs (Very Important)
IDs are how Seneca keeps track of each person or class — they must be consistent and unique to prevent data errors.
Rules for IDs:
Permanent for the same person/entity — IDs must stay the same year after year for the same student, teacher, class, or parent.
Never reuse an ID — if someone leaves, their ID should not be assigned to anyone else.
New class, new ID — if you create a new class (even with the same name as last year), it must have a brand new ID.
Class IDs are not class codes — the class code should go in the Class Name field, not the ID field.
Tips for creating IDs if you don’t already have them:
Use something unique and stable, like a school MIS ID, admission number, or payroll number.
If you don’t have IDs in your MIS, you can create them yourself:
For students:
STU001,STU002(or similar format)For teachers:
TCH001,TCH002For classes:
CLS001,CLS002
Once assigned, do not change an ID unless it’s incorrect — changing it will create a new account in Seneca.
Teachers Tab
Required:
Teacher ID (unique & permanent)
First name
Last name
Email (school email preferred)
Optional:
Job title, subject specialism, etc.
Students Tab
Required:
Student ID (unique & permanent)
First name
Last name
Email (if applicable)
Optional:
Year group
SEN status
ESL status
Classes Tab
Required:
Class ID (unique & permanent; change if a new class is created for a new school year)
Class name
Class Enrolments Tab
Required:
Class ID (must match an ID in the Classes tab)
User ID (must match an ID in the Teachers or Students tab)
Role (must be either “teacher” or “student”)
💡 Tip: The first teacher listed for a class will be set as the main teacher (owner) in Seneca.
Parents Tab
We recommend all priority 1 or 2 parents with no court order are added.
Required:
Parent ID (unique & permanent)
Student ID (must match an ID in the Students tab)
Parent email
Parent name
Optional:
Relationship (e.g. Mother, Father)
Court order flag (if true, no connection will be created in Seneca)
3. Common Requirements to Pass Validation
Before sending your file, check:
No duplicate IDs within a tab
All IDs referenced in one tab exist in the relevant other tab (e.g. Class ID in Class Enrolments must exist in Classes tab)
No blank required fields
File is saved as .xlsx
Sheet/tab names are unchanged
4. Send Your Spreadsheet to Seneca
Once complete:
Save the file as .xlsx
Email it to school-integrations@seneca.io
If required by your school’s policy, send via a secure method (e.g. password-protected file via Dropbox)
Our integrations team will:
Upload the spreadsheet
Run validation checks
Email you if any errors need fixing
5. Updating Your Data
Any time you need to add or remove students, classes, or teachers, send a full updated spreadsheet — partial updates are not supported
IDs must stay consistent to avoid overwriting or mismatching accounts
Do not reuse an ID for a different person — this will cause their Seneca history to be linked incorrectly
Need Help?
Contact the Integrations team: school-integrations@seneca.io