When should a business replace spreadsheets with a custom portal?

Keep a spreadsheet when it is clear, manageable and suited to the task. Consider a custom portal when several people repeatedly share, update or hand off the same information and the current process is difficult to follow.

Signs that the spreadsheet process needs a review

A spreadsheet is a useful way to organise information, but the surrounding process can become hard to manage. Look at the work around the file, not just the file itself. The question is whether the current method still helps people complete the task accurately and consistently.

  • Several copies circulate and it is not clear which one is current.
  • People repeat the same updates in more than one place.
  • A hand-off depends on someone remembering to send a file or message.
  • It is difficult to see who should act next or what remains unfinished.
  • Clients or staff need a controlled way to submit or review information.

What a custom portal can add

A client or staff portal provides a web interface for people who need to access information or complete steps. It can be designed around the records and workflow agreed for the project. That may include forms, status information, document handling or links to other parts of the business system, if those items are in scope.

A portal is not simply a spreadsheet with a different appearance. It requires decisions about users, records, the steps people follow and what the business needs to maintain. A scoping call should establish whether the portal needs a related CRM, database or workflow system, or whether a smaller website change is enough.

Moving away from a spreadsheet also means agreeing how the existing information will be handled. Identify the current files, who owns them and which fields are still useful. Data migration should be discussed explicitly; it should not be assumed to be part of every portal project.

When not to build a portal

Do not replace a spreadsheet just because a custom system sounds more advanced. A portal may be unnecessary when one person owns a simple file, updates are infrequent and no one needs a separate access route. If the process is understandable and the file is not causing repeated work, keeping it may be the sensible choice.

It may also be worth clarifying the process before commissioning software. If people disagree about what information is needed or who should take each step, a new interface will not resolve that decision by itself. Write down the process first and decide whether software is still needed.

How to scope a move from a spreadsheet

Bring an example of the current file or describe its columns and purpose. Explain who updates it, who reads it, which tasks happen before and after each update, and where the hand-offs occur. Note any client or staff access that is required.

A project then moves through a free scoping call, an agreed scope, design, build and launch. The scope should state which records and user steps are included, whether data migration is included, and what support is needed after launch. Bespoke portal work is priced per project after the scoping call.

Tower Street Web & Apps builds websites, web applications, workflow systems, client and staff portals, CRMs and databases. A discussion can identify whether a portal is appropriate for the task or whether the spreadsheet remains the better fit.

Discuss your requirements

Contact Tower Street to discuss the task and whether a bespoke project is suitable. Bespoke work is priced per project after a free scoping call.

Contact Tower Street

Frequently asked questions

Answers about when should a business replace spreadsheets with a custom portal?.

Do all spreadsheets need to become portals?

No. If a spreadsheet is easy to maintain, has a clear owner and supports a simple process, there may be no reason to replace it.

What can a custom portal add?

A portal can give clients or staff a place to access information and complete agreed steps. The exact features depend on the project scope.

How are portal projects priced?

Bespoke portal work is priced per project after a free scoping call. The price depends on the agreed scope.