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.

.⌘↵ to run

Free to try — 5 formulas a day, no signup required.Verify any formula — free, no signup →

Or jump straight to a task.

Curated from the pages people search for most.

How-to

See all →

Step-by-step recipes for the tasks people search for most.

Fix

See all →

The specific error in your cell, fixed in one paste.

Formulas

See all →

Reference + verified examples for every function.

VLOOKUP & XLOOKUPSUMIFS · COUNTIFSINDEX / MATCHQUERY & ARRAYFORMULAPivot-ready logic

How FormulaCraft works

From a plain-English sentence to a verified formula — and a way to fix a whole spreadsheet at once. Here is the full flow.

FormulaCraft input box with a plain-English request typed in

Describe it in plain English

Pick Generate, Explain, or Fix, choose Excel or Google Sheets, then type what you need — no function names, no syntax to memorize.

A generated SUMIF formula with an explanation and a step-by-step breakdown

Get the exact formula, explained

FormulaCraft returns the right formula for your platform with a plain-English breakdown of every part — so you understand it, not just paste it.

Verified execution panel computing Result: 125 on pasted sample data

Verify it on your own data

Paste a few rows from your sheet and FormulaCraft runs the formula through a real engine — you see the computed result, and catch #REF! or #N/A, before you trust it. This is the part a chatbot simply can’t do.

The Auditor listing broken formulas found in an uploaded spreadsheet

Audit a whole spreadsheet

Got a messy file? Drop an .xlsx into the Auditor and it flags every broken or risky formula at once — then fixes each in a click. Processed in your session, never stored.

Try the Auditor →

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.

Watch it find every broken formula.

Real workflow, recorded live on this site. Drop a broken spreadsheet, see every error, get verified fixes back.

Start free. Upgrade when you rely on it.

5 formulas a day, free forever. Go unlimited from $4.99/mo (₹199/mo) with full history and priority speed.

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).