ChatGPT Excel: The Add-in, File Uploads, Prompts and Limits

ChatGPT works with Excel in three ways. Install OpenAI’s ChatGPT for Excel add-in and it works inside your open workbook from a sidebar. Upload an .xlsx or .csv to a chat and it analyzes the data with Python and draws charts. Or describe what you want a cell to do and ask for the formula. Since May 5, 2026, OpenAI says the add-in is generally available on every ChatGPT plan, Free included.

Every fact about OpenAI’s products below comes from OpenAI’s own pages, read November 9, 2026. The examples are the jobs a founder runs most: a running costs sheet, revenue by month, and a messy CSV export.

All three routes share one gap. Each chat starts over, and nothing keeps the sheet current between sessions. For that, a Context Board Sheet is a spreadsheet on the web your agents fill in over time, with formulas, charts and Excel in and out. Context Board is ours, so weigh the bias.

Three ways to use ChatGPT with Excel

Each route puts the spreadsheet in a different place. That decides what ChatGPT can change and what it can only read.

Pick the add-in when the workbook already exists and you want changes made in it. Pick an upload when you want an answer about the data and don’t need the file changed. Ask for a formula when you only need one cell to work.

How to install the ChatGPT for Excel add-in

OpenAI calls it ChatGPT for Excel. The Microsoft Marketplace listing just says ChatGPT, since one add-in covers Excel, Word and PowerPoint. The steps, from OpenAI’s help article:

1. Open Excel. Desktop or web both work.
2. Find the add-in. Go to Home, then Add-ins, and search for ChatGPT.
3. Add it and open it. ChatGPT appears in the ribbon above your workbook.
4. Sign in. Use the ChatGPT account that has your plan.

Which plans: OpenAI’s help article lists Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12, worldwide. Free and Go include limited use. Plus and Pro include access “subject to your plan’s agentic usage limit”. Business, Enterprise, Edu and K-12 had a free preview through June 2, 2026, and use now follows each plan’s credits. Larger workbooks and multi-step edits use more of the limit, so a long modeling session costs more than a quick question.

At work: in Enterprise, Edu and Teacher workspaces, access starts off, per OpenAI’s announcement. An admin turns it on under Workspace settings, then Permissions and roles. If your company blocks the Microsoft store, a Microsoft 365 admin can upload OpenAI’s manifest file under Integrated apps, then Deploy Add-in.

On Google Sheets: OpenAI makes a separate ChatGPT for Google Sheets, installed from the Google Workspace Marketplace and opened from the Extensions menu. It handles the same kinds of work.

The history: OpenAI launched the Excel add-in in beta on March 5, 2026, on GPT-5.4. Google Sheets followed in beta on April 22, along with apps and Skills. On May 5, both became generally available on all plans, powered by GPT-5.5.

What ChatGPT for Excel can do

OpenAI’s help article and its ChatGPT for Excel and Google Sheets page list what the add-in does inside an open workbook.

• Build from a sentence: a formatted budget, tracker or model, with formulas, from a blank sheet or an existing one.
• Read across tabs: summaries across tabs, how formulas connect, and why an output changed.
• Find and fix errors: it traces a formula chain to the cell that breaks it and proposes a fix.
• Show its work: answers link to the cells it read or changed. It keeps formulas and formatting, asks permission before a change, and lets you revert edits.
• Focus on one sheet: type @ and pick a sheet to point the prompt at it. It can also search the web for figures to pull in.
• Attachments: up to 20 per message and 25 MB per file, from images and documents to other spreadsheets.
• Skills and apps: the + button opens Skills, reusable playbooks, with default ones for financial modeling and corporate finance formatting. Apps bring in data your ChatGPT account connects to, where your plan and admin allow.

With Codex: in the ChatGPT desktop app, Codex can work on an open Excel workbook through the add-in. Sign in to both with the same account, turn on Allow Codex control in the add-in’s ••• menu, and ask Codex to work with the open workbook. OpenAI says Codex can update sheets, formulas, values, formatting and charts this way, on Excel only.

Analyze an Excel file in a ChatGPT chat

No add-in needed. On OpenAI’s spreadsheets page, the steps are to click +, choose Add photos and files, and pick the spreadsheet. Then ask your question.

Per OpenAI’s data analysis article:

