Skip to main content

Reference for import file columns

This reference sets out the fields each import type accepts in Skool.Cool, which of them are mandatory, and how to fill them in. An import runs through a step wizard that matches your file's columns to Skool.Cool's fields automatically, so no fixed column order and no literal column names are required — the data simply has to be clear. For the practical steps, see Importing student data and Importing parents.


How the import works (column mapping instead of fixed columns)​

When any import starts, the wizard shows six steps at the top of the screen: File → Map columns → Validation → Preview → Import → Results.

  • File formats: an Excel file (.xlsx) or a CSV file (.csv).
  • Limits: up to 5,000 rows and 20 MB per file.
  • The header row: the first row must contain the column headings (the field names).
  • Automatic mapping: on the Map columns step, the system proposes a link between each column in your file and the appropriate field in Skool.Cool, marking what it matched itself as Auto. Review the mapping and complete the mandatory fields, or change them by hand.
  • A ready-made template: each import type has a Download template button that downloads a file laid out with the recommended columns, to avoid any confusion.
  • Human values, not codes: values are written as a person would say them — the city's name rather than its number, the word for male or female rather than a number, and the activity's name rather than its identifier.

Where it lives​

Choose the school from the School list in the top bar, then: sidebar > Today's work > Imports, then choose the appropriate card and press Start import.

The available cards: Students & parents · Activities & groups · Registrations & payments (which contains Import payments) · Trainers & admin staff.


General rules for filling in​

  • Dates in day/month/year form (for example 14/05/2015) or year-month-day (for example 2015-05-14), in the Gregorian calendar.
  • Mobile numbers in Saudi form (05xxxxxxxx) or international.
  • The national ID is ten digits (a national ID or an iqama).
  • Fields with defined values (level, time of day, age range, and so on) are written by the name defined in the school's settings; if the system does not recognise one, the value is ignored and a warning appears without stopping the import — except Gender in the activities file: an unknown value there stops the row until it is corrected, because ignoring it would open the activity to both boys and girls.

Students & parents import fields​

One file creates the student's record and links them to their guardian's existing account by mobile number; no new guardian account is created from the file, so a row whose guardian has no account shows an error.

FieldRequired?Description and format
Guardian PhoneYesThe guardian's mobile number — the key linking the student to their family. The guardian must already have an account with this number; the import does not create guardian accounts.
First NameYesThe student's first name.
Father NameNoThe father's name (the middle name).
Family NameNoThe family name or surname.
Birth DateYesDay/month/year or year-month-day (Gregorian).
GenderYesMale or female — a word, not a number.
National IDNoTen digits (a national ID or an iqama) — it prevents duplicates and improves matching.
Guardian RelationNoFather, mother or other — "other" is used when it is left empty.
No health data or media consent is imported

Student files contain — by design — no columns for health conditions or publishing consent; the guardian answers those themselves at their first registration.


Activities & groups import fields​

The activity's name is the matching key within the school: an activity that already exists under the same name is completed (only its empty fields are filled, without replacing existing values), and a row naming a parent activity creates a group beneath it. Fees, Age Range and Open to Other Schools, however, apply only when the activity is created; an import does not change them on an existing activity. To create a single activity by hand, see Create a new activity.

FieldRequired?Description and format
Activity NameYesThe activity's name — the matching key within the school.
Parent ActivityNoLeave it empty for a main activity, or write the main activity's name to create a group beneath it — it must be running or upcoming. If the name is repeated, the group goes under the running activity, not last term's ended copy.
FeesNoThe activity's fee in riyals (a number) — applied only when the activity is created.
CapacityNoThe maximum number of seats.
DescriptionNoThe activity's details.
Start DateNoThe activity's start date.
End DateNoAn end date in the past is not accepted.
LevelNoThe level's name as defined in the system.
KindNoThe activity's category as defined in the system.
Day/TimeNoThe timing as defined in the system.
GenderNoThe intended audience: Male, Female or Both, as the dropdown list offers them. Leave it empty for an activity open to everyone; an unknown value stops the row until it is corrected.
Age RangeNoOne range, for example 6-9 (as defined in the system) — applied only when the activity is created.
Open to Other SchoolsNoYes = open to everyone, No or an empty cell = school members only — applied only when the activity is created.
A value in the file that is not applied

When a value in the file would change an existing activity but the import does not apply it — because that field already holds a different value, or because it is one of the three columns above — that field keeps its current value, and the row is classed Warning before anything is saved — on the Validation step and in the Issue breakdown on the Preview step. After the import runs, the same message shows on the row, in the Issues column of Import results. Open the row and the field concerned is highlighted under Values; the message is in Validation and error messages. To change the value, edit it on the activity itself, or undo the original import that created the activity and upload the corrected file again — within 7 days of that import, and as long as the activity has not been edited or used since. If you choose the undo, do not run this file before it: running it can fill other empty fields of the activity, and that counts as an edit, which excludes the activity from the undo. Undoing this import does not help, because it does not change that field.

An imported activity starts Closed

