How to Use AI in Excel: Copilot, Claude and Gemini Compared

There are three main ways to use AI inside a spreadsheet in 2026: Copilot in Microsoft Excel, the Claude for Excel add-in, and Gemini in Google Sheets. Each needs a paid or eligible plan. The free alternative is to describe your sheet to a free AI chat assistant, ask for the formula, and paste it in yourself, which works well for most formula problems.

This guide compares the three built-in options, shows the free method step by step, and lists prompts that work for accounts and office work. It also covers what AI in Excel still gets wrong. Plan details change often, so we name the official page for each and the date we checked it: 13 November 2026.

Which AI options work inside Excel and Sheets?

Pick the one that matches the software your office already pays for. If your firm is on Microsoft 365, check whether Copilot is already in your licence before buying anything. If it uses Google Workspace, check Gemini first. The Claude add-in is the option to consider if you already pay for Claude or want its explanations with cell-level citations.

How do you use AI in Excel for free?

You can use any free AI chat assistant as a formula helper without installing anything. The method is the same in Claude, ChatGPT or Gemini.

1. Describe the layout, not the data. For example: “Column A has invoice dates, B has party names, C has GSTIN, D has taxable value, E has GST. Row 1 is headers. Data is in rows 2 to 500.”
2. Say what you want and which Excel version you have. For example: “In F2, I want the total taxable value for the party in B2 for the same month. I use Excel 2019, so no newer functions.”
3. Ask for an explanation. Add: “Explain the formula in one line, and tell me which cells to test it on.”
4. Test it on rows where you know the answer before copying it down.

The Excel version matters. Newer functions such as XLOOKUP and FILTER do not exist in older perpetual versions, and AI tools often suggest them by default. If you are rebuilding your Excel basics, our guide to Excel for accountants covers the functions AI suggests most often.

How do you set up Claude for Excel?

Anthropic’s documentation gives three steps for an individual:

1. Open the “Claude for Microsoft 365” listing on Microsoft AppSource and choose “Get it now”.
2. Open Excel and activate the add-in (Home, then Add-ins on Windows; Tools, then Add-ins on Mac).
3. Sign in with your Claude account on a Pro, Max, Team or Enterprise plan.

Once it is running, you can ask about the open workbook and get answers that link to the exact cells. It can also change assumptions while keeping formulas linked, trace errors such as #REF! and #DIV/0!, and build or fill in models. It can sort, filter, edit pivot tables and add data validation. Anthropic lists data tables, macros and VBA as unsupported, and does not recommend the add-in for “audit-critical calculations without verification” (Claude documentation). Plan costs in rupees are covered in our Claude AI guide.

Which prompts work best for accounts work?

Good spreadsheet prompts name the columns, the result you want, and how you will check it. These work in any of the three tools, or in a free chat assistant if you describe the layout first.

For GST work, the reconciliation result is only as good as the rules behind it. Our guides to input tax credit rules and GST return filing explain what a mismatch means once AI has found it.

What does AI in Excel still get wrong?

AI can produce a formula that looks right and runs without errors but answers a slightly different question. The common failure points are:

• Wrong ranges: it assumes data stops at a row, or misses a header.
• Version mismatch: it suggests a function your Excel does not have.
• Silent assumptions: it treats blank cells as zero, or text numbers as text.
• Confident explanations of the wrong cell: follow the cell links it gives and check them.
• Hidden instructions in files: Anthropic warns that downloaded templates and vendor files can contain instructions that try to manipulate the add-in into extracting or changing data, so use it only with trusted spreadsheets.

The fix is a habit, not a tool. Work on a copy, test on rows with known answers, and review every change before you save. Client data needs the same care as anywhere else: our guide to AI for accountants covers what should never be uploaded.

Is AI in Excel worth learning for a job?

Yes, if you already know Excel. Employers hiring accountants and analysts still test the basics: lookups, pivots, clean data and checking. AI makes a person who knows those basics faster. It does not help much someone who cannot tell when the answer is wrong. ICAI’s own AI course for chartered accountants includes a full module on Excel automation with AI add-ins (ICAI AICA Level 1 document), which shows where the profession expects the skill to go. See ICAI’s AI course explained for details, and our TallyPrime guide for the accounting software skill that usually sits next to Excel on a job description.

Frequently asked questions

Still deciding?

If you are planning the skills for your first accounts or finance job, a counsellor can help you decide what to learn first. Book online career counselling or call 9212008787.