ChatGPT for Excel: Practical Guide for Formulas and VBA

ChatGPT for Excel is now two different workflows: classic copy-and-paste prompting in a browser, and OpenAI's official Excel add-in that can read and update the workbook itself. That distinction matters because the best use cases are different. If you need one formula, plain ChatGPT is usually enough. If you need workbook-aware updates, cleanup, or scenario changes inside Excel, the add-in is the better fit.

The add-in is free to install, works in Excel on desktop and the web and in Google Sheets, and runs on your ChatGPT plan, including Free. Its Microsoft Marketplace listing also covers Word and PowerPoint. Last verified 1 November 2026. Jump to how to install it, what it costs or the test workbook.

When we first wrote this guide, we reviewed the top 5 Google results for "chatgpt for excel" on May 9, 2026, read 6 current OpenAI, Microsoft, and research sources, and mapped the workflow against 5 recurring analyst jobs: formulas, VBA drafts, cleanup, model updates, and workbook explanation. The ranking pages mostly cover prompt tips and add-in setup. The main gap is practical guidance on when the official Excel add-in is better than copy-paste chat, and where it still stops.

For the 1 November 2026 update, we read Microsoft's Copilot in Excel support page, Anthropic's Claude for Excel docs, Microsoft's add-in deployment guide and the ChatGPT listing on Google Workspace Marketplace. We also read OpenAI's help article, launch post, release notes and product page and the ChatGPT listing on Microsoft Marketplace in a browser that day. Plans, usage and models change often, so open the linked source before you rely on a plan or usage detail. We did not run tasks inside ChatGPT for Excel. Instead we built a six-task test workbook you can run yourself, with expected answers computed from the same numbers the workbook formulas use.

What Is ChatGPT for Excel?#

ChatGPT for Excel is OpenAI's spreadsheet add-in for building, updating, and analyzing workbooks directly inside Microsoft Excel.

OpenAI's 5 March 2026 launch post introduced the add-in in beta, powered by GPT-5.4, to help users build and update models, run scenarios, and generate outputs based on cells and formulas. A 22 April 2026 update added ChatGPT for Google Sheets in beta plus app integrations and skills, and a 5 May 2026 update says ChatGPT for Excel and Google Sheets became generally available across all plans, powered by GPT-5.5. The product page says it can build full spreadsheets, answer questions across tabs, add and edit formulas, and update sheets in real time.

Two additions since launch are worth knowing. The help article lists default Skills for financial modeling and corporate finance formatting, and apps from your ChatGPT account can carry over into the add-in, subject to admin controls. The launch post names financial data integrations in ChatGPT itself, including Moody's, Dow Jones Factiva, MSCI, Third Bridge and MT Newswires (FactSet was listed as coming soon). For Excel on desktop, OpenAI's help article also describes using Codex in the ChatGPT desktop app to work with an open workbook through the add-in.

The most useful product detail is not the launch headline. It is the operating model. OpenAI says ChatGPT for Excel explains what it is doing, links answers to the cells it references and updates, preserves formulas and formatting, and asks for permission before making changes. That is a real shift from the older workflow where users copied a prompt into ChatGPT, copied a formula back out, and hoped it fit the workbook.

ChatGPT for Excel at a Glance (November 2026)#

Every row below comes from an OpenAI page or a marketplace listing. Plans, usage and models change often, so check the linked source on the day you decide.

How to Install ChatGPT for Excel#

The official add-in is listed as ChatGPT, published by OpenAI. Several third-party add-ins also use "GPT" or "ChatGPT" in their names, so check the publisher before you install.

Install in Excel#

