Skip to main content

Import Students

The CSV import creates your students, classes, and class enrolments in one step. For any club with more than 5 students, this is the fastest way to get started.

Download the template

  1. Go to Admin → Import
  2. Tap Download template CSV
  3. Open it in Excel, Google Sheets, or Numbers

The template has 36 columns with an example row. Delete the example before importing.

Fill in the template

Required columns

ColumnNotes
First Name
Last Name
Student TypeMust exactly match a type in your instance — e.g. Adults, Juniors
ColumnNotes
GradeMust match a grade name for that student type — e.g. Yellow, Blue
EmailParent/guardian email for comms
PhoneMobile number for SMS — include country code e.g. 07700900000
Renewal MonthJanuaryDecember or 112
Social Media AcceptedYes / No
Grade Card ReceivedYes / No

Class columns (repeat for Class 2, 3, 4)

ColumnRequired if class setNotes
Class 1Class name — e.g. Tuesday Adults 7pm
Class 1 TypeMust match a student type
Class 1 DayMondaySunday
Class 1 Time19:00 or 7pm
Class 1 DurationMinutes — defaults to 60
Class 1 Locatione.g. Main Hall
info

Class schedule details (Day, Time, Duration, Location) only need to be filled in once per class name — on the first student who attends that class. All subsequent rows with the same class name will reuse the schedule.

Preview before importing

  1. Save your CSV and go to Admin → Import
  2. Tap Step 2 — Upload your completed CSV
  3. Select your file, then tap Preview Import

The preview shows:

  • New classes to create — check the schedule details are correct
  • All rows — green ✓ (ready), amber ⚠ (warning, will still import), red ✗ (error, must fix)

Fix errors

Common errors:

ErrorFix
Student Type not foundCheck spelling — must exactly match your instance's student types
Class N Type not foundSame — check the type name
Class N Day not validUse full day name: Monday, Tuesday, etc.
First Name / Last Name requiredFill in the missing field

Fix errors in your spreadsheet, re-save, and re-upload. The preview runs again.

Confirm the import

Once the preview shows 0 errors, tap Import N students. The import:

  1. Creates any new classes
  2. Creates all students
  3. Enrols students in their classes

All steps happen in a single transaction — if anything fails, nothing is written.

After import

  • Students with warnings (e.g. grade not matched) are imported without that field — update them individually in the app
  • New classes are created with the schedule you provided — check Manage Classes if anything needs adjusting