AI add-ins for Excel: the best 10 compared in 2026

Microsoft 365 Copilot in Excel Best for: organisations already licensed for Copilot

Not an add-in you install so much as a licence you switch on, but it belongs here because it's the default everyone else gets measured against. Copilot lives in a side pane, edits the workbook, and since Agent Mode reached general availability in April 2026 it will work through a multi-step task — build the model, populate it, check it — rather than answering one prompt at a time.

The =COPILOT() worksheet function is the interesting part for anyone who wants AI in cells rather than in a chat pane. It has been rolling out through the Insider and Frontier channels, requires a Copilot licence, and Microsoft has revised its plans for it more than once during 2026. Don't build a production sheet on it yet.

• Stays inside your Microsoft 365 tenant and compliance boundary — usually the deciding factor for regulated teams.
• Agent Mode handles multi-step workbook building, not just single answers.
• Nothing to install or get past an admin if you already hold the licence.

• $30 per user per month on top of your base licence. For a five-person finance team that's $1,800 a year before the base plan.
• It sees the workbook, not your systems. The data still has to get into the sheet somehow.
• The COPILOT function's availability has been a moving target all year.

ChatGPT for Excel Best for: building and interrogating whole workbooks

OpenAI launched this out of beta in May 2026 for both Excel and Google Sheets, running on GPT‑5.4. It reasons across a workbook rather than a selection — how sheets and formulas connect, why an output changed, where an error came from — and it will build a budget tracker or a dashboard from a description. It asks before it writes, so edits can be reviewed or undone.

The financial-data integrations announced alongside it (FactSet, LSEG, S&P Global, Dow Jones Factiva and Daloopa among them) make it a genuinely different proposition for finance teams than a generic chat pane.

• Strongest of the bunch at tracing an error back through a model to the cells that caused it.
• The same add-in works in Excel and in Google Sheets.
• No extra subscription if your team already pays for ChatGPT.

• Task pane only — there's no worksheet function to fill down a column with.
• It works on the open workbook, so recurring reports mean re-opening and re-asking.
• New enough that admin controls and data-handling review are still catching up in a lot of organisations.

Claude for Excel Best for: auditing a model without breaking it

Anthropic's add-in went to general availability in May 2026, having been in beta since October 2025 and open to Pro subscribers from January. The pitch is care: it reads and modifies spreadsheets while keeping formulas and dependencies intact, which is a different emphasis from "here's a new sheet I built for you". It shares conversation context with the Word, PowerPoint and Outlook add-ins, so numbers analysed in Excel can become slides without re-explaining them.

Worth noting for anyone comparing costs: it's an AppSource add-in that authenticates against your paid Claude plan. You need a Microsoft 365 work or school account to host it, but you don't need the $30 Copilot add-on.

How to install the Claude Excel add-in. Open Excel, go to Home → Add-ins → More Add-ins, search AppSource for Claude, and add it. It appears as a task pane on the Home ribbon. Sign in with your Claude account when prompted; there is nothing to buy inside Excel. If the search returns nothing, your Microsoft 365 admin has AppSource installs locked down, and the add-in has to be deployed centrally instead.

Is Claude for Excel free? No. It needs a paid Claude plan — Pro at $20 a month is the cheapest that includes it, with Max, Team and Enterprise above that. The add-in itself costs nothing extra, so if you already pay for Claude you already have it. There is no free tier and no standalone purchase.

• Conservative with existing formulas and dependencies — the one I'd trust nearest a real financial model.
• Shared context across Excel, Word, PowerPoint and Outlook.
• Rides an existing $20 Claude Pro subscription rather than a per-seat Microsoft add-on.

• Requires a work or school Microsoft 365 account; personal accounts are out.
• Task pane only, no worksheet function.
• No free tier — you need a paid Claude plan.

GPT for Work (GPT for Excel) Best for: bulk cell-by-cell AI work

The veteran of this category and still the most-used add-in for the "run a model on every row" job. You get worksheet functions — classify, extract, translate, summarise, clean — and fill them down a column like any formula. It supports OpenAI, Anthropic and Google models, and you can bring your own API key.

