Implementation 4 min read Updated October 2026
Moving from Excel and WhatsApp to one system
In most institutions the information already exists; it’s just scattered: attendance in one spreadsheet, parents’ phone numbers in another, and incidents in WhatsApp groups nobody can search. Moving to one system isn’t a technical project but a change of habits. This guide shows how to do it in stages, without losing information or losing the staff.
1. Map what you have today
Before moving anything, write down where each piece of information lives today. The list is almost always surprising: the same information is maintained in three places, and important information exists only on one counselor’s phone.
| Information | Where it is today | Who updates it |
|---|
| Student and group list | A spreadsheet in the office | The secretary |
| Attendance | A spreadsheet per group | Each counselor |
| Parent contacts | An old spreadsheet and private phones | Unclear |
| Exit approvals | WhatsApp messages and forms | Counselors and the gate |
| Incidents and notes | The staff WhatsApp group | Everyone |
2. Start with one process
Moving everything at once almost always fails. Pick one process that hurts everyone and happens every day, and move it all the way before moving on. In most institutions that’s daily attendance, followed by exit approvals.
- A daily process builds the habit fast and shows results within a week.
- A process that hurts everyone brings the staff on board, because everyone feels the improvement.
- Only when the first process works without reminders do you add the next.
3. Clean the data before you move it
A spreadsheet that has passed through ten hands has duplicates, names written three ways and phone numbers that no longer work. What moves into the system as it is brings the mess with it.
Cleanup before the move
- One source for each list: decide which spreadsheet is correct, and delete the rest.
- One column per detail: first name, last name and phone in separate columns.
- Check for duplicate students by ID number or date of birth.
- Confirm parent contacts with the parents themselves at the start of the year.
- Mark what doesn’t move: old data that’s no longer needed stays out.
4. A short parallel period, with an end date
During a parallel period you work in both the spreadsheet and the system. It gives confidence, but if it drags on, the staff get used to double work and end up back in the spreadsheet. Two to four weeks is usually enough, and the end date is announced in advance.
01Announce a dateFrom that day attendance is reported only in the system. The spreadsheet stays read-only.
02Support the first weekOne staff member who knows the system is available for questions on every shift.
03Check every dayWho reported and who didn’t. Reach out personally to those who didn’t, and ask what’s hard.
04Lock the spreadsheetOn the set date, the old spreadsheet is archived and closed to editing.
5. What to do with the WhatsApp groups
There’s no need to close every group. Decide what goes through them and what doesn’t. WhatsApp is good for quick coordination between people. It isn’t suited to records, approvals or information about a specific student, because you can’t search it, it’s unclear who saw what, and the information stays on private phones.
Rules for the staff group
Template to copyFine here: coordination (“who’s covering for me at 14:00?”), general reminders, messages that aren’t about a specific student.
Not here: incidents with students, exit approvals, medical information, notes for the student file.
Whatever happened with a student is written in the system. In the group you can write “I logged an incident for group X in the system”.
Parents don’t get information about a specific child in a parent group.
6. How to know the move worked
The move has worked when nobody goes back to the spreadsheet, even when nobody checks. Three signs show it:
- The share of groups reporting on time in the system is stable or rising, without personal reminders.
- Questions like “where’s X’s mother’s phone number?” are answered from the system, not from a spreadsheet.
- Incidents with students no longer appear in WhatsApp groups.
Common mistakes
- Moving every process on the same day.
- Copying spreadsheets as they are, duplicates and all.
- A parallel period with no end date.
- Broad permissions for everyone “for now” that are never narrowed.
- A director who keeps asking for reports in Excel, sending everyone back to the spreadsheet.
Want to see what the move would look like for you? In one session we’ll map your existing spreadsheets and groups and decide which process to start with.
