ExcelGPT
Last reviewed
May 11, 2026
Sources
10 citations
Review status
Source-backed
Revision
v4 · 2,187 words
Improve this article
Add missing citations, update stale details, or suggest a clearer explanation.
Suggest edit
CtrlK
Last reviewed
May 11, 2026
Sources
10 citations
Review status
Source-backed
Revision
v4 · 2,187 words
Add missing citations, update stale details, or suggest a clearer explanation.
| ExcelGPT | |
|---|---|
 | |
| Information | |
| Name | ExcelGPT |
| Platform | ChatGPT |
| Store | GPT Store |
| Model | GPT-4 |
| Category | Productivity |
| Description | Expert in Excel, Google Sheets, and VBA, fluent in multiple languages, friendly and professional. |
| Developer | Arthur Guerin |
| OpenAI URL | https://chat.openai.com/g/g-755Q51FWA-excelgpt |
| Chats | 25,000+ |
| Web Browsing | Yes |
| DALL·E Image Generation | Yes |
| Code Interpreter | Yes |
| Free | Yes |
| Available | Yes |
| Updated | 2024-01-24 |
ExcelGPT is a Custom GPT available on the GPT Store that helps users build formulas, write macros, and analyze data inside Microsoft Excel, Google Sheets, and Visual Basic for Applications (VBA). The GPT was created by Arthur Guerin and runs on ChatGPT using the GPT-4 family of models. It sits in the Productivity category of the OpenAI marketplace and is one of the most chatted-with spreadsheet helpers on the platform, with public listings reporting more than 25,000 conversations.
The assistant focuses on common spreadsheet pain points: writing a working VLOOKUP, converting an old VLOOKUP into XLOOKUP, debugging a circular reference, or translating a stuck workflow into a short VBA macro. It answers in French, Spanish, Portuguese, Arabic, Chinese, and English, and prefers to ask a clarifying question when a prompt is missing context such as the sheet layout or column types.
OpenAI announced the GPT Store on January 10, 2024, after several months of private beta. The store opened with categories for Writing, Productivity, Research and Analysis, Programming, Education, Lifestyle, and DALL·E, and was available to ChatGPT Plus, Team, and Enterprise subscribers. ExcelGPT was already live during the store's launch week and appears in archived listings with a last-updated date of January 23, 2024, placing it among the early productivity GPTs that benefited from the initial wave of marketplace traffic.
Arthur Guerin, the listed creator, also publishes several other GPTs on the same account, but ExcelGPT is the one that grew the largest audience. Third-party trackers such as gptstore.ai and gptsapp.io repost its public metadata, conversation starters, and chat counts.
ExcelGPT covers four main areas of spreadsheet work. The list below mirrors how the GPT itself describes its scope in its public instructions and conversation starters.
| Area | What it does |
|---|---|
| Formulas | Writes, explains, and fixes Excel and Google Sheets formulas including VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IFS, TEXTJOIN, LET, LAMBDA, and array formulas. |
| VBA and Apps Script | Drafts macros in VBA for Excel and Google Apps Script for Sheets, including loops, ranges, user forms, and event handlers. |
| Data organization | Recommends table layouts, named ranges, data validation rules, pivot table structures, and conditional formatting. |
| Troubleshooting | Reads pasted error messages, broken formulas, or sample data and suggests fixes. |
The GPT has web browsing, DALL-E image generation, and the Code Interpreter tool turned on. Code Interpreter is the most useful of the three for spreadsheet work because it lets users upload a .xlsx or .csv file and ask ExcelGPT to inspect the data, run a quick calculation, or test a formula on a real dataset. Web browsing is handy for looking up rarely used function syntax that may have changed between Excel versions, and image generation is rarely needed for spreadsheet help but stays available for things like quick chart mockups.
ExcelGPT's system prompt describes the GPT as an expert in Microsoft Excel, Google Sheets, and Visual Basic for Applications, drawing on material from both the Microsoft Excel Learning Center and the Google Sheets Learning Center. The instructions tell the model to provide help in multiple languages, to ask for clarification when queries are vague, to avoid financial or legal advice, and to keep a professional and approachable tone.
The public listing shows three short conversation starters that the chat surface displays the first time a user opens the GPT:
The wiki page records a slightly longer set used at an earlier point in the GPT's history, including questions about running totals, IF statements in VBA, merging cells in Google Sheets, and converting currency values. Conversation starters in the GPT Store can be edited by the creator, so different snapshots will show different sets.
Most of ExcelGPT's traffic is formula questions. The GPT tends to follow a predictable shape: it restates the formula, walks through the arguments, and ends with a short example pasted into a code block. A few common examples illustrate the style.
XLOOKUP. Asked to explain =XLOOKUP(A2, Sheet2!A:A, Sheet2!C:C, "Not found"), ExcelGPT describes XLOOKUP as a flexible replacement for VLOOKUP that searches a lookup array, returns the matching cell from a return array, and uses an optional fourth argument as the value to show when nothing is found. It usually notes that XLOOKUP works in both directions and does not need the lookup column to be on the left.
SUMIFS with multiple criteria. For a prompt like "sum all orders from California placed after January 1," the GPT produces =SUMIFS(Sales, Region, "CA", OrderDate, ">="&DATE(2026,1,1)) and explains that SUMIFS adds values from the sum range only for rows where every criteria pair is satisfied.
INDEX/MATCH. When users ask why their VLOOKUP returns #N/A, ExcelGPT often suggests rebuilding the lookup as =INDEX(ReturnColumn, MATCH(LookupValue, LookupColumn, 0)) and explains that this combination removes the left-to-right restriction of VLOOKUP.
LET and LAMBDA. For Microsoft 365 users the GPT covers newer functions. A LET example such as =LET(rate, 0.08, total, B2*(1+rate), total) is explained as a way to name intermediate values inside a single formula. LAMBDA examples build a custom function stored under a defined name in the Name Manager.
VBA macros. For "loop through every sheet and add a header row," the GPT returns a short Sub with For Each ws In ThisWorkbook.Worksheets, sets values in ws.Rows(1), and reminds the user to save the file as .xlsm.
The explanations are not always perfect. Like other large language models, ExcelGPT can suggest the wrong argument order or invent a function that does not exist in a given Excel version, so users with serious workbooks usually test the formula on a small sample before relying on it.
The assistant is best known for a handful of recurring tasks.
#REF!, #VALUE!, #NAME?, or #SPILL!.Most chats logged in third-party trackers are short, single-turn questions where the user pastes a formula and copies the answer back into their workbook. Longer threads tend to be VBA work, where the user iterates over a macro until it runs without errors.
ExcelGPT and Microsoft Copilot for Excel solve overlapping problems with different shapes.
| Feature | ExcelGPT | Copilot for Excel |
|---|---|---|
| Where it runs | Inside ChatGPT as a Custom GPT | Inside Excel as a side panel and inline ribbon |
| Workbook access | No direct access; user pastes data or uploads files to Code Interpreter | Direct access to tables, ranges, and PivotTables in the open workbook |
| Edits the workbook | No; outputs text the user copies back into Excel | Yes; can insert formulas, add columns, build PivotTables, apply formatting |
| Pricing | Free and paid ChatGPT users | Microsoft 365 Copilot add-on, licensed per user |
| VBA and Apps Script | Writes and debugs macros across both platforms | Limited; focuses on native Excel actions, does not author VBA |
| Cross-platform | Excel, Google Sheets, and VBA from a single chat | Excel only |
| Web access | Yes, through ChatGPT browsing | No live web access |
The two tools are complementary. Copilot is faster when the goal is to physically change cells on screen. ExcelGPT is faster when the goal is to understand a formula, debug a stuck macro, or move work between Excel and Google Sheets. The lack of a direct workbook connection is the biggest gap for ExcelGPT, but it is also why the GPT is free for users who do not have a Copilot license.
Public trackers list ExcelGPT among the more popular productivity GPTs in the OpenAI marketplace. Snapshots from gptsapp.io and yeschat.ai show chat counts that grew from around 8,000 conversations in early 2024 to roughly 25,000 later in the year, with an average rating of about 4 out of 5 across roughly 400 community reviews. The growth pattern matches the broader rise of the GPT Store during 2024, which OpenAI said held more than 3 million user-created GPTs by late 2024, of which around 159,000 were public and listed.
Reviews on third-party listing sites praise the speed of getting a working formula, the willingness to ask clarifying questions when a prompt is ambiguous, and the multilingual support that lets non-English speakers describe a problem in their own language. Common complaints focus on the limits of the GPT-4 base model: occasional fabricated function names, answers that mix Excel and Google Sheets syntax, and the fact that without Code Interpreter active the GPT cannot run a formula against the user's data. ExcelGPT is not the only spreadsheet GPT on the store, with competitors such as ExcelGPT v2, Excel Pro, and GPT Excel covering similar ground, but its edge appears to be name recognition from being early in the store.
ExcelGPT inherits the constraints of the base ChatGPT product. Outputs are generated text and need to be tested before being used in production workbooks. The GPT does not have access to the user's open Excel file unless they upload it through the Code Interpreter tool, and it does not write back into the file. Each chat is independent, so a long debugging session does not persist between conversations unless the user keeps notes.
The instructions tell the GPT to avoid financial and legal advice, so it will hedge or refuse on questions that mix spreadsheet help with regulated topics such as tax models or compliance reports. Sensitive data should not be pasted into the chat without first checking the relevant retention and training settings for the user's plan.
Version compatibility is another quiet issue. Functions like XLOOKUP, LET, LAMBDA, and the dynamic-array engine are only available in Microsoft 365 and Excel 2021 or later. Users running Excel 2016 or 2019 sometimes receive formulas they cannot use. The GPT does not always ask which version of Excel the user has, so it is worth saying so upfront when accuracy matters.
ExcelGPT belongs to a small group of single-purpose productivity GPTs that gained traction during the first year of the GPT Store. Other early productivity GPTs include writing assistants such as Consensus, research helpers like Scholar GPT, and code-focused GPTs such as Grimoire. Within the spreadsheet niche, ExcelGPT competes with narrower tools, for example pure formula generators or chart-building assistants. Its system prompt and conversation starters have stayed largely the same since 2024, which means newer Excel features such as Python in Excel and Copilot Agent Mode are only handled to the extent the underlying GPT-4 model knows about them.