How to import student data from Excel into school software

Most schools that move to school management software already have their students in a spreadsheet: an admission register typed into Excel, a list exported from an old system, or a sheet each class teacher keeps. Bringing that list in with a bulk import saves days of typing. It only goes well if the sheet is clean before you start.

This guide is the checklist we follow. It works for any school software, not only ours.

Step 1: Prepare the columns

Ask your software vendor for its import column list and order before you touch the data. Then make your sheet match it: one row per student, one column per field, and a single header row at the top.

Fields most schools need:

• Student's full name, spelled the way it should appear on receipts and certificates
• Admission number (or another ID that is unique for every student)
• Class and section, written the same way every time (for example 5 and A, not "Fifth", "5th" and "V" mixed together)
• Date of birth, in one consistent date format
• Gender
• Father's, mother's or guardian's name
• One parent mobile number of 10 digits, with no spaces, dashes or +91

Keep the mobile numbers clean. In software where parents sign in with a one-time password sent to their phone, as they do in EduTechMonitor, a wrong number means that parent cannot log in.

Tidy up the sheet:

• Delete merged cells, blank rows between classes and "total" rows at the bottom.
• Move notes and remarks into a separate column, or leave them out of the import.
• Remove extra spaces before and after names. Excel's TRIM function does this.

Step 2: Check for duplicates and gaps

Duplicates are the most common import problem, and they are tedious to undo later.

• Sort by admission number and look for repeats. Every admission number should appear once.
• Sort by class, then name, and look for the same child entered twice with different spellings.
• Filter for blanks in the columns the software requires. A row with no class or no admission number usually fails, or lands in the wrong place.
• Count students per class and compare the count with your attendance register. If the numbers differ, find out why before you import.

Save a copy of the original file and do all your cleaning in a second copy. If something goes wrong, you can always go back.

Step 3: Import a small batch first

Do not import the whole school in one go. Start with one class:

1. Import that class's rows.
2. Open a few of the students in the software and compare every field with the sheet.
3. Check that dates, class names and phone numbers came through correctly. Leading zeros, and dates swapped between day and month, are the usual problems.

When one class looks right, import the rest, class by class or all at once, whichever your software and your confidence allow.

Step 4: Verify after the import

An import is finished only when someone has checked it.

• Compare the student count for each class in the software with your register.
• Spot-check five to ten students in each class against the paper admission register.
• Ask class teachers to look at their own class list in the first week. They will notice a wrong name or a missing child faster than anyone in the office.
• Keep the final cleaned spreadsheet with the date in its file name. It is your record of exactly what was imported.

How this works in EduTechMonitor

EduTechMonitor, the school management software made by Sajre Edutech, can import a student list from a spreadsheet, so your office does not have to type each student. When a school starts with us, our team does the first import together with your office staff during setup. We give you the column list, check the sheet with you, and confirm the counts afterwards.

Imported students then sit in the same records used for attendance, fees and parent login.

One thing to settle before any switch, with any vendor: the student list is the easy part. History, such as past attendance and past fee payments, is a separate question. Many schools simply start attendance and fee collection fresh from a clear date, such as the first day of a term. Ask us in the demo what we can bring across from your data. And if your records are in an old system that cannot export to a spreadsheet, tell us before you plan the move.