Summary
This free prompt generator turns a vague spreadsheet request into a complete prompt for ChatGPT, Claude or Copilot. You pick your app and version, describe the result, name your columns and add one example. The tool builds the prompt, scores how precise it is and lets you copy it in one click. It helps AI assistants return the right Excel or Google Sheets formula the first time. It runs in your browser.
Prompt Generator for Excel and Google Sheets Formulas
Fill in five fields and Biscuit fetches a prompt that makes ChatGPT, Claude or Copilot give you the right formula the first time.
What goes into a prompt that works
It pins down your version
The prompt names your app and lists what it cannot use. Excel 2016 has no XLOOKUP and Google Sheets has no Excel-only functions, and the AI is told so before it answers.
It makes you name the data
The strength meter gives points for a clear goal, named ranges, an example and at least one extra rule. Vague requests score low, so you see the gap before you ask.
It asks for a way to check
The default reply format requests the formula, each argument explained, a test case with the expected result and the most likely error. Good boy: you can verify the answer yourself.
Most bad AI formulas come from a thin question
Ask an AI for a formula that sums sales by region and it will invent column letters, assume a modern Excel and skip your blank rows. The formula looks right and returns the wrong number. That is the worst kind of wrong, because nobody checks it. The same request with your ranges, your version and one example gives a formula you can paste and trust after a ten-second check. This generator is the shortcut to that second kind of question.
- Version rules keep XLOOKUP and FILTER out of old Excel files
- Named ranges stop invented column letters
- Blank-cell and error rules cover the two most common failures
- The example doubles as your test row
From vague to precise in about a minute
-
1
Describe the job
Choose your app and the kind of job, then write the result you want in one or two sentences. Say what you want to see, not how to build it.
-
2
Say where the data is
List the columns or ranges, such as A2:A500 for region and B2:B500 for amount. Add one example row with the answer you expect.
-
3
Copy and paste into your AI
Press Copy prompt and paste it as the first message. Check the formula against your example row. Biscuit double-checks too.
Prompt generator FAQ
What is a prompt generator for spreadsheet formulas?
Is this prompt generator free, and does it store my data?
Does it write the formula for me?
Which AI assistants does the prompt work with?
Why does the tool ask for my Excel version?
Why add an example to the prompt?
How do I know the formula from the AI is right?
Describe the problem and let Biscuit fetch the formula
Formula.dog turns a plain-English description into a working Excel or Google Sheets formula, with version notes and a fallback for older Excel. The first five formulas a day are free.