Published Sep 14, 2026 · Updated Oct 24, 2026

When spreadsheets become an operating system

When spreadsheets become an operating system

A workbook can be a database, a process manual and a set of business rules at the same time. Replacing it with software starts by separating those jobs.

Find the rules, including the overrides

Follow an actual order or report through the files. Identify who enters the information, which formulas affect a decision and where the result is copied next. Ask about hidden columns and manual corrections. An override may represent an exception the business still needs.

In ZMatic’s ERP project, understanding the dependencies between spreadsheets informed the data model and migration. The replacement connected customer history, orders, reporting and client self-service.

Do not turn every tab into a screen

Decide what the record represents and which system owns it. An illustrative example: after an approved order changes to a partial delivery, the application needs rules for the remaining quantity, status, documents and information sent to finance. Storing the rows does not define that behavior.

Write the exceptions into the requirements with the roles allowed to handle them. The people using the workbook can confirm whether the proposed behavior preserves the rule or deliberately changes it.

Move the data and the responsibility

Keep the original files. Map identifiers, choose which history to move and list incomplete or conflicting entries. Assign someone to resolve them rather than filling gaps with guessed values.

Rehearse the import and check totals, relationships and complete tasks. Agree when the new system takes over and how problems will be reported. If both remain in use, specify which one owns each record.

That is the starting point for custom ERP discovery: understand the business inside the files before designing their replacement.

More from the Blog