Can ChatGPT make Excel sheets? Yes, three ways. It can build a downloadable .xlsx file inside a normal chat, it can work directly in your workbook through the official ChatGPT for Excel add-in, or it can write formulas you paste into a sheet you already have. The catch is that a file made in chat is a snapshot, so the real skill is knowing which route fits the job and how to check what comes back.
On this page
- Can ChatGPT make Excel sheets? The three ways, compared
- Way 1: ask for a downloadable Excel file in chat
- Way 2: the ChatGPT for Excel add-in
- Way 3: formulas and macros you paste in
- A prompt template that produces a usable sheet
- Worked example: a monthly budget tracker
- How to check a sheet ChatGPT made (the five-minute test)
- What ChatGPT for Excel cannot do yet
- FAQ
Can ChatGPT make Excel sheets? The three ways, compared
Each route gives you a different thing. Pick by what you need at the end: a file to send, a working model in your own workbook, or a fix to one cell.
| Route | What you get | Formulas live in the file? | Best for |
|---|---|---|---|
| In chat (file download) | A new .xlsx or .csv you download | Only if you ask for formulas; often values by default | Templates, trackers, one-off lists, cleaning a CSV |
| ChatGPT for Excel add-in | Edits made inside the workbook you have open | Yes, it writes into the cells | Models, multi-tab files, updating something that exists |
| Paste formulas or VBA | Text you copy into a cell or the VBA editor | Yes, once pasted | One hard formula, a macro, a quick fix |
Every method shares one limit: ChatGPT cannot see a file on your laptop unless you upload it or open the add-in. A table typed in the chat window is plain text, not a spreadsheet. Quadratic's write-up on whether ChatGPT can create spreadsheets makes the same point: a downloaded file is a snapshot, and the model has no connection to it after you open it.
Way 1: ask for a downloadable Excel file in chat
This is the route most people mean when they ask "can ChatGPT create Excel spreadsheets". You describe the sheet, ChatGPT writes and runs Python to build it, and you get a download link for a .xlsx file. OpenAI's own data analysis documentation explains the mechanism: for some tasks ChatGPT "writes and runs Python code in a stateful Jupyter notebook environment", and it accepts uploads of .xls, .xlsx and .csv files.
How to do it well:
- Say "create an Excel file I can download" rather than "make a table". A table in chat is text. A file is a file.
- List the columns in order and say what type each one is (date, currency, whole number, text).
- Say which cells should be formulas. If you do not, totals often come back as typed numbers that never update.
- Ask for a second tab with the assumptions, so you can change inputs later.
- Open it in Excel and run the five-minute test below before you trust it.
Two things the documentation is clear about. The Python environment "cannot make external web requests or API calls", so if you want live exchange rates or prices in the sheet, that is not going to happen in chat. And ChatGPT may pick a method or chart type you did not intend, so name the one you want.
Way 2: the ChatGPT for Excel add-in
The ChatGPT for Excel add-in is the biggest change since people first asked this question. It is a sidebar inside Excel (and a separate one for Google Sheets) that can build, update and explain workbooks, including multi-tab files with formulas. OpenAI's help page on ChatGPT for Excel and Google Sheets describes it as "a spreadsheet-native AI experience that lives in a sidebar inside your Excel and Google Sheets spreadsheets".
How to install the ChatGPT for Excel add-in
- In Excel, go to Home, then Add-ins.
- Search for ChatGPT and add it.
- Open it from the ribbon and sign in with your ChatGPT account.
- If your company blocks the Microsoft store, a Microsoft 365 admin can deploy the manifest file instead. Organizations using role-based access control may also need an admin to switch the add-in on in Workspace settings.
Is ChatGPT for Excel free?
The add-in is listed as available on Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 plans. Free and Go plans have limited usage, and Plus and Pro usage counts against the agentic usage limit. For Business, Enterprise, Edu and K-12, the help page describes a free preview through June 2, 2026, after which usage follows each plan's credits. Usage scales with the size of the spreadsheet and the complexity of the task, so a 40-tab model costs more of your allowance than a one-tab list. Check the help page for the current plan terms before you roll it out to a team.
What it is good at
OpenAI lists the typical uses as building trackers, budgets, plans and templates; cleaning up messy sheets (formatting, labels, duplicates, broken formulas); explaining unfamiliar workbooks; updating models when inputs change; and running scenarios and sensitivity tables. In practice the add-in beats the chat route whenever the sheet already exists, because it edits in place and the ChatGPT for Excel and Google Sheets product page says it asks permission before making changes so you can revert.
Three habits that make it behave:
- Say what to change and what to preserve. "Add a Q4 column, keep every formula in columns B to D as they are."
- Ask for a plan before a large edit. "Tell me the steps before you change anything."
- Use @ to mention a sheet, so the prompt only looks at that tab.
Way 3: formulas and macros you paste in
The oldest route still works for most people on most days. You describe the result you want in a cell, ChatGPT writes the formula, you paste it. It is fast for XLOOKUP, nested IF, SUMIFS, dynamic arrays and date math. It also works for VBA, with one warning: the help page says "VBA and macros may not be fully supported" inside the add-in, so for macros stay in a normal chat, paste the code into the VBA editor (Alt+F11), and test it on a copy.
Give ChatGPT what it cannot see. A formula request should include the sheet name, the exact ranges, what the headers are, and one row of sample data. "Sheet 'Orders', column C is order date, column F is amount, give me total amount for October" gets a correct SUMIFS the first time. "Sum the October orders" gets a guess.
If you want ChatGPT to remember your workbook conventions across chats, put them in your settings using the ChatGPT custom instructions template. One line like "I use Excel 365 on Windows, US date format, and I want formulas not VBA unless I ask" removes a lot of back and forth.
A prompt template that produces a usable sheet
Copy this, fill in the brackets, and paste it into a chat or the add-in sidebar.
Create an Excel file I can download called [file name].
Tab 1 "[name]": columns in this order:
- [Column A name] ([date / text / currency / whole number])
- [Column B name] (...)
- [Column C name] (...)
Rules:
- Row 1 is headers, bold, frozen.
- [Column] is a formula: [describe it, e.g. =C2*D2].
- A Total row at the bottom uses SUM formulas, not typed numbers.
- Currency columns formatted as [USD with 2 decimals].
- Add 8 rows of realistic sample data so I can see it working.
Tab 2 "Assumptions": every number used by a formula on Tab 1
lives here in a labelled cell, and Tab 1 references it.
Then tell me which cells contain formulas and which are typed values.The last line matters. It makes the model report where the hard-coded numbers are, which is where sheets usually break. For more fill-in prompts that hold up at work, see the AI prompt templates for work.
Worked example: a monthly budget tracker
This is an example with made-up numbers, built to show what the output should look like.
Prompt: "Create an Excel file I can download called Budget. Tab 1 'Budget': Category (text), Planned (currency), Actual (currency), Difference (formula =Planned minus Actual). Income row at the top of $4,200. Six expense rows. A Total Expenses row using SUM, and a Remaining row that is Income minus Total Expenses. Tab 2 'Assumptions' holds the income figure and Tab 1 references it."
What a correct result looks like:
| Category | Planned | Actual | Difference |
|---|---|---|---|
| Income | 4,200.00 | 4,200.00 | 0.00 |
| Rent | 1,450.00 | 1,450.00 | 0.00 |
| Groceries | 520.00 | 563.40 | -43.40 |
| Transport | 180.00 | 151.20 | 28.80 |
| Utilities | 210.00 | 198.75 | 11.25 |
| Subscriptions | 64.00 | 64.00 | 0.00 |
| Savings | 600.00 | 600.00 | 0.00 |
| Total expenses | 3,024.00 | 3,027.35 | -3.35 |
| Remaining | 1,176.00 | 1,172.65 | -3.35 |
Check the arithmetic by hand once. Planned expenses: 1,450 + 520 + 180 + 210 + 64 + 600 = 3,024. Remaining: 4,200 minus 3,024 = 1,176. Actual expenses: 1,450 + 563.40 + 151.20 + 198.75 + 64 + 600 = 3,027.35, so remaining is 1,172.65. If the Total row in the file is a typed 3,024 instead of =SUM(B3:B8), the sheet will be wrong the first time you change a number. That is the single most common fault in generated sheets, and it is invisible until you look.
How to check a sheet ChatGPT made (the five-minute test)
None of the guides that rank for this question tell you how to verify the file. OpenAI's own help page says outputs "can be incomplete or wrong" and tells you to duplicate important files before making changes. Here is the check that catches most problems.
- Show formulas. Press Ctrl+` (the key under Esc). Every total, subtotal and difference cell should turn into a formula. Any number that stays a number is hard-coded.
- Change one input. Edit a value on the Assumptions tab. If nothing on Tab 1 moves, the references are not wired.
- Re-add one column yourself. Select the column and read the sum in the status bar. Compare it with the Total row.
- Check the range edges. Click a SUM cell and look at the highlighted range. Off-by-one ranges (B2:B7 when the data runs to B8) are common.
- Look for text that looks like numbers. A green triangle in the cell corner, or numbers that align left, mean the value is text and will be skipped by SUM.
- Check dates. Sort the date column. If 03/04 sorts strangely, the file has mixed US and European date formats.
- Save a copy first. Before the add-in touches a real workbook, save a copy with the date in the name.
If the sheet is financial, add one more step: have the model explain every formula in plain words and read the explanation against the formula. The same discipline is covered in best AI for financial analysis: how to check the numbers.
What ChatGPT for Excel cannot do yet
The product page and help article list these limits for the add-in. Knowing them saves you from asking for something it will skip without telling you.
- Office Scripts, Power Query, Pivot tables and the Data Model, data validation, slicers and timelines are listed as unsupported.
- VBA and macros may not be fully supported.
- Very large workbooks may not fit in the context window, so you can get partial results.
- Spreadsheet chats are separate from your main ChatGPT history and do not have access to ChatGPT memory.
- It is not a financial, legal or tax adviser, and the page warns it can accidentally change or delete data if a request is unclear.
If your company runs Microsoft 365 and already pays for Copilot, the Excel decision is usually "which one is switched on for us" rather than "which is better". The Copilot prompt gallery covers the Excel prompts that work on that side. If you run a small business and want the short list of jobs worth handing over, start with ChatGPT for small business owners.
If you want ChatGPT set up for your whole job, Custom AI for Your Job builds the instructions, files and checks for the work you do every week, including the Excel reports.
FAQ: ChatGPT and Excel
Can ChatGPT make Excel sheets for free?
Yes, within limits. The ChatGPT for Excel add-in is listed as available on the Free plan with limited usage, and a normal chat on a free account can produce a downloadable .xlsx file for simple requests. Heavier work, such as rebuilding a large multi-tab model, uses more of your allowance and may need a paid plan. Check OpenAI's current plan terms before relying on it daily.
Does ChatGPT put real formulas in the file or just numbers?
It depends on what you ask for. In a chat-built file, totals often come back as typed values unless you say "use SUM formulas, not typed numbers". The ChatGPT for Excel add-in writes into cells in your open workbook and keeps existing formulas and formatting. Either way, press Ctrl+` in Excel to show formulas and confirm before you trust the sheet.
Can ChatGPT create Excel spreadsheets with macros?
It can write VBA code in a normal chat, and you paste it into the VBA editor with Alt+F11. OpenAI's help page says VBA and macros may not be fully supported inside the ChatGPT for Excel add-in, so treat the add-in as the wrong tool for macros. Test any macro on a copy of the workbook first, because it can change data without an undo.
Can ChatGPT read an Excel file I upload?
Yes. ChatGPT accepts .xls, .xlsx and .csv uploads and can run Python against them for calculations, cleaning and charts. OpenAI advises descriptive headers in the first row and one row per record. The environment cannot make external web requests, so anything live, such as prices or rates, has to be in the file you upload.
Is the ChatGPT for Excel add-in the same as Copilot in Excel?
No. They are separate products from OpenAI and Microsoft, each a sidebar inside Excel. Which one you use is usually decided by what your company has licensed and switched on. If both are available, try the same task in each on a copy of the file and keep the one that handles your workbook with fewer corrections.
Is it safe to use ChatGPT for Excel with company data?
The product page says data from Business, Enterprise, Edu and Teachers plans is not used to improve models by default, and that in Enterprise workspaces the add-in is off until an admin turns it on. Because the add-in runs inside Excel, Microsoft's marketplace terms also apply. Ask your IT team which plan you are on before putting client data in a prompt.
Leave a comment: