Formula Generator
FlagshipType what you want in plain English — "sum column B where column A is paid" — and get the exact Excel formula. Copy, paste, done. Powered by Claude.
Interactive Excel tools that work in your browser.
One-click solutions for the ten most common Excel problems. No downloads, no signup, no ads. Free forever.
Every tool solves one specific Excel problem instantly in your browser. Type in plain English and get a working formula. Paste an error and get the fix. Test any function live. Convert legacy VLOOKUPs to XLOOKUP with one click. These tools also preview what the paid Add-in can do inside Excel itself.
Ten free tools
Error Explainer
FlagshipPaste your errored formula. Get plain-English explanation of what's wrong and a copy-paste fix. Works on every Excel error type.
Function Playground
Test any Excel function with your own inputs in a live sandbox. See how VLOOKUP behaves with your data before writing it into a real workbook.
XLOOKUP Migrator
PopularPaste a VLOOKUP or HLOOKUP formula. Get the equivalent XLOOKUP with cleaner syntax and better error handling. One-click conversion.
Pivot Table Wizard
Describe the report you need — "sales by region by month" — and get pivot table setup instructions or a starter workbook.
Chart Recommender
Describe your data and what you want to show. Get the right chart type (bar, line, waterfall, treemap) with rationale and setup steps.
Regex Builder
Describe the pattern you want to match. Get a working regular expression for REGEXTEST, REGEXEXTRACT, or REGEXREPLACE with explanation.
VBA Code Generator
Describe the automation you need in plain English. Get working VBA code with comments explaining every line. Also works for Office Scripts.
Data Cleaning Assistant
Paste messy data. Get cleaning instructions and formulas: trim whitespace, standardize casing, fix dates, remove duplicates, split columns.
AI Assistant (Free)
AIGeneral-purpose Excel chat. Ask anything — how a function works, how to structure a workbook, why a formula returns the wrong answer.
Which tool for which task?
I need a formula but don't know which function
→ Formula Generator
My formula is showing an error
→ Error Explainer
I want to test a function before using it
→ Function Playground
I have VLOOKUP formulas I want to modernize
→ XLOOKUP Migrator
I need to summarize data by categories
→ Pivot Table Wizard
I have data and don't know which chart to use
→ Chart Recommender
I need to match text patterns in cells
→ Regex Builder
I want to automate a repetitive task
→ VBA Generator
My data is messy and needs cleanup
→ Data Cleaning Assistant
I have a general Excel question
→ AI Assistant
Frequently asked questions
Are all these tools really free?
Yes. Free tier includes 20 uses per tool per day — more than enough for occasional use. Heavy users get unlimited access through the paid Add-in that runs inside Excel itself.
Do I need to sign up?
No. Every tool works instantly without an account. Free tier limits are enforced by browser session (they reset if you use incognito mode). Paid Add-in users get unlimited use without any tracking.
Do my prompts get stored or used to train AI?
No. Prompts are sent to Anthropic's Claude API for real-time processing, then discarded. Not stored, not logged, not used for model training. Read our full privacy policy.
Which tools are the most popular?
The four flagship tools: Formula Generator (write formulas in English), Error Explainer (fix broken formulas), Function Playground (test before deploying), and XLOOKUP Migrator (modernize legacy formulas).
What if the tool gives me wrong output?
Always test AI-generated formulas or code with sample data before using in production workbooks. Wrong-output reports are treated as top-priority bugs — email info@sheetsandcells.com with the input you used.
All these tools — inside Excel.
The Sheets & Cells Add-in brings every tool into Excel's task pane. Unlimited use on Pro tier. $29 one-time.
Get the Add-in →