The Question Worth Answering Before You Touch Another Excel Formula
What exactly is Claude in Excel? Not the rumour, not the demo on Twitter, but the practical version that landed in every Microsoft AppSource marketplace on 7 May 2026. The version a Hong Kong restaurant owner, freight forwarder, or boutique accounting firm could install before lunch and use to ask, in plain Cantonese or English, "What were my top three slow-moving SKUs last quarter?"
For 35 years, Excel has been the most powerful, and most quietly frustrating, business tool on earth. The formulas hide on the second row. The macros break when a column moves. Your accountant guards the pivot tables. Claude in Excel is the first serious attempt to flip that relationship, where the spreadsheet works to your spoken question, not the other way around. This guide explains what it does, what it costs, and whether it makes sense for your business this quarter.
What Is Claude in Excel?
Claude in Excel is an official Microsoft Excel add-in, released by Anthropic on 7 May 2026, that puts an AI assistant directly inside the Excel sidebar. It reads your workbook, understands the formulas and dependencies, and lets you ask questions or request edits in plain language. You type "compare Q1 and Q2 revenue by branch, show me a chart" and it produces a working pivot, citation of which cells it used, and a chart, in seconds. It works on Windows, Mac, and Excel for the web.
For a Hong Kong SME boss, the practical definition is simpler: a chat box on the side of your Excel that can read every tab, do the analysis your accountant would normally do, and explain why each number is what it is.
How Does Claude in Excel Actually Work?
Claude in Excel operates through a sidebar pane and a deep integration with the workbook's native structure. When you ask a question, three things happen behind the scenes: the add-in reads the relevant cells, sends a structured representation to Anthropic's servers, and returns an answer with cell-level citations so you can verify every number. Unlike screenshot-based AI tools, it preserves formulas, dependencies, and named ranges.
The three practical capabilities:
1. Reading. It opens multi-tab workbooks, follows references across sheets, and explains what each formula does. Useful when an accountant leaves and you inherit a 12-tab pricing model.
2. Editing. It can update assumptions, add new columns, and re-run scenarios while preserving downstream formulas. The original is never overwritten without your explicit approval.
3. Cross-app context. If you paid for Claude Pro, Max, Team, or Enterprise, the same conversation context carries from Excel to PowerPoint and Outlook. Summarise an invoice email, switch to Excel for the calculation, then have a slide drafted from the same data.
What Can a Hong Kong SME Boss Actually Do With It Today?
The use cases that move the needle for a typical 5-to-50-person Hong Kong business fall into five buckets. Each one used to require an accountant, a junior analyst, or a freelance bookkeeper. Now they need only a clear question.
1. Monthly P&L summary in 90 seconds. Drop a year of bank or accounting exports into a workbook, ask "summarise revenue and expenses by month and highlight the three largest variances." A working summary table appears with cell citations.
2. Customer segmentation without a data analyst. Feed in a sales export. Ask "group these customers by frequency and average order value, rank them by lifetime contribution, and label the top tier." The result is a working segmentation, with formulas you can edit.
3. Cash-flow projection for a bank or grant. Provide last 12 months of cash movement. Ask "project next 6 months at three growth rates, show me a sensitivity table." The projection arrives with the assumptions clearly labelled.
4. Inventory ageing for retail and F&B. Upload an inventory CSV. Ask "which SKUs have not sold in 60 days, and what is the total tied-up capital." A clean ageing report appears with totals.
5. Cleaning messy supplier data. Paste in a copy of a vendor list with inconsistent formats. Ask "standardise the company names, split address into 3 columns, flag duplicates." This task that takes a junior 4 hours now takes 30 seconds.
How Much Does Claude in Excel Cost?
Claude in Excel is included at no extra charge with any paid Claude plan. Pro is US$20 a month per user, Max is US$100 a month per user, Team is US$25 a month per user with a 5-user minimum, and Enterprise pricing is custom. There is no separate Excel add-in fee. The add-in itself installs free from Microsoft AppSource; you only need a paid Claude account to use it.
To put that in Hong Kong SME terms: a part-time junior bookkeeper costs roughly HK$10,000 to HK$15,000 a month for 20 hours of routine spreadsheet work. A Claude Team subscription for five users is approximately HK$975 a month and removes the bulk of that routine work. The maths only fails if the AI cannot do the job well, and for spreadsheet-shaped tasks, the 2026 release does the job well.
What Are the Real Limits of Claude in Excel in 2026?
The honest answer is that Claude in Excel is not magic, and treating it as magic is how SMEs get burned. There are four limits worth naming clearly.
Four limits you should plan for:
1. It is only as good as your data. Messy headers, blank rows in the middle of a table, and inconsistent date formats still trip it up. Cleaning the input is now a 30-second task instead of an hour, but you still have to do it.
2. Workbook size limits. Files above roughly 25,000 active rows or 30 active tabs can slow the assistant. For most SMEs, this is comfortably outside their daily workbooks.
3. It is a tool, not an auditor. Claude is excellent at producing a number with a citation. It is not a chartered accountant. Decisions that need professional sign-off still need a human professional.
4. Data sensitivity. Workbook contents are sent to Anthropic's servers for processing. For most SME work this is acceptable, but personally identifiable customer data, employee salary details, or anything bound by Hong Kong's Personal Data (Privacy) Ordinance needs a deliberate review of your data handling policy before you start.
How Does Claude in Excel Compare to Microsoft Copilot?
Both products live inside the same Excel sidebar slot, and the comparison is fair to make. Microsoft Copilot for Excel was first to market in 2023 and is bundled with Microsoft 365 Copilot at US$30 per user per month. Claude in Excel is newer, arrived May 2026, and is included with Claude plans.
The practical differences a Hong Kong SME boss should weigh:
Quality of reasoning. Independent benchmarks from Anthropic's launch materials and early third-party tests in May 2026 show Claude leading on multi-step financial reasoning tasks, particularly long-form workbook analysis. Copilot remains competitive on quick single-cell or single-tab tasks.
Cross-app context. Both tools span Excel, PowerPoint, and Outlook. Claude additionally supports persistent context across apps within a single conversation, which is useful for sales-and-finance workflows that touch all three.
Pricing. Copilot is US$30 per user. Claude Pro is US$20 per user, with Excel included. For a 5-user team, that is a difference of roughly HK$390 per user per month, or HK$23,400 per year for a team of five.
The right answer. If your business already runs on Microsoft 365 E3 or E5 with Copilot bundled, sticking with Copilot has no friction. If you are starting fresh, or your team finds Copilot's responses thin on multi-tab analysis, Claude in Excel is the stronger pick in mid-2026.
Common Misconceptions That Slow SMEs Down
"It will replace my accountant." No. It will replace the 30% of accounting work that is rote spreadsheet manipulation. Your accountant becomes more valuable, not less, because the routine work that used to occupy half their week is now done in minutes.
"I need to learn prompt engineering." Not really. The 2026 release is forgiving. If you can write a clear sentence in English, Cantonese, or Mandarin describing what you want, it will produce a useful first draft. Iterating on results is faster than learning a new syntax.
"My data is too messy." Messy data is exactly what Claude in Excel was designed to clean. Inconsistent date formats, mixed currencies, duplicates, missing values: all of these are routine tasks for the assistant.
Frequently Asked Questions
Q: Does Claude in Excel work in Cantonese or Traditional Chinese?
Yes. Claude understands and responds in Cantonese, Mandarin, English, and dozens of other languages. You can mix languages in the same prompt without issue.
Q: Can I install it on my existing Excel without IT?
Yes. The install is a standard Microsoft AppSource add-in. If your company uses Microsoft 365 Business Basic, Standard, or Premium, you can install it yourself in under 2 minutes. Some Enterprise tenants have add-in restrictions that require IT approval first.
Q: Does it work offline?
No. Claude in Excel needs an internet connection because the AI processing happens on Anthropic's servers, not on your local machine.
Q: Is my data used to train Claude?
On paid plans, Anthropic's default policy is that customer inputs are not used to train models. Enterprise customers can sign data processing addendums for additional contractual protection.
What This Means for Your Business in the Next 90 Days
The big shift Claude in Excel signals is not a single new feature. It is the death of "the person in your company who knows Excel". For three decades, every Hong Kong SME has had one indispensable spreadsheet person. That person became a single point of failure: when they went on leave, the business slowed; when they left, an entire layer of institutional knowledge walked out the door.
In 2026, that knowledge moves into the workbook itself. The assistant can read, explain, and modify any workbook regardless of who built it. The cost of getting a new junior up to speed drops from weeks to days. The cost of asking "what would happen if rent went up 12%" drops from an hour to thirty seconds.
That said, dropping a powerful tool into a business is not the same as getting value from it. The companies that win in the next 90 days will be the ones that pick three specific spreadsheet tasks, automate them with Claude in Excel, and measure the hours saved. Not the ones that announce an "AI transformation" and run no experiments.
UD has helped Hong Kong SMEs through 28 years of technology shifts, from on-prem to cloud, from email to instant messaging, from manual to automated. The pattern is the same every time: the businesses that move first on a tested workflow win, and the ones that wait for a "complete solution" pay more later. UD stands with you, making AI human.
Ready to Find Three Workflows in Your Excel That Should Run Themselves?
Knowing what Claude in Excel can do is one thing. Picking the right three workflows in your business to test first is another. Our team will walk you through every step, from a one-hour audit of your existing spreadsheets to a 30-day pilot that pays for itself.
