Summary

This free AI formula generator turns a plain-English description into a working Excel or Google Sheets formula. Type what you need, such as sum sales where region is West, adjust the ranges, and copy the result. It covers twelve everyday jobs, from SUMIF and XLOOKUP to percent change, and shows which versions each formula supports. It runs entirely in your browser.

Free spreadsheet tool

Free AI Formula Generator for Excel and Sheets

Describe the job in plain English. Biscuit fetches a working Excel or Google Sheets formula, with your own ranges filled in.

Build my formula

Fetch a formula

Type what you need, or pick a formula type. Change the ranges and the formula updates live. Copy it with one click.

Your formula

Pick a task or describe the job above.

What it does

    How it works

    What happens when you type a sentence

    It reads your keywords

    Words like sum, how many, look up or percent point to a formula pattern. If it guesses wrong, the dropdown overrides it in one click.

    It fills in your ranges

    Each pattern has labelled fields for ranges, cells and conditions. Text goes in quotes, numbers stay bare, and cell references are left alone.

    It tells you where it works

    Every result lists the Excel and Sheets versions that support it, plus an older-Excel alternative when a modern function has one.

    What it covers

    Twelve everyday jobs, no guessing

    These are the formulas people search for most. Each one is a standard pattern, so the answer is the same one a spreadsheet expert would give you. Biscuit does not improvise here: a formula that looks right and returns the wrong number is worse than no formula.

    • SUMIF, SUMIFS, COUNTIF and AVERAGEIF
    • XLOOKUP with an INDEX and MATCH fallback
    • Percent change that avoids #DIV/0!
    • Days between two dates
    • TRIM and CLEAN for messy pasted data
    • Text before or after a dash, comma or any character
    • TEXTJOIN, UNIQUE and FILTER
    Desk with a laptop spreadsheet, coffee, notebook and a tennis ball
    Quick start

    From sentence to cell in three steps

    1. 1

      Describe or pick

      Type something like count orders over 100, or choose the formula type from the list.

    2. 2

      Match your sheet

      Replace the example ranges with your own, for instance A2:A500 instead of A2:A100. Use cell references for conditions if you like.

    3. 3

      Copy and paste

      Press Copy formula, click a cell and paste. Check the result against a row you can verify by eye. That is how Biscuit double-checks too.

    Questions

    Common questions about this formula generator

    Is this an AI formula generator or a template tool?
    Honest answer: it is a rule-based builder that reads your sentence for keywords like sum, count, look up or percent, then fills in a proven formula pattern with your ranges. There is no language model behind it, so it never invents a function. For jobs outside its list, Formula.dog is the AI version.
    Is it free, and do I need an account?
    Free, no sign-up, no limit. Everything runs in your browser, so your ranges and conditions never leave the page.
    Does the formula work in both Excel and Google Sheets?
    Each result has a Works in line. SUMIF, COUNTIF, AVERAGEIF, TRIM and the percent change formula work everywhere. XLOOKUP, UNIQUE and FILTER need Excel 365 or 2021, or Google Sheets.
    Why are there two formulas for some jobs?
    Many readers are still on Excel 2016 or 2019. Where a modern function has an older equivalent, such as INDEX and MATCH for XLOOKUP, the tool shows both so you can pick the one your version understands.
    Why does my formula show an error in my spreadsheet?
    Check three things: the ranges must match your real data, both ranges in a SUMIF need the same number of rows, and some locales use a semicolon instead of a comma between arguments. Swap the commas if your spreadsheet asks for it.
    Can it write nested IFs, array formulas or VBA?
    Not this one. It sticks to twelve common jobs so every answer is predictable. Formula.dog handles nested logic, LET, LAMBDA, ARRAYFORMULA and VBA from a plain-English description.
    Do I need to type exact keywords?
    No. Write it the way you would say it to a colleague. If the match is wrong, pick the formula type from the dropdown and the fields update straight away.
    Need something this tool does not cover?

    Describe any spreadsheet problem and let Biscuit fetch it

    Formula.dog is the full AI version: nested logic, LET, LAMBDA, ARRAYFORMULA, VBA and regex from a plain-English description. The first five formulas a day are free.