Replace the spreadsheet the business runs on

Some of the riskiest systems in a business are not systems at all. They are an Excel workbook only one person understands, an Access or FileMaker database nobody wants to touch, and a chain of manual approvals in an inbox. We assess what the business actually depends on, then stabilize, connect, replace, or retire it without losing the rules that keep operations running.

This page is for the spreadsheets, Access and FileMaker databases, and manual tools your business depends on but nobody built as software. If the problem is an application or codebase your team already runs, and it has become expensive or fragile to change, start with application modernization.

1-2wk
Initial Risk Review
Documented
System Map and Business Rules
Staged
Migration, Not a Big-Bang Cutover
Named
Owners for Critical Workflows

Replace, rebuild, connect, or leave it alone?

Age alone does not decide what happens to a system. The useful questions are what the business depends on, where the risk actually sits, and which parts still work well enough to keep. These are ordered by how much they disrupt the people doing the work.

Ordered by disruption to the business

None

Leave it alone

Keep the spreadsheet when it has a clear owner, few users, controlled inputs, and no material operational or compliance risk. Not every spreadsheet needs software.

Low

Stabilize

Fix the immediate reliability, access, or backup risk when the tool still does its core job and replacing it would create unnecessary disruption.

Low

Connect

Keep the tool but wire it into the CRM, finance platform, or reporting layer when re-entry and reconciliation cause most of the pain.

Review systems integration
Medium

Retire

Remove it when the process is no longer needed, or a standard product can handle it without recreating the old complexity.

Staged

Replace in stages

Move one workflow, user group, or record type at a time when the business cannot tolerate a big-bang cutover.

High

Rebuild

Build a supported system when the tool holds valuable business logic but its technology, controls, or user experience can no longer be maintained safely.

The honest answer is sometimes that the spreadsheet is fine. We will tell you that.

They deliver quickly and understand our business needs clearly, which makes for easy communication and real results.

Peter Keckemet

Peter Keckemet

Chief Financial Officer, Aviation Holdings

Read the full story

What the risk review
covers

Before anything changes, we map the tool, its data, and the business logic staff rely on. You get a documented view of the critical workflows, owners, formulas, approvals, exceptions, and workarounds, plus the practical options for reducing risk.

We document the formulas, approvals, exceptions, and workarounds staff rely on before anything underneath them changes.

  • Critical workflows and their owners
  • Hidden formulas and decision rules
  • Manual handoffs and exceptions
  • The workarounds nobody wrote down

We review where records live, who can change them, how errors surface, and whether the business could restore or audit what happened.

  • Data quality and duplicate records
  • Permissions and audit history
  • Backup and recovery reality
  • Migration and retention requirements

We assess unsupported versions, fragile integrations, undocumented macros, and dependence on the one person who knows how it works.

  • Key-person and support dependencies
  • Unsupported versions and platforms
  • Integration and deployment risk
  • Options ranked by disruption and value

Signs the spreadsheet has become a business risk

01

One person owns the spreadsheet logic

A business-critical workbook depends on formulas, macros, or manual steps that only one or two people understand. When they are away, the work waits.

02

Access or FileMaker is hard to change

The database still runs an important process, but reporting, permissions, remote access, or vendor support have become unreliable.

03

Staff maintain shadow systems

Teams export from the main system into local spreadsheets because the official workflow or reporting no longer fits how the operation actually runs.

04

Every change risks breaking something else

Undocumented rules and integrations make a small request expensive, slow, and difficult to test safely.

Replace it without stopping the business

01

Assess

System and Risk Review

Document the workflow, data, ownership, controls, and the cost of leaving it alone.

02

Choose

The Modernization Path

Compare stabilizing, integrating, staged replacement, rebuild, and retirement.

03

Migrate

Data and Workflow Transition

Move records and users in controlled stages, with validation and a fallback at each step.

04

Hand Over

Supported Operation

Leave documented rules, permissions, and a system more than one person can support.

4 phases

Questions about replacing a spreadsheet or database

These come up in almost every first conversation about a business-critical spreadsheet or database.

No. A well-owned spreadsheet with few users, controlled inputs, and low operational risk may be entirely appropriate. Replacement earns its cost when dependency, errors, access, scale, or auditability have become real problems.

Yes. The right path may be to stabilize it, move it to a supported environment, connect it to your other systems, or replace it in stages once the data and business rules inside it are documented.

Usually not. A staged approach moves one workflow, user group, or integration at a time while the existing tool keeps supporting live operations.

The review identifies which records must be migrated, archived, or retained for reporting and compliance. Data is validated before anyone relies on the replacement.

Get in touch about a Legacy System Risk Review

Bring the spreadsheet, database, or internal tool your team depends on. We will help identify what to keep, fix, connect, replace, or retire.

A bit more about your project (optional)

* field required.

Kipanga is committed to protecting and respecting your privacy, and we'll only use your personal information to provide the products and services you requested from us.