Build vs. buy

When a spreadsheet should become a system

Listen to this piece read aloud in a recorded voice, narrated by Daniel.

A spreadsheet can be a useful place to understand a workflow. Over time, it may also become the place where the firm assigns responsibility, records approvals, and relies on a shared answer. I would examine that change in responsibility before choosing a replacement. The decision should follow the controls and working behavior the process needs, along with the cost of moving it.

Source

A faster route to software changes the temptation

DORA’s 2025 AI-assisted development report emphasizes the relationship between AI and the surrounding organization. It does not establish that replacing a spreadsheet with software improves a particular workflow.

I would make the missing control explicit before evaluating a replacement. The availability of an easier build path is useful, but the proposal should still be judged on permissions, history, correction, and ownership.

Synthesis

Look for a change in responsibility

The number of rows is a weak starting point for this decision. A large analysis workbook may be perfectly suitable for one person’s work. A small sheet can carry much more risk if it is the only record of who approved a consequential action.

Ask how the file is used. Do several people edit it at once? Do users need different permissions? Must changes be attributable? Does the workflow depend on validation, reminders, or a reliable handoff? Can the owner explain how an incorrect change would be detected and reversed?

GDS guidance on creating and sharing spreadsheets covers practices such as documentation and versioning. Improving those basics may resolve the immediate problem without a migration.

Proposal

Identify the control that is missing

Consider a hypothetical vendor-renewal tracker. If one person maintains dates and prepares a monthly review, a documented workbook may serve well. If several departments must approve renewals with different access and an enduring decision history, the workflow has acquired responsibilities that may deserve another platform.

Name the actual gap: conflicting versions, unclear ownership, weak validation, permissions that are too broad, or changes that cannot be traced. Then assess whether the existing tool can address it in a supportable way.

A replacement should improve the identified gap. A custom application that reproduces the spreadsheet’s ambiguity in a new interface has added maintenance without resolving the reason for moving.

Compare modest alternatives

Evaluate a better-managed workbook, a capability in an existing platform, and a narrow application against the same needs. Include setup, licensing, training, support, and the cost of changing established habits.

Test a small workflow with representative users. Let them create, update, review, and correct a record. Check permission differences and export the result. A visually polished demonstration can conceal missing operational behavior.

Make the owner explicit. Someone must maintain the fields, manage access, resolve exceptions, and decide how the process evolves. The software does not assign those responsibilities by itself.

Move with an acceptance plan

If a migration is justified, map the fields, preserve stable identifiers where possible, and reconcile the information. Inspect formulas, hidden columns, manual conventions, and historical sheets before deciding what transfers.

AWS’s cutover guidance offers useful principles for validation and reversal. Applied here, that means a clear cutover owner and a plan for work created during the transition.

Choose when the old workbook becomes read-only, where its history remains available, and how users will find the new process. Avoid leaving two apparently authoritative versions in circulation.

The decision is ready when the team can explain which responsibilities have outgrown the current arrangement and how the proposed system will handle them. That explanation matters more than the label attached to either tool.

Proposal

What I would test next

I would prototype only the responsibility the current workbook cannot meet sustainably. Ask users to complete and correct real representative tasks. If a better-managed workbook performs equally well, retain that simpler arrangement.

Companion resource

Spreadsheet-to-system assessment

Open, print, or download the worksheet.