ChatGPT for Excel: free add-in, uploads cap near 50 MB

In brief

ChatGPT for Excel is an OpenAI add-in that opens a ChatGPT sidebar inside your workbook, and it's available on every ChatGPT plan, Free included, as of November 2026. Free and Go get limited use. You can also upload an .xlsx or CSV to a normal chat, where spreadsheets top out near 50 MB.

What is ChatGPT for Excel, and who gets it?

ChatGPT for Excel is an add-in that puts ChatGPT in a sidebar next to your sheet, where it builds, updates and explains the workbook in place. OpenAI's help page says it's open to Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 users worldwide. It reached general availability on 5 May 2026.

A brushed silver OpenAI knot on a black plinth beside an upright paper card printed with a green spreadsheet grid, a stack of white sheets and a frosted glass calculator, in a dark charcoal studio.

People mix up two ways of using ChatGPT with a spreadsheet. One is the add-in. The other is uploading a file to an ordinary chat. They differ in what they can touch, as of 15 November 2026:

FeatureChatGPT for Excel add-inUpload to a ChatGPT chat
Where it runsA sidebar in Excel (desktop or web)The ChatGPT app or chatgpt.com
Edits your workbookYes, after it asks permissionNo, it returns a new file or a table
PlansFree, Go, Plus, Pro, Business, Enterprise, Edu, K-12Free and paid, with plan limits
Free planLimited usage3 file uploads a day
Spreadsheet sizeNot publishedAbout 50 MB for a CSV or spreadsheet
Memory and chat historySeparate from your main ChatGPT chatsSame as any ChatGPT chat
Runs Python on the dataNot statedYes, for data analysis
A spreadsheet upload tops out near 50 MB, about a tenth of a document's 512 MB
10 MB100 MB500 MBImageCSV or spreadsheetDocument or presentation

Usage is the part OpenAI leaves vague. Its help page says Free and Go "include limited usage access" and publishes no number. Plus and Pro share one agentic usage limit with Codex and Work, and they can buy credits when it runs out. OpenAI's credits article puts a typical Excel or Sheets task at 5 to 20 credits per message. A PowerPoint task runs 10 to 50.

The model is a surprise. The same article prices the Word, Excel and PowerPoint add-ins on four models: GPT-5.6 Luna, GPT-5.6 Terra, GPT-5.6 Sol and GPT-6 Astra. GPT-6 Sol, the model paid plans get in the main chat since 7 October 2026, isn't on that list. Plus and Pro can use all four add-in models, with GPT-5.6 Sol selected by default, and Free and Go use GPT-5.6 Luna in Word. So the sheet sidebar and the chat tab can run different models. OpenAI's launch post said the add-in was powered by GPT-5.5 when it went generally available, so the model has changed since.

How do you install ChatGPT for Excel?

You install it from Excel's own add-in store, and the whole job takes about a minute. These are the steps from OpenAI's help page:

  1. Open Microsoft Excel, on the desktop or the web.
  2. Go to Home, then Add-ins.
  3. Search for ChatGPT and add it.
  4. Open ChatGPT from the ribbon.
  5. Sign in with the ChatGPT account that has your plan.

Google Sheets has its own version. You add ChatGPT from the Google Workspace Marketplace, then open it from the Extensions menu. OpenAI calls the two products separate, though they handle similar jobs.

At work, the add-in may be blocked. If your organization can't reach the Microsoft Store for it, a Microsoft 365 admin can upload OpenAI's manifest file under Integrated apps in the admin center and assign it to people. On work plans, an admin may also have to enable the add-in in workspace settings.

A second route skips the sidebar. OpenAI says you can use Codex in the ChatGPT desktop app to work on an open Excel workbook through the same add-in. Mention @Microsoft Excel in Codex and it can inspect and update sheets, formulas, values, formatting and charts. That works for Microsoft Excel only, and the add-in and Codex must be signed in to the same account.

Can you upload an Excel file to ChatGPT?

Yes, on every plan. OpenAI's file upload page lists XLSX, XLS, CSV, TSV and OpenDocument spreadsheets (.ods) as supported. Here are the limits it states, read on 15 November 2026:

LimitWhat OpenAI states
CSV and spreadsheet sizeAbout 50 MB, depending on the size of each row
Documents and presentations512 MB per file
Token cap per text file2 million, and it does not apply to spreadsheets
Upload rate80 files every 3 hours; Free gets 3 a day
Peak hoursOpenAI may lower these limits

Once the file is in, ChatGPT can read it, count rows, summarize trends and draw charts. OpenAI's data analysis page says it often writes and runs Python in a Jupyter notebook to do that, and it tells you to review the code and the assumptions. Interactive charts cover bar, line, pie and scatter. Anything else comes back as an image.

Three limits bite in practice. The Python sandbox can't make web requests, so upload any outside data yourself. A file can upload fine and still be too big or messy for a full analysis, and OpenAI says the number and complexity of formulas can matter even under 50 MB. And ChatGPT may not read exact values from a scanned or image-based table, so send a real spreadsheet.

Prepare the sheet first. OpenAI recommends clear column names in the first row and one record per row, and it says to avoid several unrelated tables on one sheet and empty rows that split the data. For the five-step method, see how to analyze a spreadsheet with AI. ChatGPT's file upload limits by plan covers the other caps.

Can ChatGPT write Excel formulas?

Yes. Formula help is the job ChatGPT does best in a spreadsheet, in the add-in or in a plain chat. The add-in sees your real cells. A chat only sees what you paste, so describe the columns and give two sample rows. Copy any of these and fill the brackets:

JobPrompt to paste
Write a formula"Column B holds order dates and column D holds amounts. Write one formula that totals amounts for [month]. Explain each argument."
Fix an error"Cell [E12] shows #N/A. Explain the formula chain behind it and propose a fix. Don't change anything yet."
Replace a nested IF"Rewrite this nested IF as a lookup that a new teammate could read: [paste formula]."
Split messy text"Column A holds names like 'Smith, Ana'. Give me a formula that returns first name in B and last name in C."
Explain a formula"Explain this formula in plain words and name one input that would break it: [paste formula]."
Clean duplicates"List every duplicate customer in column A, ignoring case and trailing spaces. Show the count first."
Build a summary"Make a Summary tab with total and average per [category], using live formulas that point at the Data tab."
Check my sheet"Before editing, outline exactly which tabs and ranges you'd change, then wait for my go."

The last line borrows OpenAI's own advice. Its help page suggests asking for a plan first on big edits and gives "Before editing, outline exactly which tabs/ranges you'll modify." as the example. The page also says "Review formulas, calculations, citations, and changed cells before sharing or relying on them." Duplicate the file before you let any AI edit it.

Formulas are only half of it. To get a finished workbook back out of a chat, see AI that can create Excel files, and for dirty data start with cleaning up a spreadsheet with AI.

ChatGPT for Excel or Copilot in Excel: which one fits?

Copilot in Excel is the pick if your company already pays for Microsoft Copilot, and ChatGPT for Excel is the pick if you already have a ChatGPT plan. Both live in a sidebar and both edit your workbook. The facts below come from each vendor's own pages, read on 15 November 2026:

FeatureChatGPT for ExcelCopilot in ExcelClaude for Excel
NeedsAny ChatGPT plan, Free includedA Microsoft 365 Personal or Family plan with an AI credits plan, Microsoft 365 Premium, a commercial Copilot subscription, or a Copilot Chat-eligible work planClaude Pro, Max, Team or Enterprise
ModesAsks permission before changesEdit, plan and chatEdits in the workbook
ModelsOpenAI GPT modelsClaude and GPT models, switchable with a Copilot subscription or Microsoft 365 PremiumClaude models
WhereExcel desktop and webWindows, Mac, web, iPad, iPhone, Android; edit mode on Windows, Mac and webExcel on the web, Windows and Mac
Macros and VBAMay not be fully supportedNot stated on the pages readNot supported

Microsoft's Copilot in Excel FAQ adds two limits to know. Copilot editing only works when Calculation Options are set to Automatic, and edits you save are visible to anyone with access to the file. Anthropic's add-in page says Claude for Excel is generally available to Pro, Max, Team and Enterprise.

