AI formula assistant · Excel & Google Sheets
Turn plain English into spreadsheet formulas.
Describe what you need. Get the exact Excel or Sheets formula in seconds — explained, ready to paste. No syntax to memorize.
.
Free to try — 5 formulas a day, no signup required.
VLOOKUP & XLOOKUPSUMIFS · COUNTIFSINDEX / MATCHQUERY & ARRAYFORMULAPivot-ready logic
01
Describe it
Type what you want in plain English. No function names, no syntax to memorize.
02
Get the formula
Claude returns the exact formula for your platform — with a plain-English explanation.
03
Paste and go
Copy it straight into Excel or Google Sheets. It just works.
From a sentence to a formula.
A few of the thousands of things people ask FormulaCraft every day.
“Average of column B where column A is "Sales"”
=AVERAGEIF(A:A, "Sales", B:B)“Look up the price for the product typed in D2”
=XLOOKUP(D2, A:A, B:B, "Not found")“Count orders over $500 placed this year”
=COUNTIFS(B:B, ">500", C:C, ">="&DATE(YEAR(TODAY()),1,1))“Join first and last name with a space”
=TEXTJOIN(" ", TRUE, A2, B2)Generate
Plain English → formula
Describe the calculation; get the right SUMIFS, XLOOKUP, or QUERY without guessing.
Explain
Decode any formula
Paste a formula you inherited and get a piece-by-piece breakdown of what it does.
Fix
Repair what is broken
Paste a formula throwing #REF! or #VALUE! — we diagnose the error and hand back the fix.
Questions, answered
Do I need an account?＋
No. You get 5 formulas a day for free without signing up. Create a free account to keep your history, and upgrade for unlimited formulas.
Does it work for Google Sheets?＋
Yes. Flip the toggle to Google Sheets and FormulaCraft uses Sheets-native functions like QUERY and ARRAYFORMULA instead of Excel-only ones.
How accurate are the formulas?＋
FormulaCraft is built on Claude and tuned to produce idiomatic, paste-ready formulas. Every result comes with an explanation so you can verify the logic before using it.
What do I get on a paid plan?＋
Unlimited daily formulas, full saved history, and priority speed — starting at $4.99/mo (₹199/mo in India).