Excel Artificial Intelligence: What the Phrase Actually Means in 2026
Search "excel artificial intelligence" and you get a Microsoft task pane, an Anthropic add-in, a worksheet function, a dozen marketplace listings and a product that plugs into your accounting system. These are not variants of one thing. They are five different technologies wearing the same phrase, and which one you want depends entirely on the job you had open when you started searching.
This page is a map rather than a recommendation: for each of the five, what it is, what it genuinely does well, and the point at which it stops. Some of them are free and already installed on your machine, which is the part most articles on this subject skip.
The five things people mean
- Copilot — Microsoft's AI pane, built into Excel, licensed separately.
- Claude for Excel — Anthropic's add-in, tied to a Claude subscription.
- AI worksheet functions — marketplace add-ins that put a model call inside a formula, the
=GPT()class. - Desktop add-ins that also reach the accounting system — a smaller category aimed at finance work.
- The AI Excel already shipped — Flash Fill, Analyze Data, linked Data Types, the Forecast Sheet. Genuinely machine learning, rarely called AI, already paid for.
Three questions separate them, and none is "which model is smarter". Does it see the whole workbook or only what you hand it? Does it apply the change, or describe one for you to type? Can it reach the system the numbers came from? Hold those up against any product on this list and the marketing falls away quickly.
1. Copilot: the pane Microsoft built in
Copilot is a task pane you open from the Copilot icon in Excel's lower-right corner. It reads the data you point it at and works with real Excel objects — adding and renaming sheets, writing values and formulas, applying conditional formatting and data validation, building charts and PivotTables whose source-data links you can edit afterwards. The output is an Excel object you own, not a picture of one. Its data sources, per Microsoft's documentation, are OneDrive, SharePoint, local Excel files and the web, plus federated connectors on commercial subscriptions — a list skewed towards market data and productivity tools.
Two limits are worth knowing before you plan around it. Its attention is anchored to what you point it at — it is not holding your fourteen-tab consolidation in its head, so cross-model questions come back scoped narrower than you asked. And the worksheet function is going away: Microsoft has said the =COPILOT() function, which lived in the Frontier and Microsoft 365 Insider preview programmes, will no longer be available from 14 September 2026, with the side pane as the recommended replacement. A year from preview to retirement is a fair reminder that AI features in this category are not yet furniture.
Cost is a licence on top of a licence — the add-on sits above your existing Microsoft 365 plan, and the SKU names and prices move often enough that quoting them here would be a disservice. Price it on Microsoft's pricing page on the day you buy. What Copilot in Excel can't do for accountants goes through the file-state gotchas, the sensitivity-label blocks and Microsoft's own advice about using it for financial reporting.
2. Claude for Excel: Anthropic in the sidebar
Anthropic's add-in began as a research preview in late 2025 and, per Anthropic's documentation, is now generally available on Pro, Max, Team and Enterprise plans — no separate per-seat purchase; it comes with the Claude plan you may already have. It installs from Microsoft AppSource and runs on Excel on the web, Excel on Windows with a Microsoft 365 subscription, and Excel on Mac.
What distinguishes it is the review trail. It answers with cell-level citations you can click through to, traces how a number was derived, changes assumptions while keeping formula relationships intact, and works across multi-tab workbooks. For anyone who has inherited a model and spent a morning working out which cell feeds which, that is the useful trick.
The published limitations are unusually candid. Anthropic says it is not recommended for final client deliverables without human review, or for audit-critical calculations without verification. Macros, VBA operations and data tables are unsupported. It does not run on Excel 2016 or 2019 perpetual and volume licences, nor on iPad or Android. And Anthropic publishes an explicit prompt-injection warning: a downloaded template or vendor file can carry hidden instructions aimed at the add-in, so use it on spreadsheets you trust and read the confirmation prompts. That warning applies in spirit to every product on this page; Anthropic is simply the vendor that wrote it down. Every route to getting Claude working inside Excel compares the add-in against the upload, API and Copilot routes.
3. AI inside a worksheet function
A class of marketplace add-ins puts a model call in the grid: =GPT("Classify this expense as Travel, Software or Fees", A2), filled down a column. GPT for Excel Word is the long-standing name here, and Microsoft's short-lived =COPILOT() was the same idea. One product that does not belong in this category, despite the name suggesting it might: OpenAI's own ChatGPT for Excel add-in is a sidebar that edits the open workbook agentically, which puts it with Claude for Excel in category 2 rather than here. Check the vendor's current page for what your plan includes — billing models in this category change more than anything else on this list.
The fit is narrow and real: bulk cell-level text work. Two thousand bank narratives to sort into categories, supplier name variants to normalise, free-text descriptions to turn into something a PivotTable can group. A genuine chore, and one formula does it for a few pounds of tokens.
Three structural hazards come with the territory:
- Formulas recalculate. Every recalculation is a fresh billable call, and because model output is not deterministic, the same input can return a different answer next quarter. Convert results to values the moment you accept them.
- The function sees only its arguments. No workbook context, no other sheets. It can answer "classify this cell"; it can never answer "why doesn't this sheet tie out?".
- Key handling is yours. An API key in an add-in's settings is as safe as the vendor's storage and as private as the workbook's circulation list.
A better pattern than per-row labelling: ask for a description-to-category mapping table, review the sixty rules once, then apply them with XLOOKUP. Reviewable artefact, deterministic result, no ongoing token bill.
4. Desktop add-ins that also reach the accounting system
Everything above shares one gap: the AI sees the spreadsheet but not the system the spreadsheet came from. For finance work that is the wrong half of the problem. The numbers live in QuickBooks Online, Xero, Zoho Books, Odoo, FreshBooks or Sage; the workbook is only where you reconcile and report on them. An AI working from last Tuesday's export is working from last Tuesday.
A smaller category of paid desktop add-ins closes that loop — an AI panel with full workbook context plus authorised connections to the ledger, so "pull last month's unpaid invoices and age them" is one instruction rather than an export, an import and a formula session. The free alternative is the one most teams should try first: export the report, load it with Power Query, hit Refresh All next month. It costs nothing, and it is explained step by step in connecting QuickBooks and Xero data to Excel. It is one-directional, which is its ceiling — nothing goes back to the ledger without re-keying.
HISAB 360 — this site's product, so weigh it accordingly — sits in this category: a chat panel docked in desktop Excel that reads the open workbook and applies changes to it, with read and write connections to those six accounting systems. Judge it on its constraints. It is Windows desktop Excel only, where Copilot and Claude for Excel both also run on Mac and the web and it does not. It is paid, with a 15-day trial and no free tier after it. And every write back to a ledger should be reviewed before you approve it — you are the control, not the model.
5. The AI Excel shipped years ago
This is the part of the landscape most people searching for artificial intelligence in Excel already own and have never tried. None of it is generative, all of it is machine learning, and several of these features solve the exact task that sent someone looking for an AI tool.
- Flash Fill (Excel 2013 onwards, Ctrl+E). Type the result you want beside your data for two or three rows and it infers the transformation. Under the hood it is program synthesis out of Microsoft Research — it generates candidate programs and machine-learning ranking picks the likely one. For splitting names, reformatting reference codes and pulling a cost centre out of a description, it is instant, free and offline.
- Analyze Data (formerly Ideas; Microsoft 365, Home tab). Select a range, ask a question in plain English, get charts and PivotTables back. The documented limits are specific: roughly 1.5 million cells, no compatibility-mode
.xls, no merged cells, text-formatted dates read as text, a single row of unique non-blank headers, and results restricted to rank, trend, outlier and majority — so it sometimes finds nothing rather than inventing something, which is a feature. - Linked Data Types (Data tab). Stocks, Currencies and Geography turn a cell into a record you can expand. The much larger set of Wolfram-sourced data types was retired in June 2023 when Microsoft did not renew that partnership; existing cells kept their values but stopped refreshing — a lesson about building a recurring process on someone else's roadmap.
- Forecast Sheet (Data tab, and
FORECAST.ETS). Exponential smoothing with automatic seasonality detection and confidence intervals. It needs a constant time step and at least two full cycles of history to detect seasonality — below that it quietly falls back to a straight line, which is the trap. Unavailable in Excel for the web, iOS and Android.
Spend twenty minutes here before paying for anything. A meaningful share of "I need AI for this" turns out to be Flash Fill and a PivotTable.
The Excel artificial intelligence landscape in one table
| Route | What it sees | Applies changes | Reaches the ledger | Cost |
|---|---|---|---|---|
| Copilot pane | What you point it at, plus OneDrive/SharePoint/web | Yes, in the grid | No accounting connector published | Licence on top of Microsoft 365 |
| Claude for Excel | Open workbook, multi-tab, with cell citations | Yes, with confirmations | Finance connectors, not small-business ledgers | Included with a paid Claude plan |
=GPT()-class functions | Only the arguments you pass | Text into the cell | No | Tokens or credit packs |
| Ledger-connected desktop add-ins | Open workbook plus connected ERP data | Yes, in the grid and back to the ledger | Yes, via OAuth, subject to review | Subscription or perpetual |
| Built-in (Flash Fill, Analyze Data, Forecast) | The selected range | Yes, immediately | No | Included with Excel |
How to use AI in Excel without inheriting a wrong number
Whichever route you pick, the discipline is the same, and it is short.
- AI for words and structure, formulas for arithmetic. Classification, cleaning, drafting a query, explaining an inherited formula — good. Any figure that lands in a report should come from
SUMIFS,XLOOKUPor a PivotTable, where you can see the logic. - Freeze AI output. Copy the result range and paste over it with Paste Special > Values. Non-deterministic results that recalculate are not workpapers.
- Review the rule, not the row. Sixty mapping rules you can read beat three thousand labels you cannot.
- Foot everything back. Agree a control total and a row count to the source before the output goes anywhere. A plausible wrong number is more dangerous than a
#N/A. - Settle the data question first. Whether client data may leave your environment is an engagement-terms question, not a software setting. Read the terms of the tier you are actually on, anonymise identifiers where the task allows, and prefer routes where the file stays put.
Choosing, briefly
- A repetitive text edit you are doing by hand. Flash Fill. Free, five seconds, already installed.
- A first look at an unfamiliar dataset. Analyze Data, then a PivotTable. Also free.
- Interrogating a complicated model you did not build. Claude for Excel on a paid Claude plan; Copilot if your organisation already licenses it.
- Classifying thousands of free-text rows. A worksheet-function add-in with results converted to values — or better, a mapping table applied with
XLOOKUP. - Getting data out of the ledger and adjustments back in. None of the first three solves that: Power Query for the free one-directional version, a ledger-connected add-in for the round trip.
Two further reads if you are narrowing down: what AI in Excel actually does for accountants, and best AI Excel tools for accountants, which compares the named products with prices.
The honest summary: "Excel artificial intelligence" is a category label doing too much work. There is no single product behind it, no ranking that survives contact with your actual job, and a decent chance the feature you needed shipped in 2013 and sits under Ctrl+E.
Frequently asked questions
What is artificial intelligence in Excel?
It is not one feature. The phrase covers at least five separate things: Microsoft's Copilot task pane; Anthropic's Claude for Excel add-in; marketplace add-ins that put an AI call inside a worksheet function; desktop add-ins that combine workbook context with a connection to your accounting system; and the older machine-learning features Excel has shipped for years — Flash Fill, Analyze Data, linked Data Types and the Forecast Sheet. They differ on what the AI can see, whether it applies changes, and what it costs.
Is there free AI in Excel?
Yes, if you count the features you already own. Flash Fill, Analyze Data, the Forecast Sheet and linked Data Types are included with Excel — Analyze Data needs a Microsoft 365 subscription — and they cost nothing extra. The generative-AI layer is where the money is: Copilot in Excel needs a licence, Claude for Excel needs a paid Claude plan, and function add-ins bill per token or credit. Before paying, spend twenty minutes on the built-in features, because they solve more day-to-day work than their reputation suggests.
How do I use AI in Excel without getting a wrong number?
Use AI for text and structure, formulas for arithmetic. Ask it to classify descriptions, clean an export or draft a query, then convert AI output to static values with Paste Special so it cannot silently change on the next recalculation. Do every figure that lands in a report with SUMIFS or XLOOKUP, not a prompt. Foot the result back to a control total you trust, and remember that the review is the audit evidence, not the model's answer.
Can Excel AI pull data from QuickBooks or Xero?
Not in most of the routes. Copilot in Excel reads OneDrive, SharePoint, local workbooks and the web, and no accounting ledger appears on Microsoft's published connector list. Claude for Excel ships finance connectors aimed at market data rather than small-business ledgers. Worksheet-function add-ins see only the range you pass them. The free route is to export a report and load it with Power Query; the paid route is a desktop add-in that holds an OAuth connection to the ledger itself.
Try HISAB 360 on your own workbook
HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.