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 · 6 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 cracks down on child abuse. ChatGPT will block accounts for a full dayOpenAI cracks down on child abuse. ChatGPT will block accounts for a full day
    OpenAI is strengthening child protection: a new system can detect previously unknown AI-generated images, and ChatGPT will block accounts for 24 hours if users try to obtain them.
    4 min read
    18. 11. 2026
    Google makes Tasks free for Gemini 4 Hydrogen usersGoogle makes Tasks free for Gemini 4 Hydrogen users
    Tasks is becoming available for free to hundreds of millions of Gemini 4 Hydrogen users. Google says it can call businesses, book appointments and complete purchases on their behalf.
    1 min read
    18. 11. 2026
    OpenAI introduces GPT-6.2 Astra and Sol for professional and everyday workOpenAI introduces GPT-6.2 Astra and Sol for professional and everyday work
    OpenAI has introduced two models: Astra for complex professional tasks and Sol for everyday work. Both are available in ChatGPT Work, Codex and through the API.
    3 min read
    17. 11. 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