Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Students/Lesson 8

    Import students from CSV

    Download the template, upload your spreadsheet, map columns, preview errors and import up to 2000 students with guardians in one go.

    Open /students/importRecording script
    10 min6 stepsOwner, Admin, Principal, Front officeDemo: sign in as Principal

    Before you start

    Finish first: Find students: directory, filters and CSV export

    • A current academic year.
    • Class names in the CSV that match Academics → Classes (for example Class 5 or 5).
    • A spreadsheet saved as CSV (UTF-8).

    Steps

    0 of 6 done
    1. You should see: Header "Import students — Bulk-load the admission register from a CSV. Existing admission numbers are skipped." and card 1. Upload CSV.

      Open /students/import
    2. You should see: A CSV with headers such as admission no, first name, last name, dob, gender, category, class, section, roll no, father name, father phone, mother name, mother phone, guardian phone, address line 1, district, pincode, admission date.

      Leave admission no blank to auto-number. Dates work as YYYY-MM-DD or DD/MM/YYYY.

    3. You should see: Card 2. Map columns appears: "We guessed from the header row; fix anything that looks wrong." Each field (First name *, Class *, Date of birth, Father phone…) has a dropdown of your headers or — not imported —.

    4. You should see: Ready rows show a green Ready badge; bad rows show the reason in red. An Unknown classes warning lists class names that do not exist in the school.

    5. You should see: Card 4. Result: "60 inserted · 0 failed" and All rows imported., or a table of failed lines with the error.

    6. You should see: The directory count has grown; each student shows class, section and guardian phone.

      Open /students

    What you have now

    • The whole register loaded with admission numbers, enrolments and guardians.

    If something goes wrong

    "No current academic year is set. Create one under Settings → Academic years before importing."
    Set a current year first; the Import button stays disabled.
    "The file has no data rows."
    The CSV has only a header. Check you exported the right sheet.
    "Unknown class "5th"" on a row
    Rename the class in the CSV to match Academics → Classes exactly (for example Class 5 or 5).
    "Admission number already exists (skipped)"
    That student is already in the register. The row is skipped; no duplicate is created.
    "Import at most 2000 rows at a time"
    Split the file into batches of 2000 rows.

    Related guides

    • Admit a student
    • Classes and sections for the year
    Quick certificate from the profile and public verificationNext: Promote and roll over to the next session