The best AI model for excel spreadsheets
Explain a pasted range, or draft a formula you will check in the sheet.
Short answer
ChatGPT Free ($0) and GPT-5.6 Luna are the subscription fit. On the API, DeepSeek V4 Flash 0423 at $0.09 in · $0.18 out per million tokens The rate is for 1,000,000 tokens, not for one message. A short email is a tiny fraction of that. A long contract with a long answer can use a real slice of it. Glossary is the cheapest sensible pick. This illustration A chunk of text the bill is counted in. A token is often a short word or part of a word. One million tokens is roughly 750,000 English words. That ratio is a rule of thumb, not a count of your file. Glossary is 2,500 input tokens and 600 output tokens, about $0.0003.
A language model is not a spreadsheet. Add the column in Excel, then ask what changed. Use the model to explain a range you paste, to draft a formula, or to describe a chart you can see. Recalculate anything you might send.
Subscription
For a table you paste into chat, ChatGPT Free and GPT-5.6 Luna are enough. The help center lists spreadsheet uploads (XLSX, XLS, CSV) on Free and paid plans. Plus and GPT-6 Sol are the step up when the pasted answer is muddled, not the starting plan. Plus’s dollar price was not in the captured pricing text.
ChatGPT plans · Check a plan you already pay for
API
A pasted range is text. DeepSeek V4 Flash is the cheap pick for that. The illustration is a modest table in and a short explanation out.
DeepSeek V4 Flash 0423 lists a context window How much text the model can hold in one request: your prompt, the files, and the reply together. If the document is bigger than the window, it does not fit in one go. Glossary of 1,048,576 tokens. A short everyday paste uses a sliver of that.
| Lane Quality, balanced, and cheapest sensible are editorial lanes, not a lab’s product names. Quality is the reviewed pick for hard work. Cheapest sensible is the reviewed pick when a miss is easy to catch. Glossary | Model | Rate What you pay for tokens you send. $2 in means $2 per million tokens of your prompt, files, and images. A rough English guide is about 750,000 words per million tokens. Your file can be shorter or longer. This is not a measurement of a specific document. Glossary | This illustration What you pay for tokens the model writes back. $10 out means $10 per million tokens of the reply. Long answers cost more than short ones, even when the question was small. Glossary |
|---|---|---|---|
| Cheapest sensible | DeepSeek V4 Flash 0423 | $0.09 in · $0.18 out | $0.0003 |
| Step up | GPT-6.2 Sol | $2.00 in · $10.00 out | $0.011 |
Input is what you send What you pay for tokens you send. $2 in means $2 per million tokens of your prompt, files, and images. A rough English guide is about 750,000 words per million tokens. Your file can be shorter or longer. This is not a measurement of a specific document. Glossary. Output is what the model writes back What you pay for tokens the model writes back. $10 out means $10 per million tokens of the reply. Long answers cost more than short ones, even when the question was small. Glossary. $0.09 in and $0.18 out are per million tokens, not per message.
Step up when
- The sheet is a screenshot or an xlsx file. Flash cannot see it. Luna lists file and image input. OpenAI’s help center also says spreadsheet uploads are a ChatGPT feature, separate from this API price.
- The workbook is thousands of rows. Do the totals in Excel first. A model should see the summary, not be asked to add 10,000 rows in its head.
- You are about to trust a date, a price, a name, or a total you did not supply. Paste the source, or leave the claim out.
The step-up model on this page is GPT-6.2 Sol, $2.00 in · $10.00 out per million tokens. The same illustration is about $0.011.
Try these prompts
What actually grew
Here is a pasted range of monthly expenses. Which category grew the most from January to March? Show the subtraction. If a cell is blank, say so.
A formula, then I will test it
Write an Excel formula that flags a row when column C is blank and column D is over 100. Tell me which cell to put it in. I will check it on two rows myself.
The screenshot
This is a screenshot of a budget. Read only the numbers you can see. Tell me what the bottom row appears to add. Do not invent rows.
Overkill
In the app you already use
Only features with a vendor page. Checked 20 Nov 2026.
- Copilot in Excel — The same Microsoft support page says you can ask Copilot in Excel to analyze a budget spreadsheet. Personal, Family, Premium, and Pro include Copilot in the desktop apps. The model name is not published. A simple sheet does not require Pro.
- Gemini in Sheets — Google’s Sheets help says Gemini can create formulas, summarize a sheet, and do things like filters and pivot tables, on an eligible Workspace or Google AI plan. Save an Excel file as a Google Sheet first if you want that sidebar.
- ChatGPT spreadsheet upload — The upload article lists XLSX, XLS, and CSV, and says you can ask about trends. It also says availability depends on plan, region, and the selected model. It does not publish a row limit.
Questions
Can it analyse 10,000 rows?
Not reliably as a mental sum. Aggregate in the spreadsheet, then ask the model what the aggregates mean. Unknown context is not permission to paste the whole company.
Is Copilot a different model I should pay extra for?
Microsoft does not name the model inside Excel. Personal already includes Copilot in the apps at the published $9.99. Pro is the highest allowance, not the first spreadsheet.