ChatGPT for Excel is no longer a copy-paste hack. As of May 5, 2026, it is a generally available add-in in the Microsoft Marketplace, powered by GPT-5.5. It lives as a sidebar inside your workbook, can build formulas, update models, explain logic, and pull web data without leaving the spreadsheet.
The same model family that scores 88.5% on internal investment banking modeling tasks and 87.3% on spreadsheet modeling benchmarks (the GPT-5.4 score that launched the Excel add-in on March 5, 2026) is now available directly inside Excel, Google Sheets, and the standard ChatGPT interface.
This guide provides 40 prompts you can use across three workflows: the ChatGPT for Excel add-in sidebar, direct file upload to ChatGPT, and plain-language formula requests. Every prompt is categorized by task type and includes the exact input you need to provide for best results.
Key Takeaways
- ChatGPT for Excel is a native add-in. Install from the Microsoft Marketplace, sign in with your ChatGPT account, and use it from a sidebar. Available to Free, Go, Plus, Pro, Business, Enterprise, Edu, and K-12 users.
- ChatGPT for Google Sheets is also live. Available in beta since April 22, 2026, from the Google Workspace Marketplace.
- Microsoft Copilot in Excel is a separate product. It requires a Microsoft 365 Copilot subscription and focuses on formula generation, insights, and data cleanup within the Excel ribbon. ChatGPT for Excel is a third-party add-in from OpenAI.
- ChatGPT can analyze uploaded files directly. Upload .xlsx, .csv, or .pdf files to the ChatGPT interface on Plus, Pro, Business, or Enterprise plans for Python-backed analysis, charts, and summaries.
- GPT-5.5 Thinking is available on the $20/month Plus plan. You do not need Pro ($200/month) to access advanced reasoning for Excel work.
- Verify outputs. ChatGPT for Excel does not share history with your main ChatGPT account and cannot access ChatGPT memory. Review formulas, citations, and changed cells before relying on them.
Comparison at a Glance
| Feature | ChatGPT for Excel Add-in | ChatGPT Direct Upload | Microsoft Copilot in Excel |
|---|---|---|---|
| Availability | All plans (Free/Go limited) | Plus, Pro, Business, Enterprise | Microsoft 365 Copilot subscription |
| Interface | Sidebar inside workbook | Chat interface, file upload | Ribbon button, chat pane |
| Model (May 2026) | GPT-5.5 | GPT-5.5 Thinking | Microsoft proprietary |
| Formula Generation | Yes builds and explains formulas in cells | Yes provides formulas as text | Yes generates formula columns and rows |
| Multi-tab Reasoning | Yes understands cross-sheet links | Yes via file upload analysis | Limited |
| Web Search | Yes from within the sidebar | Yes manual activation | Yes |
| Python Analysis | Limited add-in is formula/editing-focused | Yes full Jupyter environment | No |
| Interactive Charts | No formula-based | Yes bar, line, pie, scatter | Yes via insights |
| VBA/Macro Support | Not fully supported (official limitation) | Yes generates VBA code as text | No |
| Memory Between Sessions | No separate chat history | Yes within the conversation | No |
| Skills/Playbooks | Yes financial modeling, corporate finance defaults | Via GPT-5.5 instructions | No |
| Pricing (entry) | Free (limited), $20/mo Plus | $20/mo Plus | Included in M365 Copilot ($30/user/mo) |
“Instead of building spreadsheet models or running scenario analysis manually, teams can describe what they need in plain language, and ChatGPT will create or update live Excel models directly in the workbook.” OpenAI, March 2026
How to Install ChatGPT for Excel
- Open Microsoft Excel (desktop or web).
- Go to Home > Add-ins.
- Search for ChatGPT in the Microsoft Marketplace.
- Add it, then open ChatGPT from the ribbon.
- Sign in with your ChatGPT account that has a supported plan.
If your organization blocks the Microsoft Store, a Microsoft 365 admin can deploy it using the manifest XML file through Integrated Apps > Deploy Add-in > Upload custom apps.
40 ChatGPT Prompts for Excel Data Analysis
Data Cleaning (Prompts 1–8)
1. “Clean up this workbook for executive review. Standardize labels and formatting, remove duplicates, fix broken formulas where possible, and summarize exactly what you changed.”
2. “Remove leading and trailing spaces from all cells in column A and return the cleaned values in column B.”
3. “Extract the first name from a full name in column B where names may include middle names. Handle edge cases where only one name exists.”
4. “Standardize phone numbers in column C to (XXX) XXX-XXXX. Numbers may include dots, hyphens, country codes, or raw 10-digit strings.”
5. “Convert text in column D to proper case. Preserve known acronyms like USA or IBM.”
6. “Extract the domain name from email addresses in column E. Strip the @ and return everything after it.”
7. “Flag duplicate rows based on columns A, B, and C combined. Add a TRUE/FALSE ‘Duplicate’ column.”
8. “Split addresses in column F into separate columns for Street, City, State, and ZIP. Handle inconsistent delimiters.”
Lookup and Reference (Prompts 9–16)
9. “Write an XLOOKUP to find the price in column D of Sheet2 based on the product ID in column A. Return ‘Not Found’ if there is no match.”
10. “Create an INDEX-MATCH that performs a two-way lookup: match the region in row 1 and the product in column A to return the intersection value.”
11. “Build a VLOOKUP that searches column B of Products!A:D and returns column 4 for the value in A2. Wrap in IFERROR to show ‘N/A’ on missing matches.”
12. “Use XLOOKUP with search mode -1 to find the most recent date entry in a table sorted ascending.”
13. “Create an INDEX with dual MATCH to return the value where row and column headers both match specified criteria.”
14. “Use FILTER to return all rows from Sales!A2:F500 where region in column B matches A1 AND amount in column E exceeds 1,000.”
15. “Build a lookup using INDIRECT to reference a sheet name from cell A1, then return the value from that sheet’s B column by matching the ID.”
16. “Use CHOOSECOLS to extract only columns 1, 3, and 5 from a FILTER output.”
Conditional Logic (Prompts 17–22)
17. “Write an IFS formula categorizing values in column F: ‘High’ (>1,000), ‘Medium’ (500–1,000), ‘Low’ (<500).”
18. “Build a nested IF: return ‘Over Budget’ if column D exceeds E, ‘On Budget’ if equal, ‘Under Budget’ if less.”
19. “Use COUNTIF to flag duplicates in column A. Return ‘Duplicate’ for any value appearing more than once.”
20. “Return the value from column B only if column A equals ‘Approved’ AND column C is greater than today’s date. Otherwise blank.”
21. “Build a SWITCH formula mapping department codes (1=Sales, 2=Marketing, 3=Engineering, 4=Finance) to full names.”
22. “Create conditional formatting that highlights entire rows red when column C is ‘Overdue’ and column D is more than 30 days past.”
Aggregation and Summarization (Prompts 23–30)
23. “Use SUMIFS to sum column E where column A=‘North’, B=‘Q2’, and C matches the product in F1.”
24. “Use AVERAGEIF to calculate the mean of column D excluding zero and blank cells.”
25. “Count distinct customer IDs in column A using UNIQUE and COUNTA.”
26. “Use MAXIFS to find the highest value in column F where category A equals ‘Electronics’ and month B equals ‘January’.”
27. “Compute a weighted average with SUMPRODUCT: multiply column C by weights in D, divide by the sum of D.”
28. “Use GROUPBY to aggregate sales by region (column B): SUM of sales (E), AVERAGE of margin (F), sorted descending.”
29. “Use SUBTOTAL with function number 9 to sum filtered rows in column G while ignoring hidden rows.”
30. “Use LET to define intermediate calculations: total revenue, total cost, then return profit margin as a percentage.”
Date and Time (Prompts 31–34)
31. “Calculate business days between dates in columns A and B using NETWORKDAYS, excluding weekends and the holiday list in Holidays!A2:A15.”
32. “Use TEXT to extract the full month name from a date in column C.”
33. “Use EOMONTH to return the last day of each month for dates in column D. Add a column showing days remaining until month-end.”
34. “Determine if a date in column E falls within the current fiscal quarter (Q1 starts July 1). Return ‘Current Quarter’ or ‘Past Quarter’.”
Text Manipulation (Prompts 35–37)
35. “Concatenate first name (column A) and last name (column B) with a space. If either is blank, return only the non-blank value.”
36. “Extract text between the first and second hyphen in product codes in column C. If only one hyphen exists, return everything after it.”
37. “Count words in each cell of column E. Handle leading/trailing spaces and multiple spaces between words.”
Statistical Analysis and Error Handling (Prompts 38–40)
38. “Calculate sample standard deviation with STDEV.S on column A. Flag values more than 2 standard deviations from the mean.”
39. “Calculate CAGR between starting value (column B), ending value (column C), and number of years (column D).”
40. “Wrap a VLOOKUP in IFERROR: for N/A, return ‘ID not found in lookup table.’ For VALUE errors, return ‘Check that the lookup value is the correct data type.’”
The Three ChatGPT Excel Workflows
Text-to-Formula. Open any ChatGPT interface, describe your data and desired output, and paste the returned formula into Excel. Fastest for one-off formulas. Works on all plans.
File Upload Analysis. Upload .xlsx or .csv into a ChatGPT conversation. ChatGPT uses a Python Jupyter environment to return tables, charts, and statistical summaries. Supports multi-tab workbooks and interactive bar/line/pie/scatter charts. Cannot access external APIs. Available on Plus, Pro, Business, Enterprise.
ChatGPT for Excel Add-in. A sidebar in the Excel ribbon. Reads your workbook structure, inserts formulas into cells, updates assumptions, traces formula chains, and searches the web. Does not sync with your main ChatGPT history or memory. VBA and macros are not fully supported as of May 2026.
| Task | Best Workflow |
|---|---|
| Quick single formula | Text-to-Formula |
| Analyze 50 MB CSV with charts | File Upload |
| Build multi-tab financial model | ChatGPT for Excel Add-in |
| Trace formula errors across sheets | ChatGPT for Excel Add-in |
| Run statistical tests (t-test, regression) | File Upload (Python) |
| Generate VBA macro code | Text-to-Formula |
| Update assumptions, see downstream effects | ChatGPT for Excel Add-in |
| Create KPI dashboard with formatting | ChatGPT for Excel Add-in |
Formula Verification Workflow
Before applying an AI-generated formula to real data:
- Build a small sample table with known answers and test the formula against it.
- Test edge cases: blank cells, zero values, text in numeric fields, dates, and error values.
- Confirm that absolute references ($A$1) and relative references (A1) are correct for your intended copy direction.
- Check whether your Excel version supports the functions used. XLOOKUP, FILTER, UNIQUE, SORT, LET, and LAMBDA require Excel 2021 or Microsoft 365.
- Ask ChatGPT to explain the formula line by line in plain English. If the explanation does not match your intent, refine the prompt.
- Compare the formula output against a manual calculation for at least three rows.
For finance, payroll, compliance, or executive reporting, duplicate the file before making changes so you can revert. ChatGPT for Excel asks for permission before making edits, but reviewing each change before approving is the safest practice.
FAQ
Does ChatGPT for Excel work with all Excel versions? The add-in works with Excel for Microsoft 365 (desktop and web). XLOOKUP, FILTER, UNIQUE, and dynamic arrays require Excel 2021 or later. Specify your Excel version in your prompt.
Is ChatGPT for Excel free? Free and Go ($8/month) plans include limited access. Plus ($20/month) has full access subject to agentic usage limits. Pro ($200/month) has expanded access. Business and Enterprise have a free preview through June 2, 2026.
How does ChatGPT for Excel compare to Microsoft Copilot in Excel? Copilot in Excel is a Microsoft-built feature requiring a Microsoft 365 Copilot subscription. It lives in the ribbon and generates formulas, charts, and insights. ChatGPT for Excel is an OpenAI sidebar add-in using GPT-5.5 with web search. They can coexist in the same workbook.
Can ChatGPT generate VBA macros? Yes in the standard ChatGPT interface. The add-in does not fully support VBA or macros as of May 2026. Request VBA in a normal chat and paste into Excel’s VBA editor.
Does the add-in share data with my chat history? No. Spreadsheet chats are separate from main ChatGPT history and have no access to memory. Some data logs may be stored with OpenAI for 30 days.
What file types can ChatGPT analyze? .xls, .xlsx, .csv, .pdf, .json, .xml, .yaml, .txt, and .md in the direct upload workflow. Scanned PDFs may not extract exact values. Connected apps (Google Drive, OneDrive, SharePoint) are supported where enabled by your workspace admin.
Sources
- OpenAI: Introducing ChatGPT for Excel (March 5, 2026, updated May 5, 2026)
- OpenAI Help Center: ChatGPT for Excel and Google Sheets
- OpenAI Help Center: Data analysis with ChatGPT
- OpenAI Academy: Analyzing data with ChatGPT (April 10, 2026)
- OpenAI: Introducing GPT-5.5 (April 23, 2026)
- OpenAI: Introducing GPT-5.4 (March 5, 2026)
- ChatGPT Pricing Page (May 2026)
- Microsoft Support: Get started with Copilot in Excel
- Microsoft Support: Excel functions by category