Compare
Student Records: Excel or a School System? How to Decide
Excel can be enough for a small school. When Excel is fine, signals that it is time for a system by type of school, how the two differ in practice, and a first step.
In short
While few people handle the data and no approvals or change history are needed, Excel can be enough. When several people edit the same list at once, approvals must be recorded, certificates are issued often, residence-card expiry must be tracked per student, or monthly figures are reconciled by hand, it is time to consider a system.
Last updated: October 26, 2026
When Excel is fine
Some schools do not need a system. While these hold, tidying your Excel practice may be the sensible choice.
- One or two people edit the list, never at the same time.
- Corrections to grades or attendance need no approval record.
- You issue a few certificates a year in a fixed format.
- Another tool already covers messages to guardians.
- Where files live and who may see them is settled.
What tends to go wrong with Excel
- Files get copied and nobody knows which is current.
- Attendance, grades and fees sit in separate files and drift with every copy.
- Formulas and layouts depend on one person and cannot be fixed without them.
- Restricting who sees each file is hard, and change history is rarely kept.
Signals it is time for a system, by type of school
Decide by these signals rather than by student numbers.
- Several people edit the same list at once
- What happensNobody knows the current version; edits disappear
- Especially inVocational schools, universities, multi-classroom juku
- Some records need an approval trail
- What happensYou cannot show who approved a grade correction or leave, or when
- Especially inVocational schools, universities, private K-12
- Certificates are issued often
- What happensEach one is copied from lists and grades, with no issue record
- Especially inVocational schools, universities
- Residence-card expiry tracked per student
- What happensStudents with expiry coming up are missed
- Especially inJapanese-language schools, vocational schools with many international students
- Monthly figures reconciled by hand
- What happensInvoices against payments and attendance rates take time every month
- Especially inJuku and lesson schools, vocational schools
Excel and a system in practice
An example for comparing ways of working. Co-editing and permission features depend on the environment, product and settings for both.
- Co-editing and versions
- ExcelCopies cause confusion; co-editing depends on your environment
- School management systemBuilt for several people using the same record
- Connected records
- ExcelSplit by file
- School management systemEnrolment, attendance, grades and fees on one record
- Data entry
- ExcelRe-keying is common
- School management systemInformation entered once is reused
- Rights and history
- ExcelUsually per file
- School management systemRole-based rights and operation logs
- Cost
- ExcelStart with existing software
- School management systemSubscription and other fees
A first step
You need not move everything at once. First remove duplicates and spelling variants and align student numbers; then move the tasks with the most re-keying.
Even if you are unsure whether to stay with Excel, writing down your current practice with the selection checklist shows where to start.
In Classio
Classio registers students in bulk from an Excel template (.xlsx, up to 5 MB and 500 rows). Rows with missing information become provisional records you can complete later.
Frequently asked questions
- How many students before we need a system?
- Numbers alone do not decide it. Use the signals: how many people edit at once, whether approvals must be recorded, how often certificates are issued.
Related pages
Sources
Regulatory statements follow the scope of the cited documents. External documents do not certify Classio’s behaviour or compliance.
- MEXT: Handbook on Informatisation of Education, Chapter 5 (Japanese) — school affairs support
- Personal Information Protection Commission: General Guidelines (Japanese) — 10-6 technical security measures
- Classio: Switching from another system — product description (not a certification by a public body)
Sources checked: October 18, 2026
Start from how you work today
Want to decide what to replace first?
Tell us the columns in your Excel list and how you use it, and we will suggest where to start.