Working with spreadsheets can often feel slow and complicated, especially when dealing with large datasets, formulas, and financial models. Now, OpenAI wants to simplify that process by bringing its AI assistant directly into spreadsheets.
The company has announced ChatGPT for Excel, a new add-in currently rolling out in beta. It allows users to interact with their spreadsheets in natural language rather than manually writing formulas or navigating complex models.
The feature is initially available to ChatGPT Business, Enterprise, Edu, Teachers, Pro, and users in the United States, Canada, and Australia. Support for Google Sheets is also on the way, expanding the feature beyond Microsoft Excel in the near future.
ChatGPT is now in Excel and is soon to be in Google Docs
The new add-in embeds ChatGPT directly into Excel workbooks. This means users can ask the AI to build financial models, analyse numbers, run projections, or explain formulas without leaving the spreadsheet.
The feature is powered by GPT‑5.4, OpenAI’s latest AI model designed to handle complex reasoning tasks. According to the company, the model has been optimised for financial workflows, including analysing spreadsheets, extracting data, and performing scenario analysis.
Alongside the Excel integration, OpenAI is also adding connections to trusted financial data sources. These include FactSet, Dow Jones (through Factiva), London Stock Exchange Group, Daloopa, and S&P Global.
The integration aims to help analysts, researchers, and finance professionals access reliable data while working inside ChatGPT or Excel. Instead of switching between multiple tools, users can gather insights and run calculations in one place.
For organisations using Enterprise or education workspaces, the Excel add-in is turned off by default. Administrators can enable access for selected users through role-based permissions.
How does it work
Once enabled, ChatGPT appears as an assistant within the Excel workbook. Users can describe tasks in plain English, and the AI will generate formulas, build models, or update existing spreadsheets.
For example, someone analysing sales data could ask ChatGPT to create a revenue forecast, identify trends, or summarise key insights from thousands of rows of data.
The assistant can also help users understand spreadsheets created by others. It can analyse how different sheets are connected, explain why results changed, get data, and highlight errors in formulas.
Another feature is transparency. ChatGPT explains what it is doing as it works and links its answers to the specific cells it is using. This allows users to check formulas, verify calculations, and understand how results were produced.
Before making any edits to the spreadsheet, the assistant asks for permission. This gives users the option to review the suggested changes and undo them if needed.
Limitations
Since ChatGPT for Excel is currently in beta, OpenAI says some limitations remain.
Certain responses may take longer than expected while the company improves performance. In some cases, generated spreadsheets or formulas may require minor adjustments to match specific formatting preferences.
The AI can also create and explain formulas, but more complicated spreadsheet structures may still need manual refinement by users.
OpenAI says it plans to improve the tool quickly based on feedback from early users as it prepares for a broader rollout.
