Digital Adoption for SMEs: What to Do When Staff Keep Using Spreadsheets

Why Do Staff Keep Using Spreadsheets? Start by Listening—Not Blaming

Spreadsheets enjoy an almost mythical status in many small and medium-sized enterprises (SMEs). They’re endlessly adaptable, often free, and—let’s be honest—once a workflow gets entangled in a thick web of spreadsheets, even the most ambitious Microsoft Excel update or flashy SaaS promise can struggle to unseat them. When leadership invests in a new business system—a CRM, an inventory platform, a cloud-bookkeeping tool—and staff keep reverting to spreadsheets, it’s tempting to write this off as resistance to change. But diagnosing the real causes is more nuanced, and it’s where digital adoption for SMEs frequently gets derailed before it ever starts.

It’s critical to uncover the true “why” behind spreadsheet stickiness:

• Familiarity equals speed: Staff often rely on spreadsheets because they know all the keyboard shortcuts, formulas, and tricks that enable them to complete tasks quickly. Learning a new system—even a better one—inevitably slows things down at first, and SMEs operate on tight margins.
• Flexibility versus rigidity: Many generic business systems require strict data input rules or follow workflows that can feel ill-suited for complex, messy realities. Spreadsheets are forgiving; they don’t force you to enter all fields, and they let you improvise.
• Past change fatigue: If employees have lived through unsuccessful or half-baked rollouts, they may have low confidence that this time will be any different. That perceived instability leads them back to what’s reliable: their old sheets.
• Invisible dependencies: Sometimes it’s not the main system that’s at fault. Staff keep certain spreadsheets because clients, suppliers or partners demand information in that format, or a legacy reporting need isn’t fulfilled elsewhere.

Consider Jane from inventory management. She’s been promised that the new stock control system will automate her daily reconciliation. But after three weeks, she’s still dumping the system report into her colour-coded spreadsheet because it’s the only way she can spot anomalies at a glance. The platform may technically “work,” but Jane doesn’t trust or understand its reporting logic yet, and the output can’t be tailored as quickly as she needs.

Leaders need to approach these patterns with curiosity, not frustration. Otherwise, digital adoption efforts treat only the symptoms, while real operational bottlenecks—and staff’s legitimate concerns—go ignored. Top-down mandates rarely work if workers feel unheard.

Training, Workflow—or Both? Don’t Confuse the Barriers

SMEs often default to “more training” as the antidote for lacklustre adoption of new business technology. But employee adoption of business systems rarely hinges on training alone. The issue is often a misalignment between how the new process fits into the daily work reality versus the way management or the software vendor imagined it would.

Here’s how the barriers often get tangled—and how to untangle them for clearer action:

• Training Gaps: If staff complain that “it’s too complicated” or “I keep making mistakes,” it may point to insufficient onboarding, lack of hands-on demonstrations, or inadequate documentation. This is more pronounced if the software is genuinely unintuitive for non-technical users.
• Workflow Problems: If employees say, “It takes longer than the old way” or “I can’t get X from this system,” the issue is likely in workflow design, permissions, or missing integrations. For example, if sales staff must enter the same client data twice because the CRM isn’t connected to finance, that pain isn’t solvable with a better training video.

To distinguish whether the real friction is skills or process, consider job-shadowing, anonymous feedback, or task-based trials. Have employees walk through a typical day using only the new system—where do cracks show up? This hands-on approach will help SMEs diagnose:

• Are employees reverting to spreadsheets only after failing with the new system, or does the system itself send them back by failing their needs?
• Is the training accessible, role-specific, and realistic—offering not just “how to click,” but “how to get my core work done”?

Sometimes, workflow problems are exposed only once real stress-testing occurs. For instance, a time-off approval system might seem perfect in theory but creates headaches if it doesn’t sync with payroll. Miss these distinctions and you risk blaming staff for flaws that aren’t theirs to fix. Remember, digital adoption for SMEs is as much about process alignment as it is about individual skills. Addressing both, rather than defaulting to just one, delivers the strongest long-term wins.

Involve Employees in Process Changes—Or Watch Adoption Stall

One of the most underappreciated levers in driving digital adoption is the degree to which staff are genuinely involved in shaping the transition—not just receiving a new tool handed down from on high. When employees are asked for input in how systems are designed, customized, and rolled out, three things happen:

