ChatGPT Is Now Inside Excel and Google Sheets

Why ChatGPT Inside Excel matters now

The problem with using ChatGPT to help build spreadsheets was always the same: you have to leave the spreadsheet to get the help. You describe what you need in ChatGPT, copy the formula or structure it gives you, flip back to Excel, paste it in, discover it needs adjustments, and repeat the cycle 3 or 4 times before the model's output and your actual sheet are aligned.

As of May 5, 2026, that cycle is over. OpenAI launched a native ChatGPT sidebar that runs directly inside Microsoft Excel and Google Sheets. You describe what you need in plain English. The sidebar reads your current sheet, writes formulas in context, creates new tabs as needed, applies formatting, and explains every choice. You never leave the spreadsheet.

This is the first time AI assistance and the actual work environment have been in the same place for spreadsheet users. For executives who use Excel or Sheets to manage revenue tracking, budgeting, scenario planning, or data analysis, the shift in workflow efficiency is immediate.

How to Install the Sidebar

In Google Sheets: Open any Google Sheet. Click Extensions in the top menu, then Add-ons, then Get add-ons. Search for "ChatGPT for Sheets" in the Google Workspace Marketplace. Click Install. The sidebar appears in Extensions after installation.

In Microsoft Excel: Open Excel. Click Insert in the top ribbon, then Add-ins, then Get Add-ins. Search for "ChatGPT" in the Microsoft AppSource marketplace. Click Add. The sidebar appears in the Insert menu after installation.

Both installations take under 3 minutes. You need a ChatGPT account to authenticate. Free accounts have limited sidebar uses per day; Plus and Pro accounts have higher limits. Pro accounts unlock priority access during peak hours.

What the Sidebar Actually Does

The sidebar reads the current state of your spreadsheet in real time. When you describe a task, it has full context of your columns, your existing data structure, and your formula patterns. It is not guessing at what you mean -- it is working from what is actually on your screen.

Core capabilities that are live as of launch:

Formula building. Describe the calculation you need in plain English. "Add a column that calculates the percentage change in revenue from the same month last year." The sidebar writes the exact formula for your column structure, with an explanation of each element. You click Accept and it appears in the cell.

Multi-tab scenario building. Describe the scenario structure you need. "Create a new tab that models 3 pricing scenarios based on the revenue figures in tab 1." The sidebar creates the tab, builds the references, and sets up the scenario logic.

Data cleaning. Describe the cleaning rule. "Remove all rows where the Status column is blank, and flag rows where the Amount column is more than 2 standard deviations from the mean." The sidebar writes the logic, shows you a preview, and applies it on confirmation.

Conditional formatting. Describe the rule. "Apply red-green conditional formatting to the Variance column: red for anything more than 5% below target, green for anything at or above." The sidebar sets the formatting rules without you touching the Format menu.

What the sidebar does not do: it does not connect to external data sources, it does not run Python or R scripts, and it does not replace PivotTables for complex aggregation. Think of it as a formula-and-structure collaborator, not a full BI tool.

The 3 Use Cases With the Highest Return for Executives

Use Case 1: Building a weekly revenue tracker from scratch

This is the most common starting point for executives who have been meaning to set up structured tracking but have not had the time to build the formulas from scratch.

"Build me a weekly revenue tracker with a summary tab that shows total revenue, week-over-week change, and a 4-week rolling average. Add a data-entry tab where I input each week's revenue by product line. Use red-green conditional formatting on the week-over-week change column based on a 5% threshold."

The sidebar builds the full structure: the summary tab with the formulas referenced from the data tab, the conditional formatting, and a brief explanation of how to use each section.

Ready to master AI workflows?