Setup sheets

Three sheets, filled in this order — each one uses names from the sheet before it. Download each, delete the example rows, and send all three back.

One line per class, one per member of staff, one per child. A teacher's subjects sit on their own line, so nobody is written twice.

Your classes

Write each class the way the school says it. Put the arms in one cell separated by commas, and leave the cell empty for a class with no arms.

classes.csv

Column	Needed	What to write
class_name	Required	JSS 1, SS 2, Primary 4
arms	Optional	A,B,C — or empty if the class has no arms

JSS 1 with arms A,B becomes JSS 1A and JSS 1B. SS 2 with arms Science,Arts becomes SS 2 Science and SS 2 Arts. SS 1 with no arms stays SS 1. Those names are what you write in the other two sheets.

Who works at the school

One line per person, however many subjects they teach — their name, how to reach them, what they are allowed to do, and what they mark. Everyone receives an invitation by email and sets their own password, so never send us passwords.

staff.csv

Column	Needed	What to write
full_name	Required	As it should read on a report sheet
email	Required	Their own — this is how they sign in, so no two people share one
phone	Required	08031234567
title	Optional	What the school calls them: Mathematics Teacher, Bursar
role	Required	School Owner, Administrator, Head Teacher, Form Teacher, Subject Teacher, Bursar or Librarian
form_teacher_of	Optional	The one class they take the register for and compile results for: JSS 1A. Blank for everybody else
teaches	Optional	The subject, a colon, then its classes. Blank for office staff, and for a teacher whose timetable is not settled yet

Optional, but the teaches column is what opens a mark sheet. A role is permission, not a timetable: "Subject Teacher" says somebody may mark the subjects they are given, not which. Leave it blank and that teacher arrives able to sign in and see nothing — which is fine if their timetable is not settled, and can be filled in later inside Skublooms.

A colon between the subject and its classes, commas between classes, a semicolon between subjects. Mathematics in three classes is "Mathematics: JSS 1A, JSS 1B, JSS 2A". Two subjects in different classes is "Mathematics: JSS 1A; English Language: JSS 2A". Wrap the whole cell in quotes so the commas stay inside it.

Students

One line per child. The first columns are asked of every student; the last six are for a second and third guardian and can be left empty.

students.csv

Column	Needed	What to write
full_name	Required	The child's full name
sex	Required	Female or Male — it prints on every result sheet
class_arm	Required	A class from sheet 1
guardian_name	Required	The parent or guardian the school deals with
guardian_phone	Required	Their mobile — see the note below
guardian_email	Optional	Receipts go here when a fee is paid
guardian_occupation	Optional	Trader, Civil servant, Nurse
legacy_reference	Optional	Your current admission number for this child
guardian2_name, guardian2_phone, guardian2_relationship	Optional	Somebody else to call: Father, Mother, Aunt
guardian3_name, guardian3_phone, guardian3_relationship	Optional	A third contact, if there is one

guardian_phone is not just a contact number. Fee reminders and announcements are sent to it, and it is what the family uses the first time they sign in to see results. Every number is checked before the child is admitted, and any that cannot receive a message comes back to you in a list. The second and third guardians are contacts for the office to ring — nothing is ever sent to them.

Admission numbers: do not add a column for them. Skublooms issues each child a new one. Your existing number goes in legacy_reference, stays searchable, and prints beside the new one.

What Skublooms always asks

These are kept on the student record and cannot be switched off, because the app depends on them: the guardian's number is where fee reminders go and how a family signs in, and the child's sex prints on every report sheet.

RequiredStudent's full name
RequiredAdmission number — issued by Skublooms
RequiredStudent's sex
RequiredGuardian's name
RequiredGuardian's phone number
OptionalGuardian's email and occupation
OptionalUp to three other guardians to call

Everything else is the school's own — date of birth, previous school, address, religion, state of origin, birth certificate, health notes, and any question you want to add. You set those up inside Skublooms afterwards; they are not needed today.

Sending them back

Delete the example rows. They show the shape; they are not data.
Columns marked (optional) in the header can be left empty — the note is for you, so leave the header exactly as it is.
Do not rename, reorder or remove columns. Leave a cell empty if you do not have the answer.
Keep the CSV format — in Excel or Google Sheets, File → Download or Save as → CSV.
Send all three together.

You get a summary back before anything is created: how many classes, staff and students were read, and every line that could not be understood, by line number. Nothing is added to your school until you say go.