Imported main activities are created with the status Closed, exactly like an activity created from the wizard, so parents cannot see them straight after the import. Finish setting them up — the weekly schedule, the payment methods and the trainers — and then publish them. You can publish several activities together from the activities hub.

The import does not carry the session schedule

There is no column for weekly sessions, so every imported activity — main or group — starts with no schedule until you open its session scheduling screen. The import also does not carry the trainers, the sibling discount, the images or the bundles, and it adds the Cash payment method automatically to the main activity only.

Best: import main activities only, and create the groups from the screen

The import can create a group through the Parent Activity column, but an imported group is created with an empty schedule; a group created from the groups screen copies the main activity's sessions at the moment it is created.

So: leave the Parent Activity column empty, import the main activities alone, then save each activity's schedule, then create its groups from the screen — in that order, every group inherits its schedule automatically. And if you did import the groups, do not create them again from the screen (they would be duplicated); open each one and set its schedule yourself.


Registrations import fields​

Each row registers one student on a main activity that already exists; the student is identified either by their Student National ID alone, or by the Guardian Phone together with the Student First Name. To follow the registrations after the import, see Reviewing registrations.

FieldRequired?Description and format
Activity NameYesThe name of the main activity they are registered on — it must exist at the school and be running or upcoming. If the name repeats, the running activity is chosen, never last term's ended copy.
GroupNoThe name of the group (the sub-activity) within the activity. The student is added to the group only on a paid registration; an unpaid or waitlisted one is registered without a group, so add them from the Group roster after payment.
Student National IDTo identify the studentThe most precise way of matching a student.
Guardian PhoneTo identify the studentUsed with the student's name when there is no national ID.
Student First NameTo identify the studentFor matching alongside the guardian's mobile number.
StatusYesSupported: pending review / awaiting payment / paid.
WaitlistNoYes = placed on the waiting list.
Amount PaidNoIn riyals — if it is less than the fee it is recorded as a discount (there is no partial payment).
Payment MethodNoCash / free (online payment is recorded by hand).
Receipt NumberNoThe payment's receipt number.
Paid DateNoTo date the status record.
Registration DateNoThe original registration date.

Payments import fields​

A payment is recorded against an existing registration whose status is Awaiting payment only (matched by activity and student), and it creates no new registrations. To confirm a single payment by hand, see Confirming a cash payment.

If several activities share the name (a program that runs again each term, or an extended activity), the payment goes to the student's only registration among them. If the student is registered in more than one activity with that name, the row is rejected because the file cannot say which one is meant — record that payment from the registration itself.

FieldRequired?Description and format
Activity NameYesThe name of the activity paid for (it must exist).
Student National IDTo identify the registrationThe most precise way of matching a registration.
Guardian PhoneTo identify the registrationWith the student's name when there is no national ID.
Student First NameTo identify the registrationFor matching alongside the guardian's mobile number.
AmountNoIn riyals — the registration's amount due is used if it is left empty.
Payment MethodNoCash / free.
Receipt NumberNoThe payment's receipt number.
Paid DateNoThe original payment date.

Trainers & admin staff import fields​

This creates sign-in accounts for trainers and school managers; a temporary password is sent to each new account's email, and they are asked to change it at their first sign-in. For managing them by hand, see Managing trainers.

FieldRequired?Description and format
RoleYesSchool manager or trainer (the only two supported).
EmailYesThe member of staff's email — their sign-in name and a temporary password are sent to it.
First NameYesTheir first name.
Family NameNoThe family name or surname.
PhoneNoTheir mobile number.
CityNoThe city's name.
Birth DateNoTheir date of birth.

Validation and error messages​

After the mapping, the system checks each row separately and classifies it as Valid, Warning or Error. An error does not stop the whole import; you can use Import valid rows only, or press Download error file for a copy of your rows with the reason for each note, then correct them and upload again.

On the Preview step, the system shows how many rows are To create, how many To update and how many To skip before it runs, and below them the Issue breakdown: each message with the number of rows it appeared in. A message about one particular column names it — in the rows table, in the error file, and in the Issue breakdown, which counts it for each column separately. Examples of common messages:

