ChatGPT Is Now Inside Excel and Google Sheets

What You'll Learn

• What the new ChatGPT sidebar does inside Excel and Google Sheets -- and what it cannot do
• How to install it in under 3 minutes from each platform's marketplace
• The 3 use cases where the sidebar delivers the highest immediate return for executives
• How to prompt the sidebar correctly so it builds what you need on the first try
• Pricing breakdown and tier limits

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, 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. 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.

For executives who use Excel or Sheets to manage revenue tracking, budgeting, scenario planning, or data analysis, the shift in workflow efficiency is immediate.

Premium Content Below

Installation instructions, the 3 highest-value use cases with exact prompts, and 5 executive action steps are available to PromptHacker Premium subscribers.

How to Install the Sidebar

In Google Sheets: Open any Google Sheet. Click Extensions, 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.

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.

Formula building. Describe the calculation in plain English. The sidebar writes the exact formula for your column structure, with an explanation of each element. Click Accept and it appears in the cell.

Multi-tab scenario building. Describe the scenario structure you need. The sidebar creates the tab, builds the references, and sets up the scenario logic.

Data cleaning. Describe the cleaning rule. The sidebar writes the logic, shows you a preview, and applies it on confirmation.

Conditional formatting. Describe the rule. The sidebar sets the formatting rules without you touching the Format menu.

The 3 Use Cases With the Highest Return

Use Case 1: Building a weekly revenue tracker from scratch

Tell the sidebar: "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."

Setup time drops from 90 minutes of manual formula work to under 15 minutes of conversation.

Use Case 2: Running pricing and margin scenarios

Enter your current pricing and cost structure. Tell the sidebar: "Create a scenario analysis tab that models the margin impact of 3 price changes: plus 5%, plus 10%, and plus 15%. Show the resulting gross margin percentage for each scenario."

Adjust the cost inputs and the scenario tab updates automatically.

Use Case 3: Cleaning and structuring imported data

Paste raw exported data into a sheet. Tell the sidebar: "Clean this data: remove rows where Company Name is blank, standardize the Revenue column to whole numbers with no currency symbol, and create a Category column that assigns each row to Under 10K, 10K to 100K, or Over 100K based on Revenue." The sidebar writes the formulas and applies the rules -- no manual formula writing required.

Pricing and Tier Access

Free users: Daily usage limit (approximately 20 to 30 sidebar interactions per day). Resets at midnight.

Plus subscribers: Higher daily limits. No usage cap reported for normal business use.

Pro subscribers: Priority access and no reported caps. Recommended for heavy use across multiple spreadsheet projects.

5 Executive Action Steps

Step 1: Install the sidebar in your most-used spreadsheet tool today

Three minutes. The best way to evaluate whether this changes your workflow is to have it available during a real task.

Step 2: Identify the 2 spreadsheets you avoid because they are tedious to maintain

These are exactly the use cases where the sidebar delivers the highest return. Start there.

Step 3: Run one real formula-building conversation

Pick a formula or structure you have been meaning to add to an existing spreadsheet. Describe it in plain English. Evaluate the output against what you would have written manually.

Step 4: Build one scenario model you have been delaying

If there is a pricing change, a headcount scenario, or a budget reforecast sitting in "will do eventually" territory, use the sidebar to build it this week.

Step 5: Share the workflow with one team member

The efficiency gain compounds when it applies to the whole team's spreadsheet work, not just yours.