Somewhere between the third help article and the fifth rearranged bracket, a spreadsheet formula stops being a tool and starts feeling like a personal enemy. You know exactly what you want the sheet to do — add up the grocery spending, but only the rows from March — and yet the correct arrangement of symbols refuses to appear.
Here’s the good news: you may never need to learn that arrangement. The free AI chatbots millions of people already use — ChatGPT, Claude, Gemini — are surprisingly good at turning a plain-English description into a working formula. You describe the job; the chatbot writes the syntax. The skill isn’t the formula anymore. It’s the description.
Describe the job like you’d explain it to a colleague
The method is almost disappointingly simple. Open your usual chatbot and write out what you want, the way you’d explain it to a patient colleague who happens to know every spreadsheet function ever invented:
“Column A has product names and column B has prices. In column C, I want each price with 20% VAT added on.”
Out comes a formula — something like =B2*1.2 — along with, if you ask, an explanation of why it works. Copy it into the cell, drag it down the column, done. This covers the everyday stuff: sums with conditions, looking up a value from another sheet, counting how many times something appears, working out the difference between two dates.
It works because you’ve handed the chatbot the one thing it needs most: context. A chatbot can’t see your spreadsheet (unless you’re using the built-in tools, more on those below), so your description is its only window into what you need.
The three details that make or break the answer
Most bad formulas from chatbots come from vague requests, not bad AI. Give it these three things and the results improve dramatically.
1. Which app you’re using. Say “Excel” or “Google Sheets” up front. The two are nearly identical, but a handful of functions differ, and you want the formula in your app’s dialect.
2. Your layout. Name the columns and what they hold: “Column A has dates, column B has categories like Groceries and Transport, column C has amounts.” Five seconds of typing; a completely different quality of answer.
3. A couple of example rows — and the awkward cases. Show two or three rows of what your data looks like, and mention anything unusual: “Some cells in column C are blank” or “The dates include times, not just days.” The edge cases are where formulas usually break, and telling the chatbot about them now saves a round of debugging later.
A request with all three sounds like this: “In Google Sheets: column A has dates, column B has categories (Groceries, Transport, Rent), column C has amounts, some blank. Give me a formula for cell E1 that totals the Groceries spending.” Specific in, specific out.
Ask for the explanation, not just the formula
There’s a second sentence worth adding to every request: “Explain what each part does.” The chatbot will walk through the formula piece by piece, and that explanation is worth more than the formula itself. Next month, when the same structure almost fits a new problem, you’ll adjust it yourself instead of starting from zero.
This is also how the habit compounds. After a few rounds of reading explanations, the formulas stop looking like line noise. You’ll recognise SUMIFS when you see it. You’ll know why the dollar signs appear in some cell references. The chatbot becomes less of a crutch and more of a tutor that happens to answer instantly.
Test it on answers you already know
Chatbots write formulas the same way they write everything else: fluently, confidently, and occasionally wrong. A bracket in the wrong place, a range that’s one row short, a function that doesn’t exist in your version of Excel — any of these can slip into an otherwise perfect-looking answer.
So before the formula goes anywhere near important data, test it. Point it at a small set of rows where you already know the right answer, and check. If something comes back wrong — or the sheet throws an error — paste the error message back into the chat and ask what went wrong. Debugging by conversation is one of the genuinely useful things these tools do, and it’s worth building the habit of checking a chatbot’s work rather than trusting it on sight.
Keep your real numbers out of the chat
One caution before you paste anything in: use stand-in data. Replace real names, salaries, account numbers and anything else sensitive with obvious fakes — “Alice, Bob, Carol” and round numbers do the job fine. The formula doesn’t care whether the names are real; it only cares about the shape of the data.
This is the one part of the process worth being strict about. What you type into a chatbot may be stored, reviewed or used to improve the service, depending on the provider and your settings — which is why we wrote a whole guide on what happens to the text you paste into a chatbot.
If you’d rather not leave the spreadsheet
Describing your sheet to a separate chatbot works, but it’s a little clumsy — you’re translating your data into words, then translating the answer back into cells. Both Google and Microsoft now offer a shortcut: AI built directly into the spreadsheet, where it can already see your data.
In Google Sheets, the “Ask Gemini” panel (the sparkle icon at the top right) generates formulas from plain descriptions of your sheet, and can even repair a broken one: hover over a cell showing an error and click Fix, and Gemini will analyse what’s wrong. You can also start from any cell by typing = and pressing Ctrl+Alt+G on Windows, or ⌘+Ctrl+G on a Mac. It’s available on Google’s paid plans.
In Excel, the Copilot side pane does much the same thing — describe the formula in plain English and it builds it, with an explanation and sometimes alternatives. That one needs a Microsoft 365 Copilot subscription, so for most people the free chatbot method remains the practical route.
Whichever route you take, the principle is the same: you were never supposed to memorise which function nests inside which. Describe what you want, check what comes back, and keep your real data to yourself. The brackets can sort themselves out.
