Moving from spreadsheets to a school ERP is mostly a data-cleaning job. The software part is quick once the data is in good shape. Here is a plan that keeps the term running smoothly.
1. Choose the right moment
Move between terms or at the start of the academic year. Classes, sections, timetables and fee structures are being set up anyway, and there are no half-finished fee cycles to carry over.
2. Decide what needs to move
Not everything has to come with you. Usually you need:
- Current students: name, date of birth, class and section, roll or admission number
- Families: parent names, emails and phone numbers, and which children belong to which family
- Staff: teachers and their subjects and sections
- Structure: academic year, terms, classes, sections and subjects
- Fees: fee structures and any open balances
Old years, past results and closed fee records can stay archived in your existing files.
3. Clean the spreadsheets first
Most migration problems are data problems:
- One row per student. No merged cells, no totals in the middle.
- Consistent class and section names. “Grade 2 B”, “2-B” and “II B” should be one value.
- Valid contact details. One email per parent, so they can receive their invite.
- Siblings linked. Use the same parent email for brothers and sisters so one sign-in covers the family.
- Duplicates removed. Search for the same child entered twice.
4. Set up the structure
Before adding people, create the academic year, terms, classes, sections and subjects, then fee structures by class. With the structure in place, every student lands in the right class and gets the right fees.
5. Add students, families and staff
Add students and link them to their parents. Then add teachers and assign them to subjects and sections.
6. Check a sample
Before you tell anyone, check ten students across different classes: right class, right parents, right fees. Fix patterns, not just individual rows.
7. Invite staff, then parents
Start with teachers so they can take attendance and see their timetable. Once that is running smoothly, send parents their invites. A short note explaining what they will see (attendance, homework, fees) helps adoption.
8. Run in parallel briefly, then switch
For the first week or two you may keep the old register as a backup. Set a clear date after which KlassMint is the only record, so nobody keeps updating the spreadsheet.
How KlassMint helps
KlassMint gives you the structure (years, classes, sections, subjects, fee structures), student and family records with password invites, and teacher assignments. It does not currently import spreadsheets, so contact us before you start and we’ll talk through your set-up.
Frequently asked questions
When is the best time to move to a new school system?
Between terms or at the start of an academic year, when timetables, fees and classes are being set up anyway.
Should we move all our old data?
Usually not. Move current students, families, staff, classes and open fee balances. Keep old records archived in their original files.
Can KlassMint import spreadsheets?
KlassMint does not currently offer a spreadsheet import. Contact us before you start so we can talk through the best way to set up your school.