Skip to content
Help centre

Setup · Page guide

Import from a file

Add many students or teachers at once from a spreadsheet saved as CSV.

2 min readSetup → Import from a fileFor: School admin
Open in Insply

Instead of adding people one by one, fill in a template and upload it. Nothing is saved until you check the preview and confirm. You need the permission to add people, and the import runs inside a school.

What you see on this page

  • Two cards: Students and Teachers. Each has Download template, Choose CSV file, and a summary after you pick a file.
  • A Branch for rows without a branch column selector on the Students card when you have more than one campus.
  • A How it works box with the three steps.

Import a file

  1. Click Download template on the Students or Teachers card and open it in Excel or Google Sheets.
  2. Fill in one row per person and keep the header row.
  3. Save it as CSV (File → Save as → CSV). The file can have up to 1,000 rows.
  4. Click Choose CSV file and pick it. The app checks it and shows a preview.
  5. Read the summary: total rows, how many are ready, duplicates skipped and rows that need fixing. A table lists each skipped line and the reason.
  6. Click Import to save the ready rows. Use Choose a different file if you want to fix the file first.

Columns for students

  • Required: first_name, last_name, grade, section.
  • Optional: branch, roll_number, gender, date_of_birth (written as year-month-day), email, phone.
  • The class (grade and section) must already be open this year and have free seats. Students are placed in the current academic year.

Columns for teachers

  • Required: first_name, last_name.
  • Optional: employee_code, gender, email, phone, employment_type (Full time, Part time or Contract).
  • People already on the list (same code or email) are skipped as duplicates.