1. Open Excel on desktop or the web.
2. Go to Home, then Add-ins (Microsoft's add-in guide), and search for ChatGPT.
3. Add the one published by OpenAI. You can also click Get it now on the Microsoft Marketplace listing.
4. Open ChatGPT from the ribbon and sign in with the ChatGPT account that has your supported plan (OpenAI help article).

We found no minimum Excel build on OpenAI's pages, and no statement on Excel 2016 or 2019 perpetual licences; if your company is on one, test the install before you plan work around it. If your company blocks the store, a Microsoft 365 admin can deploy a Marketplace add-in to users or groups from Settings, Integrated apps in the admin center, as Microsoft's deployment guide describes. OpenAI's help article gives a manifest route for the same case: in the admin center go to Integrated apps, select Deploy Add-in, then Upload custom apps, upload the manifest file and assign it to users or groups.

Install in Google Sheets#

1. Install ChatGPT by OpenAI from the Google Workspace Marketplace.
2. Open a sheet, then open ChatGPT from the Extensions menu.
3. Sign in with the ChatGPT account that has your supported plan (OpenAI help article).

If you use a work account#

In team workspaces admins control access. OpenAI's product page says the feature is disabled by default in Enterprise workspaces, and its launch post said access was off by default in Enterprise, Edu and Teacher workspaces, with admins enabling it through role-based access controls. If it installs but won't let you sign in with your work account, ask your ChatGPT workspace admin whether it is turned on for you.

How Much Is ChatGPT for Excel? Plans and Usage Limits#

ChatGPT for Excel has no price of its own. You install it free and it draws on the ChatGPT plan you sign in with.

OpenAI's 5 May 2026 release note and help article describe the limits this way:

For Business and Enterprise, OpenAI's rate card says Excel and Sheets use token-based pricing and that a typical task may use 5 to 20 credits per message. The help article says Business, Enterprise, Edu and K-12 customers had a free preview through 2 June 2026, after which usage follows each plan's credits and usage terms. We found no fixed number of Excel requests per plan on OpenAI's pages, so treat any number you see on a third-party page with caution. For ChatGPT plan prices, check OpenAI's pricing page on the day you buy.

Test ChatGPT for Excel on a Real Task: Six-Task Workbook#

The fastest way to judge the add-in is to give it a workbook with known answers. We built one for that.

Download the ChatGPT for Excel test workbook

Format: XLSX · 6 sheets (Start, Tasks, Sales, Summary, Forecast, Answers) · 6 tasks with expected answers · No signup · Not yet run in ChatGPT for Excel by us: expected answers only

It is a fictional Q3 2026 sales ledger for "Northfield Supplies" with 64 invoice rows, a region summary against targets, and a three-year revenue and EBITDA forecast. Every forecast number is a live formula. We planted five problems: 4 duplicate invoices, 9 non-standard region labels, 5 dates typed as text, a #N/A in the summary, and empty scenario inputs. We built the file with a Python script, re-opened it, and recomputed every expected answer from the cell values. The Answers sheet lists each expected number by task, plus the region-by-month grid for Task 6. We have not run these prompts in ChatGPT for Excel ourselves, so the workbook gives you expected answers, not our verdict.

Save a copy before you start and run the tasks in order: the expected answers for Tasks 2 to 4 assume Task 1 has cleaned the ledger to 60 rows. Score each one: pass means the right number with no collateral edits, partial means the right number but overwritten formulas or cells you did not ask about, fail means a wrong number.

Task 1: Clean up the ledger#

Prompt: "On Sales, standardise the Region column to North America, EMEA, APAC or LATAM, convert text dates to real dates, and remove duplicate invoice rows. Tell me how many rows you changed or removed."

Expected: 64 rows become 60, with 4 duplicates removed, 9 labels fixed and 5 dates converted. Watch whether it shows you the duplicate invoices before deleting them, and whether the Revenue column stays a formula.

Task 2: Write and fill a formula#

Prompt: "Add a Gross margin % column to Sales after COGS, using Revenue and COGS, fill it down, and tell me the Q3 gross margin for the whole ledger."

Expected: 33.9%. A common miss is averaging the row percentages, which gives 39.2%, instead of dividing total gross profit by total revenue.

Task 3: Answer a question across tabs#

Prompt: "Which region had the highest Q3 revenue after cleanup, what was its revenue, and what was its gross margin? Cite the cells."

Expected: North America, $322,427, at a 34.9% gross margin. The answer should link to the Summary or Sales cells it used.

Task 4: Trace an error#

Prompt: "Summary!E8 shows #N/A. Explain why and fix it without hard-coding the target."

Expected: the target table on Summary (A13:B16) spells the region "N. America", so the VLOOKUP finds no match. After the fix, North America attainment is 107.5%. Typing the target into E8 is a fail even if the number is right.

Task 5: Run a scenario#

Prompt: "On Forecast, run a scenario with a 5% price increase and a 2% unit decline from FY2027E. Use the scenario input cells. Report FY2027E revenue and EBITDA and the change versus base."

Expected: FY2027E revenue of $1,704,067 (+$48,025 against base) and EBITDA of $276,677 (+$68,454). Only Forecast!C6 and C7 should change.

Task 6: Hit a documented limit#

Prompt: "Create a PivotTable of Q3 revenue by region and month on a new sheet."

OpenAI's product page has listed Pivot/Data Model work among features not yet supported, so this task tests how the add-in handles a limit. If it builds a real PivotTable, the totals should match the region-by-month grid on the Answers sheet. If it can't, a good result says so and builds a SUMIFS table that matches the grid. Claiming a PivotTable that isn't there is the failure to watch for.

The same file works for any Excel AI add-in, so you can run it through Copilot or another assistant and compare results on identical data.

Continue reading: Tornado Charts in PowerPoint · PowerPoint Conditional Formatting · 30-60-90 Day Plan Template

ChatGPT for Excel vs Copy-Paste ChatGPT#

ChatGPT for Excel is better than copy-paste chat when the workbook context matters.

That is the pattern across the current SERP. The top-ranking pages mostly teach three things: how to install an add-in, how to ask for formulas, and how to paste the answer into Excel. That still works, but it is no longer the full story. OpenAI's current product page shows a different workflow: the add-in can work inside the file, summarize trends across tabs, explain formulas, clean up sheets, and update tables without forcing you to translate everything into pasted examples first.

Use this rule:

For many analysts, the best setup is mixed: plain ChatGPT for fast one-off answers, ChatGPT for Excel when the workbook needs to stay in the loop.

ChatGPT for Excel for Formulas#

ChatGPT for Excel is strongest on formula writing and formula explanation.

OpenAI's help and product pages both position formula help as a core use case, and the current search results reflect that intent. This is still the first reason most people search for chatgpt for excel.

Two practical rules matter more than prompt cleverness: test the output on a few rows before you trust the full column, and ask for the logic in words, not just the final formula.

That second rule is where ChatGPT for Excel beats a pure formula generator. OpenAI says the add-in links answers to the cells it references and updates, so the explanation can stay tied to the workbook instead of floating in a separate browser tab.

If formula help is your main use case, read AI for Excel, Best AI for Excel, and Excel AI next. Those guides compare formula tools against broader workbook agents.

ChatGPT for Excel for VBA Drafts and Automation#

ChatGPT for Excel is useful for VBA drafting, but it is not a VBA automation engine.

This is the section many ranking pages blur. Third-party tutorials often promise "use ChatGPT for macros" as if the add-in can directly automate VBA inside Excel. OpenAI's current product FAQ says it does not. The limitations section explicitly lists macro or Visual Basic for Applications automation as unsupported.

That means the right workflow is:

Prompt examples that work:

• "Write a VBA macro that splits the active sheet into separate tabs by the value in column A."
• "Explain what this VBA procedure does and call out any destructive steps."
• "Rewrite this macro so it checks for blank headers before it runs."
• "Convert this macro into clearer subroutines with comments."

ChatGPT for Excel for Cleanup, Scenarios, and Model Explanations#

ChatGPT for Excel is more valuable for cleanup and workbook explanation than most formula-only posts admit.

OpenAI's product page uses examples such as cleaning up a sheet, fixing inconsistent labels, removing duplicates, summarizing trends across three tabs, and updating a table to reflect new assumptions. Those are better examples of real analyst work than generic "write a SUMIF" prompts. Tasks 1, 3 and 5 in the test workbook cover exactly these jobs.

This is where the official add-in starts to justify itself:

There is also a broader adoption point here. Microsoft and LinkedIn's 2024 Work Trend Index surveyed 31,000 people across 31 countries and found that 75% of knowledge workers already use AI at work. The question is no longer whether spreadsheet teams will use AI. The question is which jobs can be trusted to AI with review, and which still need tighter controls.

Where ChatGPT for Excel Stops#

ChatGPT for Excel is not a full replacement for Excel power features, and OpenAI is explicit about that.

The current product page says some advanced capabilities are not supported yet, including Office Scripts, Power Query, Pivot or Data Model work, data validation, named ranges manager, slicers, timelines, advanced charting breadth beyond the current supported set, and VBA automation. OpenAI also notes that very large workbooks may exceed the context window, which can lead to partial results.

That has two direct implications:

OpenAI's help page adds two trust details worth knowing. First, it says ChatGPT for Excel activity is separate from your main ChatGPT chat history. Second, it says some of your data logs may be stored with OpenAI for 30 days for safety and integrity purposes, and that Microsoft may be able to read workbook content and prompts under its add-in marketplace terms. Before you open a client or board file in the add-in, check your workspace's data controls with your ChatGPT admin, or your own data-training setting on a personal plan.

The reason this caution matters is simple: spreadsheet reasoning is still hard. The 2023 paper InstructExcel: A Benchmark for Natural Language Instruction in Excel includes more than 10,000 samples across 170-plus Excel operations and 2,000 public spreadsheets, and the authors describe it as a hard benchmark even for GPT-4. Treat ChatGPT for Excel as an analyst assistant, not an unchecked final reviewer.

If you need multi-sheet cleanup, audits, output-sheet generation, and an agent that asks before replacing existing values, Deckary's Excel agent is built for that job, and the same Premium plan covers AI in PowerPoint and Word for the deck that follows. If you want the Microsoft-first path, compare this with Microsoft Copilot for Excel and How to Use Copilot in Excel.

ChatGPT for Excel vs Copilot in Excel vs Claude for Excel#

All three are AI assistants that run inside Excel and edit the open workbook. The differences are licensing, where they run, and what they leave out. The Copilot and Claude columns were checked against Microsoft's and Anthropic's pages on 1 November 2026; the ChatGPT column comes from the OpenAI sources above, read the same day.

When ChatGPT for Excel fits best#

You already pay for ChatGPT, or want to start on its Free plan, and you also work in Google Sheets. One sign-in covers Excel, Sheets, Word and PowerPoint.

When Copilot in Excel fits best#

Your company already licenses Copilot for Microsoft 365. Microsoft says Copilot in Excel can create and edit charts and PivotTables, and offers edit, plan and chat-only modes. Our Microsoft Copilot for Excel guide covers setup and licensing.

When Claude for Excel fits best#

Your team already uses Claude on a paid plan and wants cell-level citations and connectors such as S&P Global, LSEG and Daloopa inside Excel. Anthropic says it does not support data tables or macros and VBA, and that it does not run on Excel 2016 or 2019 perpetual or volume licences, iPad or Android.

For a ranked view across more tools, including finance-specific add-ins, read Best AI for Excel.

Best ChatGPT for Excel Prompts for Analysts#

ChatGPT for Excel works best when the prompt names the workbook object, the task, and the output.

These prompts are simple on purpose. The current SERP is crowded with prompt lists, but specificity beats novelty.

Should You Use ChatGPT for Excel?#

ChatGPT for Excel is worth using if your workflow already lives in Excel and you want workbook-aware help with formulas, explanations, cleanup, and scenario updates. It is a real step up from browser-only prompting because it can read the sheet, link answers to cells, and write changes back into the file with permission prompts.

It is not the best fit for every spreadsheet job. If you want one quick formula, plain ChatGPT is faster. If you need Power Query, VBA automation, or PivotTables, ChatGPT for Excel still has gaps. For consultants, FP&A teams, and finance users working in high-stakes files, run the test workbook on your own setup first.

For the other Office apps, see ChatGPT for PowerPoint and ChatGPT for Word. For the broader buying decision, read AI for Excel, Best AI for Excel, and Microsoft Copilot for Excel.

FAQ#

What is ChatGPT for Excel?#

ChatGPT for Excel is OpenAI's Excel add-in that can build, update, explain, and summarize spreadsheets inside Excel instead of forcing you to copy prompts in and out of a browser. Its Microsoft Marketplace listing also covers Word and PowerPoint.

Can ChatGPT write Excel formulas?#

Yes. ChatGPT can write, explain, and revise Excel formulas, and the Excel add-in can do that with live workbook context instead of only pasted cell examples.

Can ChatGPT create VBA macros for Excel?#

Yes for drafting VBA code and explaining it, but OpenAI says ChatGPT for Excel does not currently support macro or VBA automation inside the add-in itself.

Does ChatGPT for Excel edit workbooks directly?#

Yes. OpenAI says the add-in can update spreadsheets in real time, asks for permission before changes, and links answers to the cells it references and updates.

Is ChatGPT for Excel available on free plans?#

Yes. OpenAI lists ChatGPT for Excel for Free, Go, Plus and Pro users and for Business, Enterprise, Edu, Teachers and K-12 workspaces. Free and Go include limited usage, and workspace admins control access in team workspaces.

How do I install ChatGPT for Excel?#

In Excel, go to Home, then Add-ins, search for ChatGPT, add the one published by OpenAI, and sign in with your ChatGPT account. You can also install it from its Microsoft Marketplace listing. In Google Sheets, install ChatGPT from the Google Workspace Marketplace, then open it from the Extensions menu.

How much is ChatGPT for Excel?#

There is no separate price. The add-in is free to install and draws on your ChatGPT plan. OpenAI's 5 May 2026 release notes say Free and Go include limited usage, Plus and Pro use the same agentic usage limits as Codex, and you can buy extra credits beyond plan limits.

Which GPT is best for Excel?#

For work inside a live workbook, use OpenAI's official ChatGPT for Excel add-in rather than a custom GPT or a third-party "GPT for Excel" add-in. OpenAI said GPT-5.5 powered the add-in when it became generally available on 5 May 2026; models change, so check the add-in for the one it uses today.

When should you use Deckary instead of ChatGPT for Excel?#

Consider Deckary when the workbook job is multi-step and finance-heavy, such as building a model, auditing an inherited workbook, or generating output sheets linked to source data, and you also want AI in PowerPoint and Word for the deck that follows. Deckary's agent asks before replacing existing values.

Sources#

Microsoft, Anthropic, Google and OpenAI pages and the Microsoft Marketplace listing read on 1 November 2026. Plans and usage change often; open the source to confirm current details.

• OpenAI Help Center: ChatGPT for Excel and Google Sheets
• OpenAI: Introducing ChatGPT for Excel and new financial data integrations (5 March 2026, with updates on 22 April and 5 May 2026)
• OpenAI: ChatGPT for Excel and Google Sheets
• OpenAI: ChatGPT release notes
• OpenAI: ChatGPT Business release notes
• OpenAI: ChatGPT rate card for Business and Enterprise/Edu
• Microsoft Marketplace: ChatGPT by OpenAI
• Google Workspace Marketplace: ChatGPT by OpenAI
• Microsoft Support: Get started with Copilot in Excel
• Claude docs: Use Claude for Excel
• Microsoft Learn: Deploy Office Add-ins in the Microsoft 365 admin center
• Microsoft Support: Start using your Office Add-in
• Microsoft and LinkedIn: 2024 Work Trend Index Annual Report
• InstructExcel: A Benchmark for Natural Language Instruction in Excel

Related Guides#

• AI for Excel
• Best AI for Excel
• Excel AI
• Microsoft Copilot for Excel
• How to Use Copilot in Excel
• ChatGPT for PowerPoint
• ChatGPT for Word