Summary

This free excel formula generator turns a plain-English description into a working Excel or Google Sheets formula. Pick a category (lookups, conditional sums, logic, dates or text), let the tool match your sentence to one of 15 real formula patterns such as VLOOKUP, SUMIF, nested IF or EDATE, then fine-tune the guessed cell references before copying the result. Everything runs client-side: no sign-up, no server call, no invented functions, just Excel syntax that actually works.

Describe your spreadsheet problem, get a working Excel formula

A free excel formula generator for VLOOKUP, XLOOKUP, SUMIF, nested IF, date math and text formulas. Type what you need or use the guided builder below. No sign-up, no invented functions, just real Excel syntax picked from what you type.

Build my formula See how it works
Laptop screen at night showing a dark-mode spreadsheet with a glowing formula bar

Excel formula generator

Describe what you need in plain English, or set the category and function yourself. Every field stays editable, so you can fix a guess in two clicks.

=VLOOKUP(A2, B2:D100, 3, FALSE)

Looks up A2 in the first column of B2:D100 and returns the value from column 3 of that range. Exact match only.

How it works

Three steps, no account

The whole loop runs client-side. Nothing you type leaves your browser.

  1. 1

    1. Say what you need

    One sentence is enough: "sum column B when column A says East" or "count rows where status is Done". Cell references and quoted values in your sentence get picked up automatically.

  2. 2

    2. Check the guessed function

    The tool scores your sentence against 15 real Excel patterns and lands on the closest one. The category, function and every parameter are shown as plain fields, not hidden behind a chat bubble.

  3. 3

    3. Copy the formula

    The formula box updates on every change. Hit copy, paste it into the cell, done. The plain-English explanation underneath tells you what the formula actually does before you commit to it.

Under the hood

No fake AI. A curated library of real Excel functions.

Every template maps to a function that actually exists. Nothing invented, nothing that only works in a demo video.

Lookups that hold up

VLOOKUP, XLOOKUP and INDEX/MATCH, matched from phrases like "look up a price" or "lookup another sheet". Column references you type get slotted straight into the formula.

Conditional sums and counts

SUMIF, SUMIFS and COUNTIF cover the "total sales where region is X" family of questions, including a second condition when you need it.

Dates, text and logic

Nested IF for grading scales, IFERROR to hide #N/A, EDATE and day-of-week for date math, LEFT and email-domain extraction for text cleanup.

Behind the widget

Fifteen formula patterns, matched by keyword, not by guesswork

If you have ever built a scraper that dumps rows into a sheet and then burned twenty minutes hunting for the right SUMIFS argument order, this tool is for that exact moment. It does not try to be clever about spreadsheet problems it has never seen. It knows fifteen patterns cold, covers the ones people hit daily, and gets out of the way for the rest.

  • Lookups: VLOOKUP, XLOOKUP, INDEX/MATCH
  • Conditional sums and counts: SUMIF, SUMIFS, COUNTIF
  • Logic: simple IF, nested IF, IFERROR
  • Dates: days between, add months, weekday name
  • Text: combine cells, extract characters, pull an email domain
Overhead view of a mechanical keyboard next to a notebook sketch of a spreadsheet grid

Common questions

Is this excel formula generator actually free?
Yes. No sign-up, no email gate, no usage cap. It runs entirely in your browser, so there is nothing to meter.
Where do the formulas come from? Is this an AI model?
No model, no server call. It is a curated library of 15 real Excel and Google Sheets patterns (VLOOKUP, XLOOKUP, SUMIF, nested IF, date math, text functions). Your description is matched against that library by keyword, not generated token by token.
Why not just use a real AI assistant for this?
For a well-known pattern, a rule-based match is faster and never hallucinates a function that does not exist. For messier prompts, VBA macros, regex, or an explanation of a formula you already have, formula.dog runs an actual model and covers more ground.
Does the tool understand Google Sheets syntax too?
The formulas it builds (VLOOKUP, SUMIF, IF, EDATE, LEFT and friends) work in both Excel and Google Sheets. XLOOKUP works in Sheets and in Excel 2021+ / Microsoft 365; older Excel versions do not have it, use INDEX/MATCH instead.
The description box picked the wrong function. What do I do?
Adjust the category and function selects manually, or click the operation you actually meant. The guided builder is always live under the description box, so it is never a dead end.
Is anything I type sent to a server?
No. The matching and the formula assembly both run in your browser. Nothing you type is stored or transmitted (a single anonymous tool-run beacon fires so we know the widget got used, no content included).
Can it handle two conditions at once, like sum by region AND by month?
Yes, pick SUMIFS under "Sum, count or average with a condition". It takes a sum range plus two condition ranges.
What if I need VBA or a regex pattern, not a formula?
This tool sticks to worksheet formulas on purpose, so every output is something we can verify. formula.dog covers VBA snippets and regex if that is what you are after.

Need something these 15 patterns do not cover?

formula.dog runs an actual model on messier prompts: VBA macros, regex, Airtable and Notion formulas, and explanations of formulas you already have. Five formulas a day are free, no sign-up.

~/build
Generate an idea