Where spreadsheets break down in admissions and enrollment

A spreadsheet can hide the workflow

A spreadsheet may be useful for a small, defined task. It becomes risky when it becomes the admissions system of record. Multiple tabs and copies can hide who owns an application, which status is current, which document was approved, and what the family was told.

Review the journey from inquiry to enrollment and identify every place staff copy, filter, export, email, or reconcile data. Those handoffs show where a spreadsheet is adding risk rather than simply recording work.

The control problems are predictable

Shared files make least-necessary access difficult. Version history may not explain a decision. A formula can be changed without a workflow owner noticing. A download can create an untracked copy of applicant or guardian information.

Test who can view, edit, approve, publish, export, correct, archive, and delete each field or record. Do not assume that file permissions provide the same control as task-level permissions.

Know when to move on

Consider a new system when correction effort, duplicate identities, missed deadlines, family confusion, reporting uncertainty, access risk, or handoff failures exceed the school’s capacity to manage them safely. Fix definitions and ownership before buying.

GOV.UK procurement guidance recommends minimum necessary data, access control, security, supplier accountability, incident notification, and clear end-of-contract handling. The U.S. Department of Education data governance checklist connects quality, access, security, lifecycle, sharing, disposal, and monitoring.

If a spreadsheet remains temporarily

Name the owner, approved purpose, access list, retention period, change record, correction route, backup, and reconciliation step. Keep it narrow and remove it when the authoritative workflow is ready. Convenience is not a sufficient retention or access policy.

Make the next action clear

Use this guidance to improve one bounded part of where spreadsheets break down in school admissions software. Name the owner, affected record, evidence needed, and review date. Keep the test small enough for admissions staff to complete and specific enough for a later audit.

Check both an ordinary application and one meaningful exception. If either depends on undocumented knowledge, add the missing definition, training note, permission rule, or support route before calling the next step ready.