At Build 2026, Microsoft officially announced that Anthropic's Claude (Opus 4.8) has arrived in Excel's Agent Mode. For the roughly 750 million Excel users worldwide, the implication is direct: you no longer need to know formulas or VBA. Just describe what you want in plain English, and Claude does the work right inside your spreadsheet. Below is a breakdown of what it can do, how to install it, and the risks to watch for.
What exactly is Claude for Excel?
Claude for Excel is an add-in that embeds Claude directly into your spreadsheet workflow. It does not just answer questions passively; it acts as a spreadsheet agent that reads your data, understands context, performs analysis, and proactively proposes and applies changes. Since Build 2026, Excel Agent Mode officially supports Claude Opus 4.8.
Why do reviewers say it beats Copilot?
The key lies in two things: preserving formula dependencies and explaining every step. When Claude changes any value or assumption, it preserves the entire sheet's chain of formula dependencies and adds a comment at each edit explaining what it changed and why. For anyone building financial models, that transparency matters far more than a bare answer, and it is why several reviews rate it above general-purpose Copilot for spreadsheet work.
Five core capabilities
Claude for Excel's core abilities fall into five areas: writing formulas, cleaning data, running analysis, building models, and adding safeguards. Each follows the same principle: you describe the need in plain language, and Claude executes while explaining every step. Each is detailed below.
Writing formulas in plain language
You simply describe your goal in English (or Chinese), and Claude writes the matching Excel formula, VBA macro, or even Power Query expression, validating the syntax and explaining the logic. For example, type "calculate each customer's cumulative spend over the past 12 months and flag the top 10%," and it generates the formula and fills the cells, with no trial-and-error required from you.
Cleaning and analysing data automatically
Claude can clean inconsistently formatted data: removing duplicates, harmonising date formats across columns, and restructuring layouts. For analysis, it reads an entire dataset at once, surfaces patterns, computes aggregate metrics, runs cohort analysis, and explains in words what the data actually means, rather than handing you a pile of numbers.
Building a complete model from scratch
If you are starting from zero, a single description is enough for Claude to build a complete model: structure, formulas, and formatting, explaining what it is doing as it goes. For small businesses that need to quickly assemble a budget, a cash-flow forecast, or a sales model, this can compress hours of work into minutes.
"Ask before edits": it checks before changing
Claude offers an "Ask before edits" mode that requests your permission before modifying your sheet's data. Combined with a comment at every change, you retain full visibility into what it touched, preventing the AI from silently overwriting important values. Keep this mode on the first time you use it, and adjust later once you are comfortable.
How to install and activate it
Installation is simple: go to the Microsoft Marketplace, search for "Claude for Microsoft 365," click "Get it now" to install the add-in, then open Excel, activate the add-in, and sign in with your Claude account. Once installed, Claude appears as a side panel, and you can converse with it directly inside the spreadsheet.
A security risk you must note
The single most important point: only use Claude for Excel with trusted spreadsheets, never with files from unknown external sources. The reason is "prompt injection" attacks, where malicious instructions hidden inside spreadsheet content can trick the AI into performing actions you never intended. Before handling external files, confirm their source and keep "Ask before edits" enabled.
Who benefits most?
Colleagues in financial analysis, accounting, reporting, and administration gain the most, because their days are filled with repetitive spreadsheet work. If your company already uses Microsoft 365, this add-in is worth trying immediately: from writing formulas to building models, the savings go beyond time and into fewer human errors. Once AI can handle Excel work, the natural next question is which other roles it can fill on your team. Visit ai.ud.hk to explore UD's AI Staff solutions and see how AI can become a member of your team.
懂AI，更懂你｜UD相伴，AI不冷
