Microsoft 365 Insider Blog Unveils COPILOT Function: Next-Generation AI for Excel

The Microsoft 365 Insider blog announced a groundbreaking addition to Microsoft Excel on Windows and Mac: the new COPILOT function. This function brings the full power of large language models (LLMs)—the same technology behind Microsoft Copilot—directly into Excel’s grid, allowing users to harness generative AI capabilities instantly within their spreadsheets. This innovation is now available to Microsoft 365 Insider Beta Channel users, marking a major leap forward in productivity and data analysis for individuals and organizations alike.

What Is the Excel COPILOT Function?

The COPILOT function is a new, optional Excel formula designed to reduce the time, effort, and technical know-how needed to perform complex, text-driven tasks and data analyses. With a simple formula, users can generate summaries, analyze sentiment, brainstorm ideas, and categorize information—all using natural language directly in their spreadsheet.

How It Works

To use the function, simply type a natural language prompt into Excel:

• prompt_part: The task or question you want AI to answer.

• context (optional): References to spreadsheet cells or ranges to provide data context for the AI.

Example: Want to classify survey feedback by sentiment?

The COPILOT function reads the selected range and returns AI-generated classifications—updating results automatically if data changes. Because it’s built into Excel’s calculation engine, there’s no need for refreshes or external scripts.

Excel’s COPILOT Function: AI for Everyday Data Tasks

The COPILOT function is more than just a novelty; it’s designed to unlock new levels of efficiency:

• Idea Generation: Instantly brainstorm product features, campaign strategies, or SEO keywords by feeding descriptions and prompts directly into your spreadsheet.

• Summarization: Transform large text ranges or dense datasets into plain-language summaries or narrative reports, great for presentations and executive briefings.

• Categorization & Tagging: Quickly classify customer feedback, support tickets, or survey responses—no need for manual sorting or exporting to other platforms.

• Automated Lists and Tables: Generate spillable, structured outputs for test datasets, inventory lists, or project timelines.

• Formula Integration: Seamlessly combine COPILOT with other Excel functions like IF, SWITCH, LAMBDA, or WRAPROWS for advanced, logic-driven workflows.

Tips for Best Results

• Clarity is Key: The more specific your prompts (including cell/range references, output format, or style), the more accurate and useful your results.

• Direct Action Words: Use instructions like “summarize,” “categorize,” or “generate list” for focused outcomes.

• Integration with Data: While COPILOT can’t access live web or internal business data directly, you can paste or import data into your workbook and reference it.

• Review AI Results: Always double-check AI-generated output for accuracy, especially when making critical decisions.

Privacy, Model Details & Limits

Microsoft emphasizes that data used in the COPILOT function remains confidential and is not used to train AI models. Your information is solely leveraged to generate your requested outputs.

• Up to 100 COPILOT calls per 10 minutes and 300 per hour are supported per user.

• Larger arrays and single formulas referencing big ranges count as one call, while dragging across cells counts as multiple.

• Live web data integration and improved date formatting are planned for future updates.

How to Access the COPILOT Function in Excel

The COPILOT function is rolling out now to eligible users:

• Windows: Excel Version 2509 (Build 19212.20000) or later

• Mac: Excel Version 16.101 (Build 25081334) or later

• Web: Coming soon via the Frontier program

Requirements:

• A Microsoft 365 Copilot license

• Enrollment in the Microsoft 365 Insider Beta Channel

To participate and get early access to features like COPILOT, users can join the Microsoft 365 Insider program.

What’s Next for AI in Excel: Upcoming Improvements

The Excel team is actively improving the COPILOT function based on community feedback. Planned enhancements include:

• Better support for large arrays and more complex datasets.

• Ongoing upgrades to the underlying AI model for improved results.

• Enhanced user guidance for unsuitable tasks, improving error messaging.

• Improved date handling and future integration with live web/business data.

The COPILOT function builds on the LABS.GENERATIVEAI experiment from Excel Labs, now offering more refined and scalable AI features.

How to Give Feedback

Microsoft invites all users to share feedback directly from Excel via the “AI-generated” pop-up (thumbs up or down). This feedback will help shape future features and improvements to the COPILOT function.

Transforming Excel Workflows with Built-In AI

The COPILOT function in Excel is a major milestone in making AI truly accessible for everyday spreadsheet users and power analysts alike. By allowing data-driven insights, text analysis, and content generation right from the grid, Excel users can now work faster and smarter. As this feature evolves, Microsoft 365 Insider members are at the forefront of trying out and shaping the future of AI in productivity tools.

To learn more about Microsoft 365 Insider, feature rollouts, and how to sign up, visit the Microsoft 365 Insider site.

If you want to see ongoing updates about the COPILOT function or other Microsoft 365 Insider features, be sure to sign up for the Microsoft 365 Insider newsletter and visit the official Microsoft Support Community for troubleshooting and peer advice.