I’ve spent years working with CIOs and CFOs on IT planning cycles, and one thing has stayed remarkably consistent: a remarkable number of the most consequential technology investment decisions get made on the back of a spreadsheet.
It feels familiar. It feels fast. It feels in control.
It isn’t.
In my experience, the reliance on Excel for IT budgeting and portfolio planning is one of the most normalized dysfunctions in enterprise technology management. It’s not a minor inefficiency – it’s a structural problem that distorts decisions, erodes strategic alignment, and quietly caps the maturity of the entire IT organization. And yet most organizations have never seriously evaluated what it would mean to replace spreadsheets for IT budgeting with a purpose-built planning system. The cost of that inertia compounds every planning cycle.
What Spreadsheets Can’t Do
Prioritization Without a Framework
At the heart of any IT planning cycle is a deceptively hard question: which initiatives should we fund, and in what order? It’s a strategic decision, and it deserves a strategic framework. Spreadsheets don’t provide one.
The culprit is almost always the same: reviewing initiatives one by one, with no structured framework for ranking them. Every leader shows up ready to defend their own projects, nobody wants to be the one who challenges a peer’s priorities, and the room avoids conflict so consistently that the final ranking ends up being less a strategic decision and more a polite compromise. The initiatives that needed a hard conversation rarely get one.
There is another casualty that I rarely see being acknowledged – the top half of the portfolio gets well scrutinized. The bottom half doesn’t. As leadership fatigue sets in, the tail end of the portfolio slides through without the same rigor – and that’s where the waste lives. I’ve seen organizations routinely absorb 5 to 10 percent of their IT budget in low-impact, strategically or even operationally irrelevant spend because nobody had the energy to challenge it.
That’s not governance. That’s inefficiency dressed up as planning.
Governance Without Guardrails
Effective planning governance requires clear workflows: who submitted, who reviewed, who approved. Spreadsheets have none of this built in. There is no approval workflow – sign-off happens over email, or in a meeting, if it happens at all. I’ve seen budget changes annotated through comments when someone remembers to do it, and undocumented when they don’t. There is no role-based access or row-level security: anyone with the shared link can edit anything. The result is a governance process that is slow, inconsistent, and nearly impossible to audit – and when something goes wrong, there is no system record to fall back on.
When a CFO asks ‘who approved this $4M project and on what basis?’ the answer should be a system record. In a spreadsheet-driven world, it’s often a forwarded email thread – if it exists at all.
Analytics That Live Outside the Plan
In my experience, senior leadership never reviews the spreadsheet itself. Every planning readout presented to a CxO audience requires someone to manually extract data from the plan and build a PowerPoint deck – charts, graphs, status summaries – created separately, maintained separately, and perpetually at risk of being out of sync with the underlying numbers. There are no integrated analytics. The plan and the insight are always two different artifacts, maintained by two different people, at two different points in time. I’ve watched skilled analysts spend entire weeks doing nothing but rebuilding the same charts every time a number changed.
No Connection to Strategic Planning
If the IT plan needs to align to a Long-Range Plan – and it should – that alignment is done manually, because the LRP typically lives in a different spreadsheet. Every time either document changes, someone has to reconcile them by hand. I’ve never seen this work reliably at scale. There is no link between investment decisions and strategic objectives that the system can enforce or monitor. Strategy and execution remain perpetually disconnected, joined only by the heroic effort of individuals who have to bridge the gap themselves.
The Manual Effort Hiding in Plain Sight
Perhaps the most underestimated cost of spreadsheet-driven planning is the sheer volume of manual work it generates. Consolidating submissions, validating data, resolving conflicts between versions, rebuilding charts for leadership decks, re-entering figures when budgets change – none of this creates value. All of it consumes the time of the most experienced planners and analysts in the organization. When I talk to teams that have made the transition to a structured IT planning tool, the reduction in low-value manual effort is almost always the first thing they mention – and the relief in how they describe it tells you everything.
The IT Credibility Problem
One of the most corrosive consequences I’ve observed is the friction that spreadsheet-driven planning creates between the CIO and the business units IT serves – whether that’s Finance, Operations, Sales, Marketing, or any other CxO stakeholder. The friction rarely surfaces as a disagreement about process. It surfaces as doubt: doubt about whether the right projects are being prioritized, whether the costs are justified, whether the promised value will actually materialize.
When priorities can’t be explained beyond “the team reviewed it,” when budget requests lack transparent justification, and when claimed benefits are disconnected from any measurable outcome, business leaders lose confidence – not just in the plan, but in IT’s ability to manage investment with rigor. That loss of confidence is expensive. It slows approvals, invites second-guessing, and gradually sidelines IT from the strategic conversations where it should have a seat.
When CIOs can justify every priority, every dollar, and every expected outcome with clarity and evidence, IT stops being a cost center to be scrutinized and starts being a strategic partner to be consulted.
The Strategic Imperative
The organizations I’ve seen win with technology investment are not the ones with the biggest budgets. They’re the ones with the best planning discipline – faster, better-informed investment decisions, the ability to course-correct quickly, and the ability to demonstrate clear value from every dollar committed to technology.
That discipline starts with infrastructure. And infrastructure starts with an honest reckoning about the tools you’re using today.
If your IT planning cycle still runs on spreadsheets, the question isn’t whether that’s holding you back. It is. I’ve seen it hold back organizations that were capable of much better. The question is how much longer you’re willing to pay the hidden cost.
