If you've ever stared at a 30-tab workbook wondering where to even start, you know the feeling. Spreadsheets with linked sheets, conditional formulas, and a dozen small exceptions eat more hours than anyone wants to admit.
What's actually improving
Across the board, the latest generation of large language models (the AI engines behind assistants like ChatGPT, Claude, and Gemini) is doing better on exactly this kind of work. Two things have moved at once.
Speed. Tasks that used to make you wait — generating formulas across many sheets, cleaning up a long column of inconsistent entries, rewriting a whole formula in plain English — now come back faster. You can ask a follow-up question and get a real answer instead of a coffee break.
Accuracy on messy tasks. The bigger change is what researchers call intent understanding — meaning the model is better at figuring out what you actually meant, not just what you literally typed. When you write "fix the totals," older models sometimes changed every number on the page. Newer ones are more likely to guess correctly that you meant the column at the far right.
A useful mental model: think of the older AI as a very literal assistant who follows your exact words. The newer one is closer to a junior coworker who pauses, summarizes what they think you want, and checks before touching anything.
A simple example
Say you have a workbook tracking your monthly bills, with one tab per provider. Older AI might correctly total column B but break the link to your summary tab. Newer models, based on what several companies have demonstrated in their own benchmarks, are more likely to keep those cross-tab references intact — and more likely to warn you when they can't.
Most companies describe these improvements as "better at following complex instructions." That phrasing is their own — the real test is whether it works on your actual files, which you can only judge by trying.
How to actually use this today
- Start small. Pick one recurring task you hate — a monthly reconciliation, a name-and-address cleanup — and try it on a copy of your file, not the original.
- Describe the goal, not the steps. Instead of writing the formula yourself, say in plain English what the column should show. The model can usually write the formula better than you'd guess.
- Always check the cross-links. Even with better intent understanding, complex workbooks have surprises. Glance at any totals that pull from multiple tabs before you trust the answer.
- Give context. A useful prompt mentions how many tabs are involved and what each one represents. The model does better when it knows the shape of the problem.
Wrap-up
Better speed and better intent understanding aren't glamorous upgrades, but they're the ones that quietly change a workday. Pick one spreadsheet task you do regularly, hand it to an AI assistant on a copy of the file, and see what it actually does. That's the only benchmark that counts for you.
