If you think you need a premium Copilot subscription to get AI-powered insights from Excel, think again. Before paying for another monthly add-on, check your toolbar—Excel already includes a built-in analysis tool that handles many advanced spreadsheet tasks without the extra fee.
Tucked away inside your standard Microsoft 365 workspace is Analyze Data (previously Ideas). This integrated assistant builds charts, summarizes trends, and answers questions about your spreadsheet using tools you already have.
Microsoft wants you to forget about Excel’s native features
Every time you open Excel, Microsoft practically begs you to care about its premium AI capabilities. In fact, Microsoft has been integrating Copilot into Microsoft 365 plans, and in some cases, this has led to price increases. If you want to keep your monthly bill low, you may be able to manually downgrade to a Microsoft 365 Classic subscription. This allows you to revert to a lower-cost plan that strips away the default Copilot integrations while keeping your core Office applications intact.
Either way, you don’t need the expensive default tier upgrade to get intelligent data assistance. Sitting right on your toolbar is Analyze Data, which is included with eligible Microsoft 365 subscriptions and doesn’t require a Copilot add-on. It automatically parses your dataset, identifies patterns, and serves up instant visual summaries without costing you an extra dime.
The AI delusion: Why Copilot won’t clean up a messy Excel spreadsheet
Automation can’t compensate for broken logic, inconsistent formatting, or a lack of a foundational data model in Excel.
It feels like it’s doing what it’s supposed to
When I first tested Copilot in Excel, the friction was immediate. You click an icon, watch a “loading” animation spin, and wait for a massive cloud server to parse your request. If your internet stutters, the assistant stalls completely. It feels like an external plugin bolted onto the program rather than a cohesive part of the experience.
Excel’s native Analyze Data tool is also cloud-connected, but because it avoids a chatty, conversational interface, it feels more direct for focused spreadsheet work. Once it has done its analysis, it populates your sidebar with actually useful information.
Getting this tool running requires absolutely no setup. Depending on your version of Excel, the entire process takes only a few clicks:
- Select any single cell within your active data range.
- In the Data tab, click Analyze Data. In some versions of Excel, this button is located in the Home tab.
- Review the pre-generated visual cards that automatically populate the task pane on the right.
- Click the Insert button on any insight card to add the graphic to your sheet.
- Alternatively, use the query box or list of suggested questions to refine your results.
Click and drag the header of the Analyze Data pane to move it to a different position on your screen. You can also click and drag the edges to resize it for easier readability.
Once inserted, charts based on tables or dynamic ranges update as your data changes, and linked PivotTables and PivotCharts re-sync when you click Refresh All in the Data tab.
The sidebar cards themselves are even more dynamic. If you tweak values in your sheet while the pane is open, Excel temporarily pauses the analysis to avoid data conflicts while you are actively making changes. The moment you finish modifying your cells, the tool automatically updates and refreshes the analytical cards in your feed.
Disclaimer: Analyze Data won’t replace advanced automation tools or full AI coding workflows. But if your goal is to parse data, spot trends, and generate clean visuals without a premium overhead or the pleasantries of a chatbot, it does the core work.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.
Talk to your spreadsheet in plain English
Natural language queries replace complex formulas
The worst part of managing a complex Excel spreadsheet is racking your brain for exact formula syntax. One misplaced comma or mismatched parenthesis can break an entire sheet. While premium AI assistants market natural language processing as a revolutionary upgrade, Excel’s integrated side pane has been translating words into working data structures for quite some time.
At the time of writing (May 2026), Analyze Data is available to Microsoft 365 subscribers in English, French, Spanish, German, Simplified Chinese, and Japanese.
But it’s vital to understand that this interface is not a conversational chatbot. You can’t argue with it, give it multistep creative instructions, or ask linked follow-up questions to drill down into a chat thread. Instead, the query box at the top of the interface functions as a single-query input for structured results. Clicking inside it reveals a drop-down list of tailored questions based on your existing columns, or you can type a question just as you would phrase it to a coworker.
Entering queries like “Which product line generated the most revenue?” or “Show total sales by region” prompts the system to interpret your intent on the spot. It translates your single plain-English phrase, builds a dedicated visual response card, and lets you insert a fully functional PivotTable or chart without writing a single manual formula. If you want to ask something else, you simply clear the text bar and type a fresh query.
Avoid common traps to keep the engine running
As useful as this built-in engine is, it has some limitations. But don’t worry—they’re mostly straightforward to overcome:
- You need an internet connection: Because Analyze Data uses cloud-connected services to interpret your data patterns, an active internet connection is required to process your requests.
- Your data must be structured: Analyze Data relies on well-structured data. The best way to achieve this is to remove blank rows and columns, add a single header row to the top, and convert your data into an Excel table (Ctrl+T).
- Convert dates stored as text: If your dates are stored as plain text strings (like “2026-01-01”), Excel may not interpret them chronologically. To fix this, convert the column using the DATE or DATEVALUE functions.
- It won’t work with legacy formats: The tool may appear grayed out if your workbook is in an older legacy format. Your file must be saved as a modern XLSX, XLSM, or XLSB file.
- Avoid merging cells: Merged cells can interfere with Analyze Data, so it’s best to remove them and use the Center Across Selection alignment option instead.
Wrap up your workflow without the premium subscription
You don’t need to fork out for Copilot to get useful insights from Excel. Analyze Data already generates charts, surfaces trends, and answers spreadsheet questions using tools built into Microsoft 365. Before paying extra for premium upgrades, clicking through Excel’s menus to see what it already has to offer is one way to keep your workflow Copilot-free.
Stephan is the sports journalist for the Maple Grove Report.
