The problem is that spreadsheets don’t scale. They don’t update in real time. They’re not collaborative in the way modern operations require. They’re fragile — one wrong formula and the whole model breaks. And they require a designated keeper, which means the data is always one person’s departure away from being lost.
The journey from spreadsheets to systems is one of the most important and most difficult transitions a COO makes. Here’s what it looks like.
Stage 1: The Spreadsheet Era
Every operational data point is captured manually. Capacity is tracked in one spreadsheet. Project status in another. Budget in a third. The COO or their team assembles these weekly into a consolidated view, patching together data from multiple sources.
The insight is always one version behind. The process is sustainable until it isn’t.
Stage 2: The Tool Proliferation Era
Frustrated by the manual overhead, teams adopt specialist tools. One for project tracking. Another for financial planning. A third for people data. Each tool solves its narrow problem well. The integration problem — how do these systems talk to each other — remains unsolved.
The COO now has better data per function but worse synthesis across functions. The spreadsheet re-emerges as the integration layer.
Stage 3: The Connected Operations Era
The mature state is a connected operations stack where the key management systems — project management, capacity planning, budget management, strategic planning — share a common data model and surface integrated views.
At this stage, the COO can see project delivery status and team capacity in the same view. Budget and staffing decisions are connected. Strategic theme progress is visible alongside the work delivering it. The synthesis that used to take three hours every Friday happens automatically.
The Journey Is Worth It
The transition from stage 1 to stage 3 takes most organisations two to four years — not because the technology is hard, but because the process design, data governance, and change management are hard. But the operational clarity that emerges from connected systems is genuinely transformative. Decisions are faster, better-informed, and better executed.
The weekly fire-fighting that consumes the COO’s time in stage 1 largely disappears. That’s not a small improvement. It’s a different way of working.
