How to use AI with spreadsheets
You don't need to be a formula expert to get more from Excel or Google Sheets. This guide covers getting formulas written for you, understanding sheets you inherited, cleaning messy data, and the checks that stop a wrong number reaching a decision.
1. Describe what you want in plain English
You don't need to remember formula syntax. Describe the result: "In Excel, give me a formula that adds up column D only where column B says 'Paid' and the date in column C is this month."
AI will give you the formula — usually a SUMIFS, XLOOKUP or similar — and explain what each part does. Paste it in, adjust the column letters to match your sheet, and test it on a few rows you can check by hand.
This turns twenty minutes of searching help forums into two minutes of describing the problem.
2. Understand a spreadsheet someone else built
Inheriting a workbook full of nested formulas is one of the most common spreadsheet headaches. Paste a formula into the AI and ask: "Explain what this does, step by step, in plain English."
Ask follow-ups: "What happens if the cell is empty?" or "Why might this return the wrong row?" You'll understand the sheet faster than by clicking through cells for an afternoon.
This is one of the safest AI uses there is — you're explaining a formula, not sharing data.
3. Clean up messy data
Real-world spreadsheets arrive with names in three formats, dates as text, and duplicates everywhere. Describe the mess and ask for the formulas or steps to fix it: trim spaces, split columns, standardise dates, flag duplicates.
For one-off clean-ups, you can also paste a small sample of the data (nothing sensitive) and ask for the pattern: "Here are ten examples — write a formula that turns all of these into the format DD/MM/YYYY."
Always keep the original untouched. Do the clean-up in a copy or a new column, so you can compare before and after.
4. Turn numbers into a story
Once the numbers are right, AI helps with the part most people find hardest: saying what they mean. Paste in your summary table (anonymised if needed) and ask for the key points in plain English.
"Here are this month's figures by region. Write three sentences for the team update highlighting what changed and what needs attention." You get a draft narrative to edit, not a blank page.
It can also suggest the right chart or layout for the point you're making — a trend wants a line, a comparison wants bars.
5. Test before you trust
A formula that looks right can still be wrong — wrong range, wrong condition, quietly counting blanks. Test every AI-written formula against a handful of rows where you already know the answer.
Be suspicious of round, confident explanations. If the AI says a formula "will" do something, verify it does. The explanation can be as invented as the formula is correct.
And keep real customer or financial data out of the chat unless you're using an employer-approved tool. Describe the structure — column names and a made-up example row — and the formula works just the same.
Coached through your real sheets
Your AI Work Coach works with the spreadsheets you actually use — the tracker, the budget, the report that lands every month — and builds your skills on real examples, a few minutes a day.