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; it’s free, builds the AI prompt in your browser and asks for your email to show it. It’s intuitive, but below you’ll find instructions, a real example and tips to get more out of it. To go further, try the Founderz Microsoft Copilot training.

Copilot Prompt Generator for Excel

Create a Excel-ready Copilot prompt. Choose the exact task, authorised source material, output structure, review route and limits so the user gets a useful result without Copilot inventing access, changing files or sending anything unapproved.

Fast work draftExecutive-ready versionClient-ready draftAnalysis and checksAction planReview and improve

Brief or context

Excel taskAuto / to be definedAnalyse a selected table or rangeClean and structure workbook dataExplain formulas and assumptionsCreate variance or trend analysisBuild a dashboard or chart briefPrepare forecast scenariosFind exceptions and data quality issues

Authorised source materialAuto / to be definedSelected table or named rangeOpen worksheetWorkbook summaryCSV pasted by the userPivot table or chartFormula cells to reviewData dictionary or column notes

AudienceAuto / to be definedSelfManagerTeamLeadershipClient stakeholderExternal recipientCross-functional project group

Work stageAuto / to be definedBefore creating the first draftImproving an existing draftBefore a meetingAfter a meetingBefore approvalFollow-up or implementationQuality review

Output neededAuto / to be definedAnalysis summaryFormula/checklist explanationChart or dashboard planCleaned-data planScenario tableException listExecutive insight note

Copilot surfaceAuto / to be definedCopilot in ExcelMicrosoft 365 Copilot ChatCopilot with open file selectedCopilot using pasted approved content

Prompt quality and compatibility

Set depth, language, sources and how the AI should work with approved files, tables, presentations or data.

Depth levelAuto / to be definedEssential: fast, without losing contextDeveloped: recommended for most casesProfessional: decisions, exceptions and reviewSpecialist: maximum precision and scenarios

Final output language (priority)Auto / to be definedEnglish (UK)English (US)English (Canada)English (Australia)Spanish (Spain)Spanish (Mexico)Spanish (Colombia)Spanish (Argentina / Río de la Plata)Neutral Latin American SpanishPortuguês (Brasil)Português (Portugal)FrançaisFrançais (Canada)DeutschItalianoCatalàNederlandsPolskiTürkçeالعربية الفصحىहिन्दीBahasa Indonesia日本語한국어中文（简体）中文（繁體）Bilingual: Spanish and English

Material you will provide to ExcelAuto / to be definedNo external files or referencesApproved document or notesApproved spreadsheet or data tableApproved email/thread/meeting notesBrand or style guideReference image or creative briefText pasted directly into the prompt

Attachment, file, table or template reference (optional)

Work mode, presentation and brand

These controls change the prompt structure. The AI should use all useful context you provide, even in Essential mode.

Excel work modeAuto / to be definedDirect and fast responseDeep, evidence-based analysisResearch with authorised sourcesPlan for a supervised agent or automation

Presentation, format and brandAuto / to be definedNo special visual requirementFollow an existing template or documentProfessional report or documentPresentation or slidesTable, dashboard or spreadsheetEmail or communicationVisual piece or publishable contentChecklist, process or workspace

Brand template or reference (optional)

⚙ Advanced settings (6)

Data typeAuto / to be definedSales or pipeline dataFinance and budget dataOperational metricsInventory or stock dataSurvey dataProject trackerHR data in aggregated form

Calculation handlingAuto / to be definedNo calculation requiredCheck formulas onlyVariance analysisForecast with assumptionsBase/conservative/upside scenariosSensitivity analysis

Data quality checksAuto / to be definedDo not modify raw dataDetect duplicatesFlag missing fieldsFlag inconsistent formatsCheck outliersValidate totals and units

Visual outputAuto / to be definedNo visual neededTrend chartComparison chartExecutive dashboardException tableSlide-ready visual summary

Required reviewAuto / to be definedHuman review before useFinance/data-owner reviewManager approvalFormula validationPrivacy review for sensitive data

Privacy and confidentialityAuto / to be definedNo personal dataInternal authorised contentClient confidential contentPersonal data requiring approvalSensitive data: do not process until authorised

Limits, approvals or additional material (optional)

Quality controls

Use only Excel content that is open, selected, pasted or explicitly authorisedDo not claim to send, publish, modify, share, delete, approve or create anything unless the user confirms the actionIdentify missing files, ranges, templates, threads, sources, dates, owners or permissions before proceedingKeep facts, assumptions, calculations, recommendations and pending approvals separateProduce a copyable draft or instruction that a human can review before useRespect confidentiality, tenant permissions, sensitivity labels and data minimisation

