Import Student Data

Upload Student File

The import runs one row at a time. A bad row is rolled back without removing successful rows.

School *

The spreadsheet Academic Year, Class, and Section are resolved only inside this school.

Excel / CSV file *

Supported: .xlsx, .csv · Maximum 5 MB · Maximum 3,000 data rows

Important: Existing students are not overwritten. Duplicate Student Id/Admission Number, Aadhaar, Student PEN, or APAAR rows are skipped and reported. If Class and Section exist but their class-section junction is missing, the importer creates that junction automatically.

Sample Column Mapping

Student Id	Admission Number; if blank, generated from year + Register/PEN/Aadhaar
Academic Year	student_enrollments.academic_year_id
Roll No	students.class_roll_no + student_enrollments.roll_number
Class + Section	class_sections + student_enrollments
Register No.	students.register_no
Student PEN	students.student_pen_no
Student Name	first/middle/last name fields
Appar/APAAR Id	students.apaar_id
Aadhar/Aadhaar No.	students.aadhaar_number
Father/Mother Name	student_guardians
Address 1 / Dist. / Pincode / State	student_addresses + student district

Address behavior: the single address in the sample is saved as both Current and Permanent, with Permanent marked “same as current”, matching the existing student-address structure.