Claude in Excel: The Right Way to Do It in 2025/2026
This year, we've started using cluade inside Excel (ant later on inside Word and Power point, but that will be for another post)
Claude now lives directly inside Excel as an official add-in—no API keys, no Power Query hacks, no Python scripting. Anthropic ships and maintains it. You can be up and running in two minutes.
What You'll Need
A Microsoft 365 subscription (Excel 2021+ on desktop or Excel on the web) and a Claude Pro, Max, Team, or Enterprise plan ($20/month for Pro). That's it.
The Setup
Open Excel, go to Insert → Add-ins (or Home → Add-ins), search for "Claude by Anthropic for Excel," install it, and sign in with your Claude account. Once it's open, the keyboard shortcut Ctrl+Alt+C (Windows) or Ctrl+Option+C (Mac) toggles the Claude sidebar at any time.
No API key. No M code. No custom functions to maintain. Claude opens as a sidebar panel and reads your entire workbook.
What It Actually Does
This is meaningfully different from the old Power Query approach. Claude can answer questions about specific cells, formulas, and whole worksheets, returning cell-level citations so you can verify the logic; update key assumptions without breaking downstream dependencies; and diagnose errors like #REF!, #VALUE!, or circular references, tracing them back to their source.
In plain terms for AEC work:
Cleaning vendor data: Paste your messy subcontractor material descriptions into a column, tell Claude in the sidebar what naming convention you want, and ask it to rewrite the column. It edits the cells directly.
Categorizing tasks: Drop your full list of line items into a sheet and ask Claude to assign CSI MasterFormat divisions. It reads the context of each row—not just the text—which means it catches edge cases that a formula-based approach would miss.
Extracting information: Got addresses in random formats? Ask Claude to extract just the municipality, or parse the street name, across the whole sheet. Plain English instruction, done.
Building from scratch: Claude can create pivot tables and charts to visualize your data, or upload files directly into your workflow, while maintaining full transparency by tracking changes and providing clear explanations at every step.
What Changed from the Old Method
The Power Query / Python approach described in older tutorials required you to manage an API key, write M code or Python functions, handle rate limits yourself, and babysit the whole thing when Excel updated. It was clever, but fragile. The official add-in handles all of that invisibly. Claude reads the entire workbook, understands nested formulas and multi-tab dependencies, and every explanation references specific cells. It's a proper collaborator, not a formula wrapper.
Plan Requirements
The add-in currently works only with Pro, Max, Team, or Enterprise plans — a free account may install but won't activate properly. For teams, IT administrators can deploy it centrally through the Microsoft 365 Admin Center by searching for "Claude by Anthropic for Excel" in Microsoft AppSource.
Pro Tips (Still Valid)
Test your instructions on 5–10 rows before asking Claude to reprocess thousands. Give it concrete examples of the output you want — it does better with "format like this: Concrete H-25 / 20mm aggregate / EN 206" than with abstract descriptions. Save your best prompts somewhere reusable. And for 500+ rows of heavy processing, still grab a coffee.
The workflow hasn't changed — delegate the brain-numbing parts, focus on the work that actually needs your judgment. The setup just got a lot less painful.
What repetitive Excel tasks are eating up your project time? Drop a comment below.