Use ChatGPT in Excel and Google Sheets to build, update, and understand spreadsheets, and learn how setup works for your plan.
This feature is available globally to Business, Enterprise, Edu, and K-12 users, and to ChatGPT Free, Go, Pro, and Plus users.
What it is
ChatGPT for Excel and Google Sheets is a spreadsheet-native AI experience that lives in a sidebar inside your Excel and Google Sheets spreadsheets. It can help you build, update, and explain spreadsheets directly, including large, multi-tab files with formulas, references, and assumptions.
ChatGPT for Excel and ChatGPT for Google Sheets are separate spreadsheet experiences, but they support similar workflows: creating spreadsheets from scratch, asking questions about existing spreadsheets, and making updates using natural language.
Who it's for
It's great for spreadsheet-heavy work and projects like:
Building trackers, budgets, plans, and templates from scratch
Cleaning up messy sheets, including formatting, labels, duplicates, and broken formulas
Understanding an unfamiliar spreadsheet, including assumptions, drivers, and key formulas
Updating a model when inputs change and summarizing what changed
Running scenarios and sensitivity tables
Reviewing reporting, KPI, planning, and forecasting work
How to install
Excel
You can find ChatGPT for Excel in the Microsoft Marketplace:
Open Microsoft Excel (desktop or web).
Go to Home
Go to Add-ins
Search for ChatGPT.
Add it, then open ChatGPT from the ribbon.
Sign in with the ChatGPT account that has your supported plan.
If your organization can't access the Microsoft Store for this add-in, a Microsoft 365 admin can deploy it internally using the manifest XML file. To download the manifest file, open the link, right-click it, and select Save As, depending on your browser.
Then, in the Microsoft 365 admin center:
Go to Integrated apps.
Select Deploy Add-in.
Select Upload custom apps.
Upload the manifest file
Assign it to the appropriate users or groups.
Google Sheets
Install ChatGPT from the Google Workspace Marketplace.
Open Google Sheets.
Open ChatGPT from the Google Sheets Extensions menu.
Sign in with the ChatGPT account that has your supported plan.
If your organization uses role-based access control (RBAC), an admin may need to enable the add-in. Go to Workspace settings -> Permissions & roles -> ChatGPT for Excel and Google Sheets -> Enable ChatGPT for Excel and Sheets. Please note that this applies to both Excel and Google Sheets.
Keep in mind, ChatGPT is not a financial, legal, or tax advisor and any outputs should not be considered advice. AI can also make mistakes, so verify the outputs.
How to use it well
Be specific about what you want changed (what to preserve, what to overwrite, and where).
Example: "Update assumptions on the Inputs tab only. Don't change formatting. Summarize changes."
Ask for a plan first when you're making big edits.
Example: "Before editing, outline exactly which tabs/ranges you'll modify."
You can @ mention select sheets in your workbook to focus the prompt.
ChatGPT for Excel and Google Sheets can search the web for information to pull into your workbook.
Prompts to try
"Build a formatted monthly budget with categories, totals, and charts."
"Why am I getting an error in cell B145? Explain the formula chain and propose a fix."
"Summarize trends across these three tabs and call out anything unusual."
"Clean up this sheet: standardize formatting, fix inconsistent labels, and remove duplicates."
"Update this table to reflect the new assumptions and then list exactly what changed."
"Create a new scenario tab that compares base, upside, and downside cases."
Current limitations
Separate experience: Spreadsheet chats operate separately from your main ChatGPT chat history. Conversations and spreadsheet data do not sync between experiences.
Limited memory support: Spreadsheet chats do not have access to ChatGPT memory.
Advanced spreadsheet features: Features such as VBA and macros may not be fully supported.
Review outputs before relying on them: Outputs may be incomplete or incorrect. Review formulas, calculations, citations, and changed cells before sharing or relying on them. For important work, duplicate the file first so you can revert if needed.
Using Skills and Apps with ChatGPT for Excel and Google Sheets
ChatGPT for Excel and Google Sheets support Skills and apps. Skills are reusable playbooks that teach ChatGPT how to handle specific spreadsheet workflows, formats, and review steps.
Apps let ChatGPT for Excel and Google Sheets work with connected data sources so spreadsheet work can be grounded in the right context.
For users
Open ChatGPT for Excel or Google Sheets.
Click + to access Skills and apps.
Select a Skill or use @ to invoke it in your prompt.
Open apps to browse the apps available from your ChatGPT account.
If an app is not available, check whether it has been enabled by your workspace admin.
Ask ChatGPT to build, update, explain, or summarize your workbook.
Review formulas, citations, and changed cells before relying on the output.
For admins
Admins can enable ChatGPT for Excel and Sheets in workspace settings.
Admins can enable apps in the admin portal and control access to individual apps, where supported.
App availability may depend on user entitlements, admin settings, and connected data-source permissions.
Availability and pricing
ChatGPT for Excel and Google Sheets are available globally to Free, Go, Plus, Pro, Business, Enterprise, ChatGPT Edu, and K-12 users. Free and Go include limited usage access. Plus and Pro include access subject to your plan's agentic usage limit.
Business, Enterprise, Edu, and K-12 customers have a free preview through June 2, 2026; after that, usage follows each plan's credits and usage terms.
Agentic usage limits are shared with other agentic features once pricing for those features is effective. For effective dates and feature-specific pricing, see Using Credits for Flexible Usage in ChatGPT for Plus and Pro or the ChatGPT Rate Card for Business and Enterprise.
Usage depends on the size and complexity of the spreadsheet task. Larger workbooks, multi-step edits, and more complex analysis may use more of your agentic usage limit. Business and Enterprise admins can monitor usage and purchase credits for additional access.
For enterprise admins and security teams
ChatGPT for Excel and Google Sheets supports workspace-level enterprise controls including data and inference residency where available, Enterprise Key Management, and role based access controls.
Prompts and responses are available in the Compliance API. For technical details, please see the Compliance API reference.
Privacy, security, and data handling
ChatGPT for Excel runs in Microsoft Excel. ChatGPT for Google Sheets runs in Google Sheets. Your use of those products is governed by your agreements with Microsoft or Google, respectively.
As part of Microsoft's Add In Marketplace Terms of Service, Microsoft may have the ability to read the content of your Excel workbook, attachments, and prompts.
What gets processed: To respond, ChatGPT processes your prompt, attachments, and relevant spreadsheet context so it can update your workbook and send you an analysis. Your data is stored locally in the product, and you can delete or download your data directly in the Settings. Some of your data logs may be stored with OpenAI for 30 days for safety and integrity purposes.
FAQ
Is this available worldwide?
ChatGPT for Excel and Google Sheets is available globally to Business, Enterprise, Edu, and K-12 users, and to ChatGPT Free, Go, Pro, and Plus users.
Can it connect to my other apps or internal systems?
Yes. Where apps are supported, availability depends on your ChatGPT plan, admin settings, user permissions, and data-source entitlements. If an app is not available, check with your workspace admin.
Does it involve Microsoft or Google?
Yes. ChatGPT for Excel runs in Microsoft Excel, and ChatGPT for Google Sheets runs in Google Sheets. Your use of those products is governed by your agreements with Microsoft or Google, respectively.
What are Skills in ChatGPT for Excel and Google Sheets?
Skills are reusable playbooks for spreadsheet work. They can encode workflows, standards, formatting rules, and output structures so users do not have to rebuild the same prompt each time.
What Skills are included by default?
ChatGPT for Excel and Google Sheets include default Skills for financial modeling and corporate finance formatting. More Skills may be added over time.
How do I use a Skill?
Open ChatGPT in Excel and Google Sheets, click + to browse Skills, then select a Skill or invoke it with @ in your prompt.
What are apps in ChatGPT for Excel and Google Sheets?
Apps let ChatGPT for Excel and Google Sheets use approved files, systems, and data sources from your ChatGPT account so it can produce more contextual spreadsheet outputs.
Are all ChatGPT apps available in ChatGPT for Excel and Google Sheets?
Apps from a user's ChatGPT account can carry over to ChatGPT for Excel and Google Sheets, subject to admin controls, user permissions, and data-source entitlements.
For MCP apps, tools intended for use in ChatGPT for Excel and Google Sheets should be accurately annotated as read-only and non-destructive. Tools without explicit annotations may be handled conservatively and may not appear in these surfaces.
Can admins control app access?
Yes. Admins can enable the apps feature and control access to individual apps.
Does ChatGPT for Excel support EU Data Residency, EU Inference Residency, and Enterprise Key Management (EKM)?
Yes. The ChatGPT for Excel supports both Inference Residency and Enterprise Key Management (EKM).
For Data Residency and Inference Residency availability by region, please refer to our OpenAI Data Residency and Inference Residency documentation.