#copilotfunction

TL;DR: Microsoft just launched the revolutionary COPILOT function in Excel, bringing AI directly into spreadsheet cells. This changes everything I recommended in my previous Copilot vs Claude comparison. While Claude still excels for complex Power Query work, Excel's new COPILOT function delivers the speed, flexibility, and native integration that transforms how we work with data - without requiring OneDrive auto-save. Just weeks after publishing my analysis of Copilot vs Claude for Excel formula building, Microsoft dropped a bombshell that fundamentally changes the AI-in-Excel landscape. The new COPILOT function isn't just an incremental update-it's a complete reimagining of how artificial intelligence integrates with spreadsheets. In my previous comparison, I noted that while Copilot offered seamless integration, its limitations around auto-save requirements, slower response times, and limited formula alternatives made Claude the superior choice for advanced users. The new COPILOT function addresses these concerns head-on while introducing capabilities that neither tool previously offered.0

What Makes the COPILOT Function Revolutionary

The COPILOT function transforms AI assistance from an external chat interface into a native Excel function that works just like VLOOKUP, SUMIF, or any other formula. Instead of asking Copilot to help you build a formula, you can now type AI prompts directly into cells and get instant results. Here's the basic syntax: =COPILOT(prompt_part1, , , , ...) But the real magic happens when you see it in action. Data Classification Made Effortless Remember spending hours categorizing expense reports or customer feedback? The COPILOT function handles this instantly. As demonstrated in Microsoft's announcement video, you can analyze credit card descriptions and automatically generate expense categories: =COPILOT("Analyze the credit card descriptions and come up with a short list of categories I can use to group the expenses", B2:B50) Within seconds, COPILOT scans your data and proposes relevant categories. The function is context-aware—it understands your business context and tailors its suggestions accordingly, even incorporating common business naming conventions and merchant categories. Data Generation and Content Creation One of the most impressive demonstrations shows COPILOT generating data it doesn't already have in your spreadsheet. You can ask it to create lists of companies in specific industries, generate marketing keywords based on product descriptions, or even brainstorm project ideas—all directly within Excel cells. For example, you might ask: "List the top 10 SaaS companies by revenue and their primary business focus." COPILOT pulls this information from its training data and creates structured output directly in your cells, something that previously required external research and manual data entry. Formula Explanations in Plain English The COPILOT function excels at demystifying complex formulas. Using the FORMULATEXT function, you can reference any formula in your spreadsheet and ask COPILOT to explain it in plain English: =COPILOT("Explain this formula in plain English", FORMULATEXT(D5)) This eliminates the guesswork when inheriting spreadsheets from colleagues or revisiting your own complex formulas months later. Data Analysis and Insights Perhaps most powerfully, COPILOT can analyze entire data ranges and provide intelligent summaries. Instead of manually scanning profit and loss statements, you can ask COPILOT to analyze the data and highlight key findings: =COPILOT("Analyze the profit and loss statement and give me a summary of notable points", A1:C20) The function uses TEXTJOIN and CHAR functions to format responses with proper line breaks, creating readable paragraph-style outputs that feel more like analyst reports than formula results. Data Cleaning Made Simple Data cleaning, historically one of the most tedious Excel tasks, becomes almost effortless. The demonstration shows COPILOT extracting ZIP codes from inconsistently formatted address data and then standardizing the formatting-tasks that typically require complex regex patterns or manual correction. Important Note for Regular Data Processing: While the COPILOT function excels at one-off data cleaning tasks, it's not the optimal solution for repeated data cleaning exercises. If you regularly receive external reports that need the same cleaning steps applied each month or quarter, Power Query remains the superior choice. Power Query allows you to build reusable data transformation workflows that can be refreshed with new data automatically. Use COPILOT for ad-hoc cleaning tasks and exploratory data work, but invest in Power Query solutions for recurring data processing workflows.

How This Changes My Previous Recommendations

Speed: The Game Changer In my previous analysis, I criticized Copilot for slow response times compared to Claude. The COPILOT function operates at the speed of Excel's calculation engine. When your data changes, results update automatically-just like any other Excel function. This represents a fundamental shift from the slower chat-based interface to instant, native performance. No More Auto-Save Requirements My biggest criticism of the original Copilot was its requirement for OneDrive auto-save, which forced a cloud-first workflow many users found restrictive. The COPILOT function works in any Excel file, whether stored locally, on network drives, or in the cloud. This addresses the primary concern that made Claude more appealing for users who prefer controlling their save workflows. Integration vs. External Tools While Claude still requires copying and pasting between applications, the COPILOT function brings AI capabilities directly into the spreadsheet grid. Results become part of your workbook, automatically update when source data changes, and can be referenced by other formulas. This level of integration was impossible with external AI tools. Best Practices for Interpretation, Not Precision Microsoft emphasizes an important limitation: the COPILOT function excels at interpretation, classification, and insights rather than precision mathematics. This aligns perfectly with how most users actually need AI assistance-for understanding data patterns, categorizing information, and generating insights rather than performing complex calculations.

Updated Recommendations: When to Use What

Choose the COPILOT Function When: Data classification tasks: Categorizing expenses, customer feedback, or survey responses Content generation: Creating lists, brainstorming ideas, or generating structured data Data analysis: Summarizing trends, highlighting key findings, or explaining patterns Formula explanations: Understanding complex formulas built by others Data cleaning: Extracting information from messy text or standardizing formats Working with files locally: When you prefer not to use OneDrive auto-save Choose Claude When: Power Query development: The COPILOT function doesn't work in Power Query editor Complex M code: Claude remains superior for data transformation scripting Multiple formula alternatives: When you want to see different approaches to the same problem Cross-platform work: When working across different applications beyond Excel Educational depth: When you need detailed explanations of Excel concepts and best practices Choose Traditional Copilot When: Conversational assistance: When you prefer chat-based interaction for guidance Template creation: For generating entire workbook structures and layouts Multi-step workflows: When you need guidance through complex multi-stage processes

Availability and Access: How to Get Started

The COPILOT function is currently rolling out to specific user groups with specific requirements: Current Availability (August 2025): Beta Channel users with Microsoft 365 Copilot licenses Windows: Version 2509 (Build 19212.20000) or later Mac: Version 16.101 (Build 25081334) or later Web version: Rolling out soon through Microsoft's Frontier program Usage Limits: 100 calls every 10 minutes Up to 300 calls per hour Single calls with larger data ranges count as one usage Dragging formulas across multiple cells counts as multiple calls Licensing Requirements: Microsoft 365 Copilot license (typically $30/user/month for business) OR Microsoft 365 Personal/Family subscription (Copilot now included as of January 2025) For business users, the COPILOT function requires the full Microsoft 365 Copilot license. However, as of January 2025, Microsoft included Copilot capabilities in Microsoft 365 Personal and Family subscriptions, making this functionality accessible to individual users through a monthly AI credit system.

The Bottom Line: A New Era for Excel