Supported Versions & Security

• Availability: Available to Microsoft 365 Copilot users in the Insider Beta Channel (Windows 2509+ and Mac 16.101+). It is also planned to roll out to the web (Frontier). :contentReference[oaicite:1]{index=1}
• Predecessor: The official successor concept to the experimental LABS.GENERATIVEAI feature in Excel Labs. :contentReference[oaicite:2]{index=2}
• Data access: No direct access to web or internal company resources—it analyzes workbook ranges only. :contentReference[oaicite:3]{index=3}
• Usage limits: 100 calls per 10 minutes and 300 calls per hour, with planned increases. :contentReference[oaicite:4]{index=4}

Syntax & Quick Start

=COPILOT(prompt_part1, [context1], [prompt_part2], [context2], ...) — A prompt_part is instructional text, and context is an optional cell or range reference. Results may spill. :contentReference[oaicite:5]{index=5}

Examples

=COPILOT("Classify each comment as Positive/Negative and return a two-column table with Comment and Label",
         D4:D100,
         "Make headers: Comment, Label")

=COPILOT("Summarize these rows into 3 bullet points focusing on 'complaint types'",
         B2:B200)

=COPILOT("Create a table of top 10 keywords with counts; headers: Keyword, Count; sort by Count desc",
         A2:A500)

10 Practical Examples

1) Sentiment Classification for Customer Feedback

=COPILOT("Label each as Positive, Neutral, or Negative. Return a table with Comment, Sentiment", F2:F300)

2) Summarize Product Reviews (3 Lines)

=COPILOT("Summarize to 3 bullet points focusing on quality, delivery, price", H2:H500)

3) Create Dummy Data for Testing

=COPILOT("Generate 20 example rows: Name, Email, City, Score (0-100). Make a table with headers")

4) Brainstorm Work Ideas

=COPILOT("Give 10 blog title ideas about Excel dynamic arrays tailored for beginners")

5) Assign Categories Based on Rules

=COPILOT("Categorize into: Shipping, Quality, Pricing, Service. If none match, use 'Other'. Return two columns",
         A2:A200)

6) Refine a Report Introduction (Change the Tone)

=COPILOT("Rewrite the paragraph in a formal tone (1-2 sentences)", C2)

7) Generate Table Headers Automatically

=COPILOT("Propose column headers for this raw list", A2:A50)

8) Suggest Issue Priorities

=COPILOT("Rank these issues by impact and urgency. Return a table with Issue, Impact(1-5), Urgency(1-5), Priority",
         D2:D60)

9) Group and Summarize Duplicate Feedback

=COPILOT("Group similar comments and provide a one-line summary for each group",
         F2:F300)

10) Explain Data in Plain English

=COPILOT("Explain what this table shows in 2 sentences for a non-technical audience",
         A1:F30)

Combining It with Existing Functions

According to the official documentation, =COPILOT results can be used naturally with existing formulas, and you can also incorporate the results of other formulas into a prompt. :contentReference[oaicite:6]{index=6}

Arrange Cards with IF + WRAPROWS

=WRAPROWS(COPILOT("List 12 action items as short phrases"), 3, "")

Standardize Model Response Labels with SWITCH

=SWITCH(COPILOT("Return 'Positive' or 'Negative' for each comment", F2:F50),
 "pos","Positive","positive","Positive","neg","Negative","negative","Negative","Unknown")

Create a Standard Internal Prompt with LAMBDA

=LAMBDA(rng, COPILOT("Summarize in 3 bullets for weekly report", rng))(B2:B200)

Governance and Reproducibility Checklist

• Do not include sensitive information in context; use only the minimum necessary data. The data is not used to train the model, but reviewing results is essential. :contentReference[oaicite:7]{index=7}
• Reproducibility: For a final report, lock results with Copy → Paste Special → Values to prevent changes caused by automatic calculation. In official documents, record the prompt and data range in a caption.
• Call management: Process large ranges in a single call to conserve usage limits, and avoid unnecessary fill-down operations. :contentReference[oaicite:8]{index=8}
• Model limitations: It cannot directly access web or organizational data. Import the required data into the workbook first, then reference it. :contentReference[oaicite:9]{index=9}
• Avoid confusion: This is separate from the =PY function (which runs Python) and Excel Labs’ LABS.GENERATIVEAI. Use each feature according to its purpose. :contentReference[oaicite:10]{index=10}

Frequently Asked Questions

Q1. What is the difference between the Copilot pane (side panel) and the =COPILOT function?

The side panel is a conversational assistant that helps with tasks such as generating formulas and providing insights. Because =COPILOT is a formula, it can spill results, recalculate, and be combined with other functions in cells. :contentReference[oaicite:11]{index=11}

Q2. What will users outside the Beta Channel see?

In environments that do not support the function, errors such as #NAME? may appear. Share results after pasting them as values. :contentReference[oaicite:12]{index=12}

Q3. What if dates are returned as text?

Dates may currently be returned as text, and this is stated to be planned for future improvement. If needed, convert them with DATEVALUE or a similar function. :contentReference[oaicite:13]{index=13}