Skip to content
Help · Admin

Review cleaned student spreadsheets before importing

Review arranged columns, cleaned names, dates and phone numbers, and clearly marked generated values before importing students.

Choose your student file

Open Institute Setup → Student data → Upload and choose an Excel or CSV file. The upload arranges recognised columns and shows a cleaning summary. Review the mapped fields and the preview before choosing Check students.

Names, dates and contacts

Names are cleaned into title case, with a leading M or M. expanded to Muhammad. Check personal names against your school records. Dates are arranged as YYYY-MM-DD. A missing date of birth or admission date receives 2026-01-01 as a clearly marked fallback; this is not a verified date. Invalid source dates remain for you to correct.

Phone numbers are kept as text so their leading zeroes remain. Missing or all-zero numbers receive an 11-zero placeholder: 00000000000. This is not a contactable phone number. Invalid supplied numbers remain for correction. Review the father, mother and student contact fields before import, and replace placeholders when the correct numbers are available.

Generated identity and family values

Missing father CNIC values receive a numbered placeholder in the form 00000-000000-N, where N is the generated sequence number. Existing placeholder numbers are skipped. This is not a valid or verified CNIC. Keep supplied identity numbers as text and check them against the original records.

Missing family numbers receive a padded sequence such as 01, 02, 03. Review these values before saving: generated numbers do not prove that students belong to the same family. Supplied family numbers are retained.

Session, status and gender

A missing session receives a current-year suggestion such as 2026-27. The session must already exist in Institute Setup before students can be imported. If it is absent, set it up or choose the correct configured session. Existing statuses are retained; a blank status defaults to Currently Enrolled.

Gender suggestions use a limited set of recognised names. Unknown names remain for review. Check every suggested value against your records; a name is not proof of a student's gender.

Review before saving

Read the cleaning summary and confirm I reviewed generated values, gender suggestions and excluded rows before continuing. Use Download cleaned sheet to keep the arranged data, unmapped original columns, excluded source rows and cleaning log for review. Resolve the issues shown by Check students, then import through the normal upload flow. Cleaning and downloading a sheet do not themselves save student records.

See EDUBase running on your own school's data.

A 30-minute online demo, in English or Urdu, using your fee plans and classes. No installation, no commitment.