Checked against the OpenRouter public models feed. Prices are copied, not estimated.

The Best Model ForWhich AI model to use, from ten labs.

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.

Listed token rates for this illustration. Not a measurement of your file.
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. GlossaryModelRate 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. GlossaryThis 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 sensibleDeepSeek V4 Flash 0423$0.09 in · $0.18 out$0.0003
Step upGPT-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 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

  1. 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.

  2. 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.

  3. 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.

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.