Be honest: how many times have you stared at a spreadsheet, needed one simple total, and ended up Googling "how to sum a column if another column says paid"? 😅 That tiny moment of formula-panic has scared people away from Excel and Google Sheets for decades. Well, as of mid-2026 it's officially over.
ChatGPT now lives inside your spreadsheet. A native sidebar — powered by GPT-5.5 and available free on every plan — builds, fixes and explains formulas in plain English while you watch. You type what you want; it writes the formula, shows you exactly which cells it's touching, and asks before changing anything. Let's get it running.
What You'll Need 🎯
- Excel or Google Sheets — works in both, desktop or web.
- A free ChatGPT account. The sidebar is now generally available on all plans, including Free, worldwide.
- A messy or half-finished spreadsheet — a budget, a sales list, anything you've been avoiding. That's your playground.
Step 1: Open the ChatGPT Sidebar 📊
Open your spreadsheet in Excel or Google Sheets and look for the ChatGPT panel on the right side. If it's not showing yet, enable it from the add-ins or extensions menu and sign in to your ChatGPT account once. From then on it stays one click away, docked beside your grid.
That side panel is the whole game. It can see your sheet — your columns, your headers, your data — so you never have to explain where things are. You just talk to it.
Step 2: Describe What You Want in Plain English ✨
This is the magic. No formula syntax. No remembering whether it's SUMIF or SUMIFS. You just say what you're trying to do, like you'd say it to a coworker:
"Add up everything in column B where column A says Paid, and put the total in cell B50."
The sidebar reads your sheet, writes the exact formula, and drops it where you asked. Want a budget built from scratch? Try: "Build me a monthly budget with categories, amounts, and a running total." It just does it.
Type the request, watch the formula appear — and see exactly which cell it lands in.
Step 3: Review the Cells It Points To 🔍
Here's the part that makes this trustworthy instead of scary. Before anything changes, the sidebar shows you the formula it wants to use and links its answer to the exact cells it touched. Click the reference and the matching cells light up in your grid, so you can see precisely what it's reading and writing.
💡 Pro Tip: Always glance at the highlighted range before approving. If it's pointing at column B when your numbers live in column C, you'll catch it in two seconds — no broken sheet, no mystery.
Step 4: Approve the Change ✅
Nothing happens to your data until you say yes. The sidebar asks permission before editing anything, and it preserves your existing formatting — your colors, borders, currency symbols and headers all stay put. Hit approve and the formula goes live in your sheet.
This "propose, then confirm" flow is what makes it safe for real work. You're always the one with the final click.
Step 5: Ask It to Explain or Fix Existing Formulas 🛠️
Inherited a spreadsheet full of formulas you don't understand? Or hit the dreaded #REF! error? Just ask. Click a cell and type things like:
"Explain what this formula does in simple terms." — or — "Why did this break, and how do I fix it?"
It'll plain-English the logic, diagnose #REF and other errors, and offer a fix you can approve. This is also where VLOOKUP, XLOOKUP and pivot-style summaries stop being intimidating — describe the lookup or summary you want and let it write it.
Messy data in, clean and explained data out — formulas no longer required knowledge.
Use It, Make It Pay, Go Viral 💰
The same skill scales three ways:
- Use it — clean messy data, build a budget, run a
VLOOKUP, or summarize sales in minutes instead of an afternoon. - Make it pay — offer "spreadsheet cleanup & automation" as a small-business gig. Plenty of owners will happily pay to never touch a formula again.
- Go viral — record a 30-second clip of you typing a plain-English request and a formula building itself. "I haven't written a formula in weeks" is the kind of hook that travels.
Key Takeaways
- ChatGPT's native sidebar is now free on all plans, worldwide, powered by GPT-5.5 — in both Excel and Google Sheets.
- Describe what you want in plain English; it builds, edits and explains formulas for you.
- It links answers to the exact cells it touched, so you can verify before approving.
- It asks permission before changing anything and preserves your formatting.
- Great for cleaning data, budgets,
VLOOKUP/XLOOKUP, pivot summaries and fixing#REFerrors.
Frequently Asked Questions
Is the ChatGPT spreadsheet sidebar really free?
Yes. As of mid-2026 it's generally available across all plans, including the Free tier, globally. Paid plans give you more usage and the latest models, but you can start at $0.
Does it work in both Excel and Google Sheets?
Yes — the native sidebar runs in both. Enable it from your add-ins (Excel) or extensions (Google Sheets) menu, sign in once, and it docks beside your grid.
Will it change my spreadsheet without asking?
No. It proposes a formula, shows you the cells involved, and waits for your approval before editing. It also preserves your existing formatting, so nothing gets scrambled.
Can it fix broken formulas and #REF errors?
Yes. Click the problem cell and ask why it broke. It'll explain the issue in plain English and suggest a fix you can approve. Still, always sanity-check your totals after any change.
📩 Want the freshest AI trends every week?
Subscribe to Tech4SSD — practical AI tools and trends, explained for everyone. Free. Subscribe →
Final Word
Formulas were the single biggest wall between regular people and powerful spreadsheets. That wall just came down. You don't need to memorize syntax, you don't need to Google "SUMIF" ever again — you just need to say what you want, check the cells, and click approve. 🚀
Open a sheet you've been avoiding and ask it one thing. The first time a formula builds itself in front of you, you'll get it.
AI tools and features change fast — verify current options before relying on them. — Tech4SSD Editorial