1. They spot workflow traps that outsiders miss, preventing avoidable bottlenecks.
2. They have a clear stake in the outcome, which builds buy-in for the success of the project.
3. They often become informal champions, organically training peers and troubleshooting issues.

Contrast two approaches:

• The “Big Reveal”: The software is chosen, configured, and only demonstrated to staff at launch. Employees have no voice in its setup. Result: resistance, workarounds, spreadsheet shadow IT, and low engagement with the new system.
• The “Co-creation” Approach: Power users are involved from the test phase. Feedback is actively solicited, with real tweaks made based on front-line needs, such as adding custom fields, automating common reports, or tweaking permissions. Result: more trust, proactive adoption, and fewer ugly surprises.

Here’s a quick self-audit table that SMEs can use to assess their inclusivity level during tech change projects:

SMEs may feel pressure to “go live” quickly and skip these steps, but this rush usually backfires—yielding a system that’s quickly bypassed or resented. Building in rapid staff feedback—via Slack channels, quick surveys, or daily huddles—can surface non-obvious issues (like a report everyone needs but nobody thought to request) before attachment to old spreadsheet routines becomes irreversible.

Set a Supported Transition Period—With a “No Blame” Policy

Expecting staff to simply abandon years of spreadsheet workflows overnight is wishful thinking—and a primary reason digital adoption falters for SMEs. Instead, businesses should plan a time-bound, supported transition period that encourages dual-system use temporarily, with clear communication that mistakes, hiccups and slow progress are anticipated and supported, not penalized. This staged approach produces several crucial benefits:

• Psychological safety: When employees know they won’t be reprimanded for early mistakes or slow uptake, they’re more likely to experiment and eventually commit to the new system.
• Incremental problem-solving: Issues are surfaced and resolved in real time, rather than hidden until it’s too late for technical fixes or moral support.
• Objective timelines: Rather than “If this doesn’t work by next month, we go back to Excel,” set objective milestones (e.g. “All purchase orders must flow through the new system by X date; spreadsheets sunset 30 days after that if error rates remain under Y%.”)

The transition period shouldn’t be a half-hearted compromise where both systems continue indefinitely. Instead, it’s a conscious runway, complete with daily or weekly check-ins, active support channels, and a visible outline of end-dates for old workflows. SMEs often overlook the hidden costs of “shadow IT” spreadsheet use: inconsistent data, duplicated effort, missed reporting deadlines, and compliance headaches.

Leadership should celebrate wins (however small), share real adoption metrics, and surface success stories from team members who’ve made the leap. It may sound like HR fluff, but these stories build peer pressure the right way—and help newcomers see there’s value to pushing through the learning curve. Businesses that treat digital adoption as a series of supported experiments—rather than a compliance mandate—will see much higher commitment and enthusiasm long-term.

Measure Real Adoption Through the Work Actually Done (Not Just Logins)

It’s tempting to judge digital adoption through usage dashboards—counting logins, active sessions, or training completions. But these metrics don’t tell you whether your staff have really replaced spreadsheets, or if they’re simply doing the minimum in the new system before copying everything into their trusty old Excel templates.

To measure meaningful progress, SMEs should focus on outcomes and business impact:

• Are critical business outputs—like invoices, reports, forecasts—being generated by the new system without manual intervention or spreadsheet imports?
• Have you reduced duplicated data entry? (If staff are still updating both the software and their legacy spreadsheets “just in case,” that’s a warning sign of incomplete trust or an unfulfilled functional need.)
• Are error rates, turnaround times, or compliance outcomes actually improving? If the shift causes delays, mistakes, or creates more work, the adoption plan needs to be re-assessed.
• Can team leads and managers access real-time data and generate the reports they need—without emailing staff for an updated copy of a spreadsheet?

Real adoption only happens when the “system of record” is the new platform and spreadsheets are reserved for special, non-routine tasks (like custom analysis). If you find reports are still being reconciled manually each week, or official figures come from a “master spreadsheet” rather than your database, the switch is incomplete and the business is exposed to risk and inefficiency. Smart SMEs treat 100% digital workflows as an ongoing journey, not a checkbox.

Remember: digital adoption for SMEs is not about technology alone—it’s a living, iterative process of aligning systems, people, and real work. Success is measured by the disappearance of redundant spreadsheets, and the appearance of work that runs smoother, faster, and with accountability you can actually trust.

Improve digital adoption for SMEs by addressing workflow problems, supporting employees and measuring whether the new system is actually used.