All insights

Guide

Five things to check before replacing a spreadsheet with a web system

A practical checklist for deciding what to clarify before turning a spreadsheet-based workflow into a web system.

A spreadsheet can be the right tool for a long time. The goal is not to replace it because it feels old, but to notice when the workflow around it has become harder to trust than the file itself.

1. Map the repeated work

Write down who opens the file, what they add or change, how often they do it, and what happens next. A useful system starts with the real sequence of work, including the messages and manual checks that happen outside the spreadsheet.

2. Choose one source of truth

Decide which record is authoritative when a spreadsheet, email thread, shared folder, and someone’s memory disagree. A new interface will not solve conflicting ownership unless the team agrees where the final answer lives.

3. Define the smallest useful workflow

Start with one recurring outcome, such as receiving a request, assigning it, and confirming completion. Avoid rebuilding every column and exception at once. A smaller first release is easier to test with the people who actually use it.

4. Keep exceptions visible

Real operations contain missing information, urgent requests, overrides, and cases that need human judgment. Record those paths explicitly. Automation should make exceptions easier to notice and resolve, not hide them behind a success message.

5. Plan access and handoff

Confirm who can view or edit each record, who maintains the system, and how data can be exported. The team should still understand the workflow after the original builder is no longer in the room.

A good first step is to map one current workflow before choosing the technology.

If your team wants help turning that map into a focused, maintainable system, NARU Labs can review the workflow with you.