Somewhere on your computer there’s a spreadsheet you’re afraid of.
Maybe your old bookkeeper built it and nobody knows how it works anymore. Maybe you downloaded a template years ago and one column has never added up right. Maybe you’ve simply always felt that spreadsheets are for “numbers people,” and you’re not one of them.
Here’s the shift worth knowing about: AI chat tools — ChatGPT, Claude, Gemini — turn out to be very good, very patient spreadsheet tutors. They never sigh. They never make you feel slow. You can ask the same question four different ways at eleven at night, and the fourth answer will be as friendly as the first.
Ask it to explain the mystery formula
Say you run a café and you’ve inherited a costing sheet from the previous owner. One cell contains this: =IF(B2>50,B2*0.9,B2). You have no idea what it does, and you’re scared to touch it.
Copy the formula, paste it into an AI chat, and ask:
“I’m not a spreadsheet person. Explain in plain English what this formula does, step by step: =IF(B2>50,B2*0.9,B2)”
You’ll get something like: it checks whether the value in cell B2 is over 50. If it is, it multiplies it by 0.9 — a ten percent discount. If not, it leaves the number alone. Suddenly the mystery cell is just a bulk-order discount. You can do this with any formula in any inherited sheet, one cell at a time, until the whole file makes sense.
Ask it to write formulas for you
It works the other way too. Describe what you want in ordinary words, name your columns, and ask for the formula.
“In Google Sheets, column A has job dates, column B has amounts invoiced, and column C says either Paid or Unpaid. Write me a formula that adds up all the unpaid amounts. Then explain how it works so I understand it.”
That last sentence matters. Always ask for the explanation, not just the formula. Otherwise you’re pasting magic spells into your sheet, and next month you’ll be scared of your own file all over again.
If the formula throws an error when you paste it, don’t give up — paste the error message straight back:
“I pasted that and got a #VALUE! error. Column B sometimes has blank cells. What went wrong and how do I fix it?”
This back-and-forth — try, fail, ask, fix — is exactly how spreadsheet people became spreadsheet people. The difference is you now have a tutor on call.
Two small tips that prevent most frustration. Tell the AI which app you’re using — Excel and Google Sheets are almost the same, but not quite. And tell it which cells or columns your numbers live in, because it can’t see your screen.
Ask it to design a tracker from scratch
You never need to start from a blank grid again. Tell the AI what you’re trying to keep track of, and let it propose the layout.
Say you’re a plumber who keeps losing track of quotes:
“I’m a plumber. I want a simple spreadsheet to track quotes: who asked, what job, the amount, when I sent it, and whether they said yes. Suggest the columns, one example row, and a formula that shows my win rate — the percentage of quotes that turned into jobs. Keep it simple enough for a beginner.”
The same idea works for a stock list in a gift shop, a booking sheet for a dog groomer, or an order tracker for an Etsy store. Start simpler than you think you need. A five-column sheet you actually use beats a fifteen-column sheet you abandon by March.
Paste examples, not your whole sheet
One rule to hold onto: describe your spreadsheet, don’t dump it.
Your real sheet may contain customer names, phone numbers, addresses, staff pay. That information doesn’t belong in an AI chat tool. The good news is the AI doesn’t need it. It needs the shape of your data, not the data itself.
So instead of pasting two hundred real rows, paste two made-up ones — “Jane Example, leaky tap, 180, sent May 3, Unpaid.” A formula written for fake rows works identically on real ones.
When the answer looks wrong
AI tools sometimes make things up, and they do it confidently. A formula might reference the wrong column or use a function your app doesn’t have. So test everything on numbers you can check by hand first. If the sheet says your unpaid total is 1,240 and you can eyeball roughly 2,000 of unpaid work, something’s off — go back and ask. Being a little suspicious isn’t failing at spreadsheets; it’s being good at them.
And remember that AI is not an accountant. Use it to build and understand your own tools. For anything that feeds your taxes or official accounts, have a professional sign off on the numbers that matter.
Try this today
Pick the one number you always wish you knew off the top of your head — unpaid invoices, this month’s bookings, stock running low. Open a free AI chat tool and describe a tiny tracker for it, using the plumber instruction above as your pattern. Build the sheet it suggests with two or three made-up rows and check the formula works.
Ten minutes, and you’ll have a working tracker — plus something rarer: proof that spreadsheets were never for “numbers people.” They’re for anyone with a patient tutor. You have one now.