Microsoft Copilot prompt generator for Excel Write effective prompts for Copilot AI

This Copilot prompt generator for Excel turns what you want Copilot to do with your spreadsheet into a complete prompt for Microsoft Copilot, the artificial intelligence (AI) assistant in Microsoft 365. It’s for anyone who doesn’t want to write the perfect prompt from scratch. To go further, try the Founderz Microsoft Copilot training.

Copilot in Excel prompt generator

Create prompts to analyze tables, formulas, variances, dashboards and forecasts in Excel with clear data, units and checks. Only step 1 is required.

How to use the free Copilot prompt generator for Excel

It’s intuitive, but here’s what each step does. Only the first step is required: anything you skip stays on Auto.

1. Give it the essentials. Pick an example (Variances, Formula, Dashboard, Forecast, Data cleanup or Report) or describe your table, its columns, the period and what you need. Then choose what you need in Excel.
2. Describe your data. Where it is (an Excel table, a plain range, several sheets, a CRM or ERP export or data pasted in the chat) and what type it is. The advanced settings cover units, period and permissions.
3. Choose the audience and output. Who it’s for and the format: an Excel table, charts, a Word report, an email, slides or steps in Excel. The advanced settings cover where you’ll use the prompt and the tone.
4. Set the work mode and quality. Copilot’s role in decisions and the level of detail. The advanced settings cover extra checks, the response language and any limit Copilot must respect.
5. Generate and copy your prompt. Click “Generate prompt”, enter your email to see the whole prompt and copy it.

In Excel’s Copilot, effective prompts name the table or range, tell Copilot which columns to use, define what you expect back and ask for a check; the more specific every prompt is, the better. Write the brief in plain language, as you would explain the job to a colleague, and the generator adds the structure. Unlike generic prompt generators, it is built only for Excel workflows, and it gives you a simple step-by-step framework for each use case: clean the data, then calculate, then build the chart.

Example: from a plain-language brief to a Copilot prompt

With the generator’s “Formula” example, the prompt starts like this. It’s an excerpt: the button copies the full prompt.

ROLE
Act as a senior data analyst who is an expert in Microsoft Excel and Copilot in Excel: tables, dynamic array formulas, PivotTables, Power Query and charts. You work from evidence: every figure you give comes from the workbook or is marked [to be confirmed]. You are fluent in modern Excel formulas: dynamic arrays, XLOOKUP, FILTER, LET and LAMBDA.

GOAL
Create or fix an Excel formula that performs the described calculation, explained so that anyone can maintain it.

CONTEXT
Context provided by the user (treat it as your main source):
[START OF BRIEF]
In the Orders table I have the columns Amount, Cost, Channel and Status. I want a column that calculates the margin as a percentage, leaves the cell blank if the amount is 0 and flags orders with a negative margin as "Review".
[END OF BRIEF]

...

OUTPUT FORMAT
Deliver: the formula in a code block, a part-by-part explanation, a test case table (Input, Expected result) and an alternative in case the user does not have Microsoft 365.

...

The full prompt adds the source data, the constraints (no invented figures, no changes to the original data), five working steps with three test cases and a final check before delivery.

The result: Copilot gives you a formula explained part by part and tested on a normal case, an edge case and an error case before you copy it down the whole column.

Tips for better results

Use cases: from data cleaning to data analysis with AI

The “What do you need in Excel?” field covers the jobs people most often hand to Copilot. These are the ones where a structured prompt saves the most time:

• Cleaning Structure workbook data, flag duplicates, missing fields and inconsistent formats without touching the raw data, and ask Copilot to check that numeric columns hold numbers.
• Analysis Analyse a selected table or range in a large dataset and get an actionable summary with the key points.
• Variance and trends Spot variances and trends over time and explain what changed.
• Formulas Explain formulas and the assumptions behind them before you apply them to the whole table.
• Dashboards and charts A dashboard or chart brief with the visual output that fits your audience.
• Forecasts Base, conservative and upside scenarios with every assumption stated.
• Meetings An executive insight note with action items, prepared before or after a meeting.

What makes a good prompt: prompt engineering for Excel

A good prompt gives Copilot what you would give a colleague opening your file for the first time: a role, a specific task, the business context, the material it can use (the table, range or workbook), the constraints (what it must not change) and the output format. Leave one out and Copilot guesses. Spelling out each piece is what makes the difference, and a prompt saved with generic column names becomes a repeatable monthly report.

More ready-to-use Microsoft Copilot prompts

If you analyze data for a living, these AI prompts for business analysts add ready-made templates you can adapt to your own workbooks.

• Copilot vs ChatGPT Which one suits your workflow better.
• How to use AI in project management Reports, plans and stakeholder updates.

More Founderz prompt generators

• Copilot prompt generator Free Microsoft Copilot prompt builder for AI at work.
• Copilot Outlook prompt generator Microsoft Copilot prompts for Outlook.
• Copilot PowerPoint prompt generator Copilot in PowerPoint AI presentation slides.

Why I built these generators

Frequently asked questions

Is this Copilot prompt generator for Excel free?

Yes, it’s free. Before it asks for anything, it shows you a preview with the first sections of the prompt. To see the whole prompt and copy it, enter your email and accept the Privacy Policy; receiving communications from Founderz is optional.

It only asks once per visit: any prompts you generate after that are shown in full.

How is it different from other prompt generators?

It is built only for Excel. Its fields ask for what Copilot needs in a workbook, such as where the data is, the type of data, units and period, and extra checks like reconciling totals or flagging outliers, and it doesn’t call any AI model: it assembles the prompt from your answers.

What do you need to use Copilot in Excel?

An eligible license: Microsoft 365 Personal or Family with an AI credits plan, Microsoft 365 Premium, a commercial Microsoft Copilot subscription, or a business or enterprise plan eligible for Copilot Chat, as the Copilot in Excel FAQ lists. Open Copilot from the icon in the lower-right corner of Excel.

Do these prompts work in Copilot Chat or ChatGPT?

They are designed for Copilot in Excel, and under “Where will you use the prompt?” you can also pick Microsoft 365 Copilot Chat, ChatGPT, Claude or Gemini. In another AI tool you can paste your data and use the same prompt, but you lose the direct workbook editing that Copilot offers inside Excel.

Does Excel Copilot change my file?

In edit mode, yes: Copilot changes the workbook directly. To review first, use plan mode to confirm the steps or chat mode to get analysis without changes.

The prompt also tells Copilot not to modify or delete the original data and to work in helper columns, new sheets or a copy. If an answer is wrong, send feedback with the thumbs icons in the Copilot pane.

Last updated: October 26, 2026