Our guide to Copilot versus ChatGPT compares the two chat apps outside Excel.

What can't ChatGPT for Excel do?

It can't carry your other ChatGPT context into the sheet, and it can't promise correct math. OpenAI lists its own limits, and these are the ones that matter:

  • Separate history. Spreadsheet chats stay apart from your main ChatGPT chats, and nothing syncs between them.
  • No memory. Spreadsheet chats can't read ChatGPT memory, so restate your rules each session.
  • Macros. VBA and macros "may not be fully supported."
  • Wrong answers. OpenAI says outputs "may be incomplete or incorrect" and tells you to duplicate the file first.
  • Work plans. An admin may have to enable the add-in in workspace settings. Business, Enterprise, Edu and K-12 had a free preview through 2 June 2026, and after that usage follows each plan's credits and usage terms.

Skills help with the memory gap. Skills are reusable playbooks for spreadsheet workflows, formats and review steps, and you reach them with the + button or an @ mention. Treat anything it tells you about money, tax or law as a draft, since OpenAI says ChatGPT isn't a financial, legal or tax advisor.

Where does Whizi fit for spreadsheet work?

Whizi has no Excel add-in, so it can't sit beside your open workbook the way ChatGPT for Excel does. If you're paying for ChatGPT only for the add-in, keep it. Whizi earns a place when your sheet jobs happen in a chat: you attach an .xlsx, ask a question, and ask for a downloadable Excel file back. Whizi's website turns that answer into a real .xlsx in your browser, and its Projects keep spreadsheet files pinned across chats.

The gap it fills is picking a model per job. Whizi Pro puts Claude, GPT and Gemini in one app, so you can ask a second model to check a formula the first one wrote, and its first week is $1.99. The free plan gives 10 messages a day on Whizi AI, Auto and Claude Haiku 5.5, with no card. It doesn't include the top GPT or Claude models. Whizi also reads old .xls files only after you re-save them as .xlsx.

Workflow checklist
  • Install the add-in from Home, then Add-ins in Excel, and sign in with your ChatGPT account
  • Duplicate the workbook before you let ChatGPT edit it
  • Name the tab or range, and say what to preserve
  • Ask for a plan first on any large edit
  • Upload the raw sheet with clear headers, one row per record
  • Keep spreadsheets under about 50 MB for a chat upload
  • Check the changed cells and one total by hand before you share the file
Common questions

Frequently asked questions

Is ChatGPT for Excel free?

Yes, with a cap. OpenAI's help page lists ChatGPT Free among the plans that get the add-in, and says Free and Go include limited usage. OpenAI publishes no number for that limit. Plus and Pro share an agentic usage limit and can buy credits, and a typical task uses 5 to 20 credits per message. ChatGPT free vs paid shows what else each plan gets.

Can ChatGPT analyze Excel files?

Yes. Upload an .xlsx, .xls, .csv, .tsv or .ods file to a chat and ChatGPT can summarize it, count rows, find outliers and draw charts, often by running Python. Spreadsheets are capped near 50 MB. The result can still be incomplete, so ask it to show its method and check one number by hand. The best AI for data analysis compares other tools.

Does ChatGPT for Excel work on Mac?

OpenAI's help page says to open Microsoft Excel on the desktop or the web and does not name Mac or Windows, so check the add-in's listing in Excel before you plan around it. By contrast, Microsoft names Windows, Mac, web, iPad, iPhone and Android for Copilot in Excel, and Anthropic says Claude for Excel needs Excel for Mac 16.46 or later.

Can ChatGPT for Excel run macros or VBA?

Not reliably. OpenAI's help page says VBA and macros "may not be fully supported." It builds and edits formulas, values, formatting and charts instead. If your workbook depends on macros, test a copy first and keep a backup of the original.

Is ChatGPT or Copilot better for Excel?

Use the one your account already includes. Copilot in Excel needs a Microsoft Copilot-eligible license and can switch between Claude and GPT models. ChatGPT for Excel needs only a ChatGPT login and works on the Free plan with limits. Copilot versus ChatGPT covers the wider comparison.