• Files: .xls, .xlsx and .csv, plus PDFs and text files like .json and .txt. With plugins on, you can attach files from Google Drive, OneDrive and SharePoint.
• How it works: for many tasks ChatGPT writes and runs Python in a notebook, and shows the data as tables you can scroll.
• Charts: static images by default. Bar, line, pie and scatter charts can switch to interactive.
• Limits: the Python environment can’t reach the web or call APIs, so upload the data it needs. A big file with many formulas may upload fine and still get a partial analysis. Ask about one sheet or range at a time if the answer looks thin.

Set the file up so ChatGPT reads it right. OpenAI’s advice is headers in the first row, one record per row and plain column names. Avoid several unrelated tables on one sheet, blank rows that split the data, and numbers inside pictures.

Need a file back? ChatGPT Work creates and edits spreadsheet files, and native Google Sheets once the Google app is connected. Name the sheets, columns, formulas and charts you need, and check the file before you share it.

Worked examples for a founder

Three jobs, each with the route that fits and a prompt to copy. The numbers are examples.

Monthly running costs

You pay for a dozen tools and want one sheet with the monthly and yearly cost of each. In the add-in, start from a blank workbook:

Build a Costs sheet with columns Tool, Category, Monthly and Yearly. Yearly is Monthly times 12 as a formula. Add a total row and a summary by category. Format money as dollars.

The result should look like this.

The formulas behind it are plain Excel, so you can check each one:

Yearly, in D2:          =C2*12
Total monthly:          =SUM(C2:C4)
Marketing per month:    =SUMIFS(C:C,B:B,"Marketing")

Revenue by month from a payments export

Your billing tool exports every payment as a CSV with a date and an amount. Upload it to a chat:

This is every payment since January. Give me revenue by month as a table, the month-over-month change in percent, and a line chart. Tell me which month had the biggest drop and why it might be.

ChatGPT groups the rows in Python and draws the chart. To do the same inside Excel, ask for a formula you can keep:

=SUMIFS(B:B,A:A,">="&DATE(2026,10,1),A:A,"<"&DATE(2026,11,1))

That sums column B, the amounts, for every date in column A that falls in October 2026. Change the two dates for each month. OpenAI lists Pivot and the Data Model as unsupported in the add-in, so ask for SUMIFS rather than a pivot table.

Cleaning a CSV export

A lead list or customer export comes out with stray spaces, mixed capitals, duplicate rows and dates in two formats. OpenAI’s own example prompt fits:

Clean up this sheet: standardize formatting, fix inconsistent labels, and remove duplicates.

Then add the rules for your file: which column is the unique key, which date format to keep, and what to do with blank emails. Ask it to list every row it removed. OpenAI warns the add-in can change or delete data when a request is unclear, so run this on a copy.

For more numbers worth tracking, our KPI dashboard examples give the formula behind each one.

ChatGPT Excel prompts that work

OpenAI’s help article gives two habits that make prompts work. Say what to keep, what to overwrite and where. And for big edits, ask for a plan first.

• “Update assumptions on the Inputs tab only. Don’t change formatting. Summarize changes.” From OpenAI, and a pattern worth copying for any edit.
• “Before editing, outline exactly which tabs and ranges you’ll modify.” Read the plan, then say go.
• “Why am I getting an error in cell B145? Explain the formula chain and propose a fix.” Swap in your own cell.
• “Summarize trends across these three tabs and call out anything unusual.” Good on a workbook you inherited.
• “Create a new scenario tab that compares base, upside, and downside cases.” For a pricing or hiring plan.
• “Explain what this formula does, step by step, and suggest a simpler way to write it.” From OpenAI’s spreadsheets page, and handy on a sheet someone else built.
• “Write a formula that calculates the percentage change in revenue month over month.” Works in any chat, no upload needed.

Name the columns and cells. “Fix the totals” leaves ChatGPT guessing, while “Fix the SUM in D20 so it covers D2:D19” doesn’t.

What ChatGPT can’t do in Excel

OpenAI is plain about the limits, on its spreadsheets page and in the help article.

