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.

Free spreadsheet tool

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.

Spreadsheet formula prompt generator

Pick your app, describe the result and say where the data sits. The prompt updates as you type. Copy it into any AI chat.

Extra rules
Prompt strength0/100

How it works

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.

Why it matters

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
Hands typing a question into a laptop that shows a spreadsheet
Three steps

From vague to precise in about a minute

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

Questions

Prompt generator FAQ

What is a prompt generator for spreadsheet formulas?
It is a form that turns a vague request like sum the sales into a complete prompt for ChatGPT, Claude, Copilot or Gemini. The prompt names your app and version, your columns, an example and the format of the answer. AI assistants guess less when they get all of that up front.
Is this prompt generator free, and does it store my data?
It is free, with no sign-up and no limit. Everything runs in your browser. What you type stays on this page and is never sent to a server, so you can describe real column names without worry.
Does it write the formula for me?
No. It writes the question you ask the AI. If you want the formula itself without a second tool, Formula.dog takes the same plain-English description and returns the formula directly.
Which AI assistants does the prompt work with?
Any chat assistant. The prompt is plain text with no special syntax, so it works in ChatGPT, Claude, Gemini, Microsoft Copilot and Gemini in Google Sheets. Paste it as your first message.
Why does the tool ask for my Excel version?
Because the same job has different answers. XLOOKUP and FILTER exist in Excel 365 and 2021 but not in Excel 2016 or 2019. Telling the AI up front stops it from handing you a formula that returns #NAME? in your file.
Why add an example to the prompt?
An example is the fastest way to remove doubt. One line such as West, 120, Paid gives 120 tells the AI what counts, what to ignore and what the result should look like. It also gives you a ready-made test for the formula you get back.
How do I know the formula from the AI is right?
Check it against a row you can verify by eye. The default prompt asks the AI for a test case with the expected result, so you can compare. Check the ranges too: they must match your real data.
Skip the middle step

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.