Microsoft Copilot in Excel is an AI assistant built directly into your spreadsheet. It helps you analyze data, write formulas, create charts, and clean up messy information without needing to be an Excel expert.
You activate it, describe what you want in plain English, and it does the work.
What Is Copilot in Excel?
Copilot is Microsoft’s AI tool powered by large language models. In Excel, it sits inside your ribbon and understands your data. You talk to it like a person and it responds with formulas, summaries, charts, or filtered views.
It does not replace your skills. It speeds them up.
What You Need Before You Start
Before Copilot works in Excel, check these requirements:
- A Microsoft 365 Personal, Family, or Business subscription (Copilot is included in Microsoft 365 Copilot plans)
- Excel for Windows or Mac (desktop app) or Excel on the web
- Your file must be saved to OneDrive or SharePoint (local files may not support all Copilot features)
- Your data should be formatted as a proper Excel Table (Copilot works best with structured tables)
If you are on a basic Microsoft 365 plan without the Copilot add-on, you may need to upgrade. Microsoft has been expanding access throughout 2025 and 2026, so check your admin center or account settings.
How to Open Copilot in Excel
Opening Copilot is straightforward.
Step 1: Open your Excel file (saved to OneDrive or SharePoint).
Step 2: Click the Home tab in the ribbon.
Step 3: Look for the Copilot button on the right side of the ribbon. It has a colorful sparkle icon.
Step 4: Click it. A chat panel opens on the right side of your screen.
Step 5: Type your request in the chat box at the bottom of that panel.
That is it. The panel stays open as you work, and you can keep asking questions or giving it new instructions.
Format Your Data as a Table First
Copilot performs much better when your data is an Excel Table, not just a plain range.
To convert your data:
- Click anywhere inside your data range
- Press Ctrl + T (Windows) or Cmd + T (Mac)
- Check “My table has headers” if your first row has column names
- Click OK
Now Copilot can reference your columns by name and understand your data structure properly.
Core Things You Can Do With Copilot in Excel
Here is what Copilot actually does well in day-to-day use.
1. Writing Formulas
This is one of the most useful features, especially if you struggle with complex formulas.
Example prompts you can type:
- “Write a formula to calculate the total sales for January”
- “Create a formula that shows the average order value where the region is North”
- “Write a VLOOKUP that matches customer ID in column A with the price list on Sheet2”
Copilot writes the formula, explains what it does, and offers to insert it into your sheet. You can accept or modify it.
This saves significant time on nested formulas like INDEX/MATCH, XLOOKUP, or SUMIFS.
2. Analyzing and Summarizing Data
If you have hundreds or thousands of rows, Copilot can pull insights without you building a pivot table manually.
Try these prompts:
- “What are the top 5 products by revenue?”
- “Summarize the trends in this data”
- “Which region had the lowest performance last quarter?”
Copilot reads your table and gives you a text summary or a suggested chart. It can also highlight the relevant rows so you can see the data behind the insight.
3. Creating Charts and Visuals
You do not need to manually insert and configure charts.
Ask Copilot:
- “Create a bar chart showing monthly sales”
- “Show me a line chart comparing 2024 and 2025 revenue”
- “Add a pie chart for product category breakdown”
It builds the chart and places it on your sheet. You can then move it, resize it, or ask Copilot to change the chart type.
4. Sorting and Filtering Data
Instead of clicking through menus, describe what you want.
Examples:
- “Filter the table to show only orders above $500”
- “Sort by date, newest first”
- “Show only rows where the status is Pending”
Copilot applies the filter or sort directly. This is especially handy when you are working with large datasets and do not want to hunt through filter dropdowns.
5. Adding and Explaining Columns
You can ask Copilot to add a new calculated column to your table.
Prompts like:
- “Add a column that shows profit margin as a percentage”
- “Create a column that flags orders as High, Medium, or Low based on value”
- “Add a column showing whether the delivery was on time based on the expected and actual date columns”
Copilot writes the formula for the new column and adds it to your table. It also explains what the formula does so you can understand and modify it later.
6. Conditional Formatting
Highlight patterns without digging through menus.
- “Highlight cells in the sales column that are below the average”
- “Color code the status column: green for Complete, red for Overdue, yellow for In Progress”
- “Bold the top 10% of values in the revenue column”
Copilot applies the formatting rules. This turns raw data into something visually readable in seconds.
7. Cleaning Data
Messy data is a common problem. Copilot can help fix it.
- “Remove duplicate rows”
- “Trim extra spaces from the customer name column”
- “Standardize the date format in column C to DD/MM/YYYY”
- “Replace all blank cells in the region column with Unknown”
These are tasks that normally require formulas or manual editing. Copilot handles them in one step.
A Step-by-Step Workflow Example
Let us say you have a sales report with 800 rows. Here is how to use Copilot to get real value from it quickly.
Step 1: Convert your data to an Excel Table (Ctrl + T).
Step 2: Open Copilot from the Home ribbon.
Step 3: Type: “Summarize the key trends in this data.”
Copilot gives you a brief written summary of what it sees.
Step 4: Ask: “Which sales rep had the highest total revenue?”
Copilot answers with the name and figure.
Step 5: Ask: “Create a bar chart comparing revenue by region.”
A chart appears on your sheet.
Step 6: Ask: “Add a column showing each rep’s percentage of total revenue.”
Copilot adds a new column with the formula.
Step 7: Ask: “Highlight the top 10 rows by revenue in green.”
Conditional formatting is applied.
You just did in 5 minutes what would normally take 30+.
Tips for Writing Better Copilot Prompts
The quality of your results depends heavily on how you phrase your requests.
| Weak Prompt | Better Prompt |
|---|---|
| “Analyze this” | “Summarize the monthly revenue trend for 2025” |
| “Make a chart” | “Create a line chart showing sales by month for each region” |
| “Fix the data” | “Remove duplicate rows and trim spaces in the Name column” |
| “Write a formula” | “Write a formula that calculates the total sales where category equals Electronics” |
| “Sort it” | “Sort the table by Order Date, from oldest to newest” |
Key habits:
- Use the actual column names from your table
- Be specific about what output you want
- If the first result is not right, rephrase and try again
- Ask follow-up questions to refine the output
What Copilot in Excel Cannot Do (Yet)
Copilot is powerful but it has limits. Knowing them saves you frustration.
- It cannot run macros or write VBA code (at least not in the standard Excel Copilot interface)
- It works best with structured tables, not freeform layouts
- It may struggle with very complex multi-sheet references
- It cannot access external data sources unless they are already loaded into your sheet
- Results are not always perfect on the first try, especially for advanced formulas
For VBA and automation, Microsoft is building Copilot features into that area separately. For now, treat Copilot as a data analyst, not a developer.
Copilot in Excel vs. Doing It Manually
| Task | Manual Time (approx.) | With Copilot |
|---|---|---|
| Writing a SUMIFS formula | 5 to 10 min | Under 30 seconds |
| Building a pivot table | 10 to 15 min | 1 to 2 min |
| Creating a chart with labels | 5 to 8 min | Under 1 min |
| Cleaning duplicates in a large table | 10 to 20 min | Under 1 min |
| Summarizing trends from 1000 rows | 30+ min | 1 to 2 min |
The time savings are real, especially for users who do not use Excel daily.
Privacy and Data Considerations
A fair question: does Copilot send your data to Microsoft?
Yes, your data is processed by Microsoft’s AI services when you use Copilot. If you are working with sensitive or confidential data, check your organization’s Microsoft 365 data governance policies before using Copilot.
Microsoft does have enterprise data protection commitments, but each organization manages its own settings. Your IT administrator controls whether Copilot is enabled and what data handling rules apply.
For personal use with non-sensitive data, this is generally fine. For business use, verify with your IT or compliance team first.
You can learn more about Microsoft’s data handling approach on the Microsoft Trust Center.
How Copilot Fits Into Your Excel Skill Development
Some people worry that using AI tools means they stop learning Excel. That is not really how it works in practice.
When Copilot writes a formula for you, it explains it. Reading that explanation teaches you the logic. Over time, you start recognizing patterns and understanding how formulas work, even if you did not write them yourself.
Use Copilot as a learning aid, not a crutch. When it gives you a formula, read it. Try to understand what each part does. That builds skill faster than tutorials in many cases because it is applied to your actual data.
Conclusion
Copilot in Excel is one of the most practical AI tools available right now. It works directly with your real data, understands plain English, and handles tasks that used to require deep Excel knowledge or a lot of time.
The best way to use it: format your data as a proper table, open the Copilot panel, and start asking specific questions. You will get comfortable with it fast.
Start with something small. Ask it to summarize your data or write one formula. Once you see how it responds, you will naturally find more ways to use it across your work.
Frequently Asked Questions
Is Copilot in Excel free?
Copilot in Excel is not included in the free version of Excel or basic Microsoft 365 plans. You need a Microsoft 365 Copilot license, which is either bundled with certain Microsoft 365 plans or available as an add-on. Pricing changes regularly, so check Microsoft’s current pricing page for your region.
Why is the Copilot button not showing in my Excel?
The most common reasons are: your Microsoft 365 plan does not include Copilot, your Excel app is not updated to the latest version, your file is saved locally instead of OneDrive or SharePoint, or your organization’s IT admin has disabled the feature. Update Excel, save the file to OneDrive, and check your subscription.
Does Copilot work on Excel for Mac?
Yes, Copilot works on Excel for Mac, provided you have the right Microsoft 365 subscription and your app is updated. The feature set is largely the same as Windows, though occasionally some features roll out to Windows first before coming to Mac.
Can Copilot handle large datasets?
Copilot works with large datasets but performance can vary. It reads your table structure and column names efficiently. Very large files with tens of thousands of rows may take a few seconds longer to process. Keeping your data in a clean, properly structured Excel Table improves results significantly.
Is Copilot in Excel the same as ChatGPT?
Both use large language models, but they are different tools. Copilot in Excel is embedded in your spreadsheet and has direct access to your table data. ChatGPT requires you to copy and paste data manually and cannot directly modify your Excel file. Copilot is purpose-built for spreadsheet tasks, which makes it more practical for Excel-specific work.