• Unsupported features: Office Scripts, Power Query, Pivot and the Data Model, data validation, the named ranges manager, slicers, timelines, managing external connections, charts beyond the current set, and VBA macros.
• Size: very large workbooks may not fit in what the model can read at once, which gives partial results.
• No memory: add-in chats are separate from your ChatGPT history and don’t sync with it, and they can’t use ChatGPT’s memory. Each session starts from the open workbook.
• Mistakes: outputs may be incomplete or wrong, and complex formulas or edge cases may need fixing by hand. OpenAI says to duplicate important files first, and that ChatGPT is not a financial, legal or tax advisor.
• Your data: ChatGPT processes your prompt, attachments and the relevant parts of the workbook. Under Microsoft’s marketplace terms, Microsoft may be able to read your workbook, attachments and prompts. OpenAI may keep some logs for 30 days for safety.

Apps in the add-in: apps from your ChatGPT account can carry over, but OpenAI says MCP tools meant for the add-in should be marked read-only and non-destructive, and others may not show. So expect apps in the add-in to read connected data rather than change your other tools.

A spreadsheet your agents fill in over time

The add-in is good at one session on one workbook. The jobs above don’t end there. The costs sheet needs a new row each time you sign up for something, and the revenue table needs a new month each month. ChatGPT, Claude and Codex each forget the last session, and nothing ties their work to one sheet.

Context Board is a web app at board.contextbolt.com, a workspace you share with your AI agents. A Sheet board is tabs of cells and formulas, like the sheets you know, that your agents read and write over MCP.

• Formulas you know: the everyday Google Sheets functions, from SUM and IF to SUMIFS, XLOOKUP and FILTER, more than a hundred in all, with references across tabs. Change a number and every cell that reads it works itself out again.
• Your Excel files, every tab: import an .xlsx or CSV and each tab comes in with its formulas, number formats, bold and column widths.
• Agents that add rows: your agent reads a tab as a table and writes cells, rows, formulas, formats and sorts. It can add a tab, make a table, or chart a range.
• A name on every change: cells an agent writes glow once in its color, with its name. Board activity lists each change.
• Charts that follow the sheet: chart a range beside the cells, or put it on a slide, and it changes when the sheet does.
• Excel back out: download a tab as CSV, or the whole sheet as .xlsx.

A tab holds up to 10,000 rows and 104 columns, and a sheet up to 40 tabs. Getting started:

1. Make a Sheet board. Choose New board, then Sheet.
2. Bring your workbook. Choose Import a CSV or Excel file, on the left.
3. Connect your agent once. For Claude Code or Codex, link your computer with the one line from Connect. For Claude, ChatGPT or Cursor, add the board’s address in the app and click Allow.
4. Ask for the row. “On my Running costs sheet, add the analytics tool at $19 a month to the Costs tab.” The row lands with its yearly total, glows in the agent’s color, and the totals move.
5. Take it out when needed. Download the .xlsx for your accountant, or share a read-only link.

ChatGPT’s part depends on your plan. OpenAI’s article on custom MCP servers says full MCP, with write actions, is for Business and Enterprise or Edu, on ChatGPT’s website. On Business, an admin or owner adds the server. Pro can connect custom servers with read and fetch permissions only, so ChatGPT on Pro can read the sheet while Claude or Codex add the rows. Your agents run on the plans you already pay for.

Context Board is free for 3 days, then $12 a month for every kind of board, sheets, docs, slides and dashboards included. There are no AI credits to buy. If the sheet’s numbers belong on a dashboard, our guide to dashboard software for small business compares the options.

What it isn’t: a Sheet board isn’t Excel. It has no pivot tables, macros or Power Query, and it doesn’t stay linked to your Excel file after import. If you live in Excel all day, keep the add-in.

Which way to pick

• You have a workbook open and want it changed: the ChatGPT for Excel add-in. Be specific, and work on a copy.
• You want an answer or a chart from a file: upload it to a chat. Nothing in your file changes.
• You need one formula: ask in any chat and paste it in. Check it against two or three rows by hand.
• You use Claude too: Anthropic makes its own add-in, and our Claude in Excel guide covers its plans and fixes.
• The sheet should grow every week, with rows from more than one agent: a Context Board Sheet.

Start with the costs sheet. It is small, you know every number in it, so you can check what ChatGPT gets right. Then import it to a Sheet board and ask your agent for the next row when the next bill arrives.

Choosing between ChatGPT and Claude? Our Claude vs ChatGPT for Excel comparison maps both across six office apps.