In the AI era, this decades-old program still has accountants’ hearts

A Datarails FP&A survey of 212 US and UK finance professionals found 82% have a high or moderate emotional attachment to Microsoft Excel (45% 'love' it; 43% 'love-hate'), and more than half would decline a job that disallowed Excel. The survey reports 89% run at least half of their finance processes through Excel, 99% spend at least three hours per day on it (83% of respondents aged 22–35 use it more than five hours daily), and 84% of CFOs expect Excel to be equally or more important in the next 10 years—signaling strong incumbent stickiness that may temper near-term migration to new AI-driven finance platforms and influence enterprise software spending timelines.

Analysis

Market structure: Excel’s incumbency (82% emotional attachment; 89% of processes run through it) creates a winner-take-most dynamic for incumbents and integrators. Microsoft (Office 365/Power BI) and adjacent tooling vendors (Alteryx AYX, UiPath PATH, Salesforce/CRM for Tableau) benefit from integration and network effects; pure-play AI/FP&A challengers face higher customer-acquisition costs and slower churn than models assume. Pricing power shifts toward platforms that embed Excel compatibility rather than replacements, keeping ARPU steady for integrated suites over the next 12–36 months.

Risk assessment: Tail risks include a rapid AI-layer that reliably replaces spreadsheet workflows (low-probability within 12–24 months, high-impact) or regulatory crackdowns on spreadsheet-driven controls that accelerate migrations (medium probability). Immediate (days–weeks) effects are hiring/training budget decisions; short-term (3–12 months) are procurement cycles and add-on tool sales; long-term (2–5 years) is gradual architecture change. Hidden dependencies: VBA/macros technical debt, on-prem files, and human trust—these amplify switching costs and error risk.

Trade implications: Favor long incumbents with clear Excel hooks: MSFT (core), AYX (data prep), PATH (automation). Consider relative shorts or underweights in pure-play planning vendors that lack Excel-first strategies (Anaplan PLAN, selective SaaS FP&A names) as adoption assumptions recalibrate. Use 6–12 month call spreads on MSFT to capture continued monetization and buy LEAPs or 9–12 month calls on AYX for optionality; rotate into these names over 30–90 days ahead of major earnings/CFO guidance.

Contrarian angle: Consensus that AI will quickly replace Excel is likely overdone—historical parallel: Lotus→Excel entrenchment. Mispricings exist in funded AI-native FP&A startups where growth assumptions ignore user inertia; an unintended consequence is rising demand for audit/compliance software (Workiva WK) if errors from spreadsheet use trigger regulatory action. If >25% of S&P500 finance orgs announce non-Excel migrations within 12 months, reprice positions aggressively.

Key Decisions for Investors

• Establish a 2–3% long position in MSFT (buy $MSFT or 6–9 month call spread, e.g., buy 1 ATM call, sell 1–2 higher strikes) within 30 days to capture Office365/PowerBI stickiness and new AI features—target 15–25% upside in 6–12 months, trim into strength.
• Allocate 1–2% long to AYX (Alteryx) via 9–12 month calls or stock to play data-prep automation demand from Excel-heavy teams; exit or reassess at +40% or on miss of next two quarters' enterprise booking trends.
• Establish a tactical pair trade: long MSFT (2%) / short PLAN (Anaplan) (1%) over 3–12 months to capture relative resilience of Excel-integrated platforms vs. Excel-replacement sellers; close if PLAN reports >10% quarter-on-quarter ARR growth or MSFT guidance disappoints.
• Underweight pure-play AI/FP&A startups and non-integrated planning SaaS (reduce exposure by 50% vs. benchmark) until they demonstrate >30% enterprise migration references that include Excel compatibility; monitor SEC/CFO guidance for regulatory catalysts over next 6 months.