The pricing has split: existing spaces stay on prepaid credits (packs from $29, expiring after a year), while new spaces go onto a per-seat subscription with an included allowance. Credits are pooled across a team on the old model, which was one of its better features.

• Best-in-class for bulk row-level work; nothing else here matches the function set.
• Model choice, including your own API key.
• Pay-as-you-go suits spiky usage far better than a monthly seat.

• No free plan, and prepaid credits expire after twelve months.
• It fills cells; it won't reason about your workbook as a whole.
• Cost is genuinely hard to predict before you've run a real job.

Numerous.ai Best for: solo users doing repetitive text work

Same broad idea as GPT for Work — a function that calls a model per row — with a friendlier on-ramp and a lower entry price if you commit annually. It works in both Excel and Google Sheets, and the common uses are the unglamorous ones: categorising a product list, writing a few hundred meta descriptions, cleaning inconsistent labels.

• Cheapest credible per-cell AI if you pay annually.
• Excel and Google Sheets from one subscription.
• Simple enough to hand to a non-technical colleague.

• Usage is metered in characters, so long prompts burn the allowance faster than the row count suggests.
• The trial costs a dollar rather than being free.
• Team sharing caps out low on the Pro plan.

Ajelix Best for: writing and explaining formulas cheaply

A formula generator, formula explainer and script writer, wrapped in a task pane. The explainer is the underrated half — paste in a nested monster somebody left behind and get a plain-English account of what it does. For a small business that just needs the right XLOOKUP occasionally, this is the cheapest thing on the page that works.

• A real free tier, small but enough to evaluate honestly.
• Formula explanation is excellent for inherited spreadsheets.
• Also handles VBA and Google Apps Script generation.

• It doesn't touch your data — it writes formulas, you run them.
• Ten free requests a month goes fast.
• The jump from $5.95 to $20 is steep for what the Lite tier adds.

Formula Bot Best for: occasional formula help

One of the first tools in this space and still a solid formula generator, with an Excel add-in alongside the web app. The caveat is commercial rather than technical: pricing reported across review sites during 2026 is inconsistent, and the public pricing page has been routing tiers to a sales form. Check what it actually costs before you commit.

• Well established, with a large library of worked examples.
• Does formula generation, explanation and data analysis in one place.
• Historically the cheapest paid option in the category.

• Pricing is genuinely unclear right now — that alone would make me hesitate.
• Overlaps heavily with Ajelix, which has a clearer free tier.
• The formula focus means it isn't an answer engine for your data.

Excel Labs (Microsoft Garage) Best for: free experimentation

Microsoft Garage's experimental add-in, home of =LABS.GENERATIVEAI() — a worksheet function that sends a prompt from the grid to a model and returns the result. It's free, it's the cheapest way to try AI-in-cells at all, and it is explicitly an experiment. Users reported breakage against newer models through early 2026, and Microsoft's own answer to those reports is essentially "it's a Garage project".

• Free, from Microsoft, with no licence gate.
• The genuine in-cell AI function experience, at API cost only.
• Also ships the Advanced Formula Environment, which is worth installing on its own.

• Experimental and unsupported. Don't put it in anything that matters.
• Known reliability problems against current models.
• You supply and manage your own API key.

Coefficient Best for: pulling live system data into the sheet

Coefficient's actual job is connectors — Salesforce, HubSpot, QuickBooks, Snowflake and the rest — landing live data in a sheet on a schedule, with AI layered over the top. It's on the list because for a lot of teams the AI question is downstream of a data question: you can't ask anything useful about your pipeline until your pipeline is in the sheet.

• By far the deepest connector library here.
• Scheduled refresh means the sheet isn't stale by Wednesday.
• Strong Google Sheets support alongside Excel.

• Per-seat pricing gets expensive fast, and the warehouse and ERP connectors most finance teams want sit on the $99 Pro tier, not Starter.
• The AI is a layer on a data-integration product, not the point of it.
• Overkill if your data already arrives as a CSV export.