The messageClassWhat it means and what to do
Required value is missing in "First Name".ErrorA required field was left empty — the message names it; fill it in.
"…" in "Guardian Phone" is not a valid phone number.ErrorCorrect the mobile number's format in the column named.
"…" in "Birth Date" is not a recognizable date. Accepted formats: dd/MM/yyyy or yyyy-MM-dd.ErrorFix the date format in the column named.
No parent account with phone "…" exists — the guardian signs up in the parents app with this number first.ErrorThere is no guardian account with this number. Check the cell first; if the number is right, ask the guardian to create their account in the parents app, then import the row again.
No activity named "…" exists in this school — import the activity first.ErrorImport or create the activity before the registrations.
Activity "…" ended on … — registrations can only be imported into a running or upcoming activity.ErrorThe name only matches an activity that has ended (usually an earlier term's copy) — create this term's activity, or correct the name.
"…" matches … running activities in this school (for example a program and its next batch) — the file cannot tell which one is meant. Give each a distinct name, then validate again.ErrorMore than one running activity shares the name (such as a program and its new batch) — give each a distinct name, then validate again.
Main activity "…" ended on … — a group can only be added to a running or upcoming activity.ErrorIn the activities file: the parent activity's name only matches a copy that has ended (usually an earlier term's) — create this term's activity first, or correct the name.
Gender "…" was not recognized — pick a value from this column's dropdown list, or leave the cell empty for an activity open to both genders.ErrorIn the activities file: pick Male, Female or Both from the list, or leave the cell empty for an activity open to everyone.
The file's value for "Fees" is NOT applied — this activity already exists, and an import only fills its empty fields; Fees, Age Range and Open to Other Schools are set only when an import creates the activity. Edit the field on the activity itself, or undo the ORIGINAL import that created this activity and import the corrected file fresh. Undoing THIS import will not help — it does not change this field.WarningIn the activities file: the row matched an existing activity, and the file's value for the column the message names would change it — but an import only fills an existing activity's empty fields, and never applies Fees, Age Range or Open to Other Schools to one. It shows on the Validation and Preview steps, before anything is saved, and then on the row in Import results. Edit the field on the activity, or undo the original import that created it (within 7 days of it, and if the activity has not been edited or used since) and import the corrected file again; undoing this import changes nothing.
The student will be registered but not placed in group "…" — only a paid registration holds a group seat. Place them from the group roster after payment.WarningThe registration is unpaid, so it is imported without a group — add them from the Group roster after payment.
… of this activity's … sessions clash with "…", which the student is already registered in — the registration will be imported anyway. Check with the family before committing.WarningThe activity's times overlap another activity the student attends at your school, which the message names. The registration is imported, so check with the family before running it.
… of this activity's … sessions clash with an activity the student attends at another school — the registration will be imported anyway. Check with the family before committing.WarningThe overlap is with an activity of the student's at another school, which is not named because it belongs to that school. The registration is imported, so check with the family before running it.
This row's email address is already used by another account, so the parent was imported without it. Check the address with the parent: if it is theirs, they may already have another account with it — contact support; if not, correct it and import the row again.WarningShown in Results after the import runs: the address in the Email column is registered to another account on the platform, so the parent was imported (or updated) without it, and that account is not named. If the address is the parent's, they most likely have another account with it (under another mobile number) — contact support to sort it out; if the file has it wrong, correct it and import the row again, and the address is added to the parent.
… of this activity's … sessions clash with row … of this file, which registers the same student — both will be imported. Check with the family before committing.WarningTwo rows of the same file register the student in activities whose times overlap. Both are imported, so check with the family before running it.
This file registers the same student in … activities that have sessions — more than the … it compares, so these rows were not checked against each other for schedule clashes. All will be imported. Check the student's timetable with the family before committing.WarningThe file registers the student in more activities than can be compared, so their rows were not checked against each other for schedule clashes. The registrations are imported, so check the student's timetable with the family before running it.
City "…" was not recognized — the value was skipped.WarningWrite a known city name, or leave the field empty.
Duplicate of row … in the same file — only the first occurrence is imported.WarningRemove the duplicate within the file.
This student is already registered in this activity — the row was skipped.WarningAn existing registration; it will not be duplicated.
This activity is at or over capacity — the registration was imported anyway.WarningImported as a historical record despite being over capacity.
An import can be undone

If you find a mistake after it has run, use Undo import from the results screen, within 7 days of the run, to remove what the operation created — except any record edited or used since the import, which stays as it is, whoever changed it. Parent accounts are never deleted or locked by an undo; only the details the file entered are cleared, and only if the account has not been used.


Before you start​

  • You need the import permission appropriate to the kind of data you are importing (students, activities, registrations, payments, or staff).
  • Import in the logical order when setting up a new school: students first, then activities, then registrations — because each kind depends on the one before it existing.

Frequently asked questions​

Do I have to put the columns in a particular order or give them fixed names? No. The wizard matches your file's columns to Skool.Cool's fields automatically on the Map columns step, and you review the mapping and complete the mandatory ones. To avoid any confusion, download a ready-made file with Download template. The steps are in Importing student data.

Which file formats are accepted, and what is the maximum number of rows? The system accepts an Excel (.xlsx) or CSV (.csv) file, up to 5,000 rows and 20 MB per file. The first row must contain the column headings.

Why do I write the word for male or female rather than a number, and what goes in the city field? Because the import accepts human values rather than codes: write the word for male or female in Gender, and write the city's name (Riyadh, for example) rather than its number in City. The number is no longer required.

If some rows have errors, does the whole import stop? No. Errors apply only to the rows concerned, and you can carry on with Import valid rows only. Press Download error file to see the reason for each row, then correct it and upload again.

I made a mistake and imported the wrong data — can I undo it? Yes, within 7 days of the run. From the results screen use Undo import to remove what the operation created, while any record edited or used since the import stays as it is. Parent accounts always stay; the undo clears only the details the file entered, and only from an account that has not been used.

How do I import payments without creating new registrations? From the Registrations & payments card choose Import payments; it records the payment against existing registrations whose status is Awaiting payment only. To confirm a single payment by hand, see Confirming a cash payment.