How to Use ChatGPT for Excel and Google Sheets in 2026

In 2026, spreadsheets stopped being a place where you fight with formulas alone. ChatGPT now lives right inside Excel and Google Sheets, working from a sidebar next to your data. You describe what you want in plain English, and it builds formulas, cleans messy data, explains errors, and even drafts charts. This guide walks you through exactly how to use it, with copy-and-paste prompts you can try today.

What Changed in 2026

OpenAI rolled ChatGPT into Excel in beta on March 5, 2026, followed by Google Sheets on April 22. As of May 5, 2026, both are generally available across Free, Go, Plus, Pro, Business, Enterprise, and education plans, now powered by GPT-5.5. Instead of copying data back and forth into a chat window, the assistant reads your workbook directly, links its answers to the exact cells it references, preserves your existing formulas and formatting, and asks permission before making changes. You can revert any edit, so experimenting is low-risk.

One current limitation worth knowing: as of mid-2026 the built-in assistant does not run VBA macros or Visual Basic automation. For that, you still ask ChatGPT to write the macro code and paste it in yourself.

Getting Started

Open the sidebar from the add-ins or extensions menu in your spreadsheet, sign in, and point it at the sheet you want help with. The golden rule is simple: describe your layout before you ask for anything. Tell it your sheet names, what each column holds, and which cells to lock. Vague prompts get vague results; specific prompts get formulas that actually work.

Writing Formulas Without the Headache

Formulas are where most people lose time. Describe the result you want in words and let ChatGPT translate it into a working formula, then ask it to explain the logic so you learn along the way.

Try prompts like these:

• “Write a SUMIFS formula that totals revenue in column E where region in column B is West, category in column C is Software, and the date in column A falls between January 1 and March 31, 2026.”
• “My VLOOKUP keeps returning #N/A. Here is the formula in cell F2. Explain why it is failing and give me a corrected version using XLOOKUP.”
• “Create a formula that flags any invoice in column D that is more than 30 days past its due date in column C.”

Because the assistant can trace how formulas connect across tabs, it is genuinely helpful for untangling a broken model and showing you why an output changed.

Cleaning Up Messy Data

Real spreadsheets are rarely tidy. Inconsistent dates, extra spaces, mixed capitalization, and duplicate rows all slow you down. ChatGPT can standardize a column in seconds.

• “Standardize the phone numbers in column G to the format (555) 123-4567 and list any rows that could not be converted.”
• “Split the full names in column A into first and last name columns, and capitalize each properly.”
• “Find and highlight duplicate email addresses in column B, keeping the first occurrence.”
• “Convert the text dates in column C, like ‘3/5/26’ and ‘March 5 2026’, into a single consistent date format.”

Analyzing Your Numbers

Once your data is clean, ask questions in plain English instead of building a dozen pivot tables. The assistant reasons across your whole workbook and can summarize what it finds.

• “Summarize sales by region for Q1 2026 and tell me which region grew fastest month over month.”
• “Build a formatted summary tab that shows total revenue, average order value, and top five products.”
• “Look at the monthly figures in this sheet and point out any months that are unusual outliers, with a one-line reason for each.”

Always sanity-check the results. AI can misread a column or make an assumption you did not intend, so verify anything you plan to act on.

Automating Repetitive Work

For tasks you repeat every week, have ChatGPT write the automation and then reuse it. Since the assistant will not run VBA itself, ask it to generate the code and drop it into the editor yourself.

• “Write a VBA macro that loops through every worksheet, bolds the header row, applies alternating row colors, auto-fits columns, freezes the top row, and adds thin borders to cells with data.”
• “For Google Sheets, write an Apps Script that emails me a summary of yesterday’s new entries in the Orders tab every morning at 8 AM.”
• “Update the Inputs tab only: new headcount is 42, new ARR is 3.2 million. Do not touch formatting, and list every cell you changed.”

Turning Data Into Charts

You can describe the story you want to tell and let the assistant recommend and build the right visual.

• “Create a line chart of monthly revenue for 2026 with a clean title and labeled axes.”
• “Suggest the best chart type to compare marketing spend against leads generated, and explain why.”
• “Build a simple dashboard tab with three summary cards and a bar chart of sales by product category.”

A Few Habits That Pay Off

• Give context first: sheet names, column meanings, and the exact range.
• Ask for an explanation alongside every formula so you build skill, not just output.
• Change one thing at a time and use the revert option freely.
• Double-check totals and outliers before sharing a report.

Keep Learning

ChatGPT inside Excel and Google Sheets is one of the biggest everyday-productivity shifts of 2026, and the people who get ahead are the ones who learn to prompt it well. If you want step-by-step, plain-English walkthroughs for tools like this, explore the practical guides at AI Learning Guides and turn AI into a skill you actually use every day.