Create my promptClear selection

Unlock your full prompt

Enter your email to view and copy it.

View my prompt

I have read and accept the Privacy Policy so Founderz can process my email and deliver this prompt.I would like to receive Founderz communications about training, resources and news. This is optional.

Your contact data is sent to Founderz when you unlock the prompt, in line with the Privacy Policy. Anonymous usage statistics only record selected options, never your description or generated prompt.

Your prompt is ready

Copy prompt and checklist
Discover the Microsoft 365 Copilot course

Your contact data is only sent to Founderz when you unlock the prompt with your email. Anonymous usage statistics record selected options, never your description or generated prompt. See the Privacy Policy.

How to use the free Copilot prompt generator for Excel

1. Pick a starting point: Fast work draft, Executive-ready version, Client-ready draft, Analysis and checks, Action plan or Review and improve. Each button fills in a sample brief and settings you can edit.
2. In “Brief or context”, describe your table, the columns it holds and the result you want. It is the only required field.
3. Set “Excel task”, “Authorised source material”, “Audience”, “Work stage”, “Output needed” and “Copilot surface”. If you leave “Auto / to be defined”, the prompt uses a safe default.
4. Under “Prompt quality and compatibility”, choose the depth level, the final output language and the material you will give Copilot. Open “Advanced settings” for data type, calculation handling, data quality checks, visual output, review and privacy.
5. Review the six quality controls (all on by default), select “Create my prompt”, enter your email and copy the prompt with its checklist.

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

For a typical formula case, the brief was “I have an orders table with date, customer, channel, revenue and cost. I want a new column that calculates margin as a percentage and highlights orders with a negative margin in red”, with Excel task: Explain formulas and assumptions. The generator returns this prompt (opening sections):

ACT AS: a senior Microsoft 365 Copilot specialist for Excel who designs safe, specific prompts around real files, selected content, permissions, review steps and human approval.

USER OBJECTIVE AND CONTEXT: I have an orders table with date, customer, channel, revenue and cost. I want a new column that calculates margin as a percentage and highlights orders with a negative margin in red.

SPECIFIC TASK: In Copilot for Excel, create a prompt for: Explain formulas and assumptions. Name the source material, define the expected output, specify checks, ask for missing context and leave the result ready for human review.

The full prompt continues with the options you selected, the depth level, language, work mode, seven instructions for the AI and the mandatory controls. Compared with “write me a margin formula”, it pins down columns, checks and review, so you end up with a custom prompt that Copilot gets right on the first try more often. Copilot is generative AI and, like every AI assistant, can still misread a table, so review what it creates.

Tips for better results

• Name the columns or the exact range in your brief, as Microsoft recommends in its Copilot in Excel tips, and phrase the brief as a goal rather than a command.
• Use plan mode before Copilot touches the workbook; chat mode analyzes your data without making changes.
• Turn off AutoSave when you want to experiment, because in edit mode Copilot changes the workbook directly.
• Ask Copilot to work on one column at a time and to test every formula, such as an XLOOKUP that finds a specific value or a VLOOKUP, on three or four sample rows. If the first answer misses, add detail in a follow-up question.
• To optimize the result, change one setting at a time between versions. For a simple task, the essential depth level is enough.
• Save the prompts that work in Copilot Prompt Gallery to reuse them with your team; it also holds prompts for Microsoft Copilot suggested by Microsoft.

Use cases: from data cleaning to data analysis with AI

The “Excel task” 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.

Why I built these generators

I built these generators because I kept seeing people get generic answers from AI when their prompts were vague. I’m Paul Delaney, I’ve been writing AI prompts since the GPT-2 era, and I work at Founderz, a school that teaches people to use AI at work. So I put the structure I use myself into every generator: role, task, context, material, constraints and format. You add what you know about your spreadsheet, and the generator puts it in order so Copilot doesn’t have to guess.

Frequently asked questions

Is this Copilot prompt generator for Excel free?

Yes. You can create as many prompts as you like at no cost. The tool builds the prompt in your browser and asks for your email and privacy policy consent before it shows the result. Receiving Founderz communications is optional and has its own checkbox.

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 the source table or range, the data type, calculation handling and data quality checks, 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 the generator can also target Microsoft 365 Copilot Chat. 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 generator also adds a control that tells Copilot not to modify raw data without your confirmation. If an answer is wrong, send feedback with the thumbs icons in the Copilot pane.

The Copilot prompt generator helps you start; the skill comes from using it on your own data. The Microsoft Copilot training from Founderz is fully online, comes with Microsoft and Founderz certification, and teaches you to apply Copilot across Microsoft 365, from prompting to advanced workflows.