ChatGPT directly in Excel spells the end of writing spreadsheet formulas by hand

ChatGPT directly in Excel spells the end of writing spreadsheet formulas by hand

Ondřej Barták
Ondřej Barták
Entrepreneur and Programmer
12. 3. 2026
2 minutes reading · 3 views
ChatGPT directly in Excel spells the end of writing spreadsheet formulas by hand

    Who among us hasn't experienced that feeling when you're sitting over an Excel spreadsheet, staring at a tangle of formulas and asking yourself: "Why isn't this working again?" OpenAI has decided to cut this everyday struggle short. The company has launched a beta version of ChatGPT for Excel, and things are starting to change quite significantly.

    This isn't just a simple chatbot stuck to the side of the screen. It's an add-in that integrates directly into your workbook, understands formulas, links between worksheets, and the logic of the entire model. And it is powered by the new GPT-5.4 model, which OpenAI has specifically fine-tuned for financial and analytical tasks.

    How do you add ChatGPT to Excel?

    Installation is easy. In Excel, open the Extensions → Add-ins menu, search for ChatGPT, and sign in with your OpenAI account. From then on, you'll have a new button on the ribbon, and a chat panel will open next to the spreadsheet.

    What next? Simply type what you need. For example: "Create a discounted cash flow model for me" or "Why do I have an error in cell B145?" ChatGPT will process it, create or modify a live Excel model directly in your workbook, while preserving your existing formulas and formatting. It asks for permission before every change, so nothing disappears without your knowledge.

    This is important. ChatGPT links its answers to the specific cells it references. You can see exactly what it changed and why. If you don't like the result, you can undo the changes with a single click.

    GPT-5.4: A Model That Understands Finance

    The performance is powered by the new GPT-5.4 Thinking model. OpenAI tested it on its own internal investment banking benchmark, which simulates real-world workflows such as building a three-statement financial model with proper formatting and citations. The results are impressive: while the original GPT-5 achieved a score of 43.7%, GPT-5.4 Thinking jumped to 87.3%. That's a leap analysts will genuinely notice in practice.

    The model can handle financial modeling, scenario analysis, data extraction, and lengthy research reports. Tasks that previously took an analyst an entire day now take a fraction of that time.

    Availability

    The beta version is available to users on Plus, Pro, Business, Enterprise, and Edu plans. Support for Google Sheets is coming soon.

    OpenAI's honesty is refreshing: the company openly acknowledges the limitations. VBA macros, Power Query, pivot tables, and Office Scripts are not yet supported. With very large workbooks, not all data may fit into the model's context window. Some responses may take longer or require manual formatting adjustments.

    ChatGPT is also not a financial advisor. You should always review the results before relying on them or sharing them with others. That's a sensible reminder everyone should keep in mind.

    Analysts, accountants, strategists, and researchers spend enormous amounts of time writing formulas, fixing errors, and manually building models. ChatGPT for Excel moves all of this into the background, freeing up space for what truly adds value: judgment, decision-making, and data interpretation.

    Advertisement

    Content created with help from UpTier.

    SEO and GEO on autopilot. UpTier’s multi-agent systems write and optimize content for search engines and AI answers.

    Discover UpTier ↗

    Category:AI
    Did you enjoy this article?
    Discover more interesting posts on our blog
    Back to blog

    Related posts

    OpenAI gives Codex reusable cloud workspaces accessible from any deviceOpenAI gives Codex reusable cloud workspaces accessible from any device
    Codex gains reusable cloud development environments, alongside voice controls in its CLI, code reviews in the ChatGPT desktop app and cloud-based security tools.
    2 min read
    2. 10. 2026
    Amazon releases Strands Decider 2B for AI workflow decisionsAmazon releases Strands Decider 2B for AI workflow decisions
    Strands Decider 2B selects from predefined options and returns a confidence score. The fully open-source model is available now and small enough to run locally.
    2 min read
    1. 10. 2026
    OpenAI says it disrupted a campaign to extract hidden model reasoningOpenAI says it disrupted a campaign to extract hidden model reasoning
    OpenAI reported a coordinated effort to extract protected model reasoning and said it closed an extraction pathway. It attributed the main cluster of activity to individuals associated with Moonshot AI, the developer of Kimi.
    3 min read
    1. 10. 2026
    Přihlaste se k odběru našeho newsletteru
    Zůstaňte informováni o nejnovějších příspěvcích, exkluzivních nabídkách, a aktualizacích.
    CodedTrip

    Operated by CodedTrip LLC, USA.

    YouTube
    TikTok