"Microsoft Excel Copilot Review 2026: Spreadsheets That Write Their Own Formulas"
Microsoft 365 Copilot brings an LLM into Excel. Describe what you want — ‘show me monthly revenue by region as a chart’ — and it writes the formula, builds the pivot, or generates a narrative summary of trends in your data.
How it works#
Copilot reads your table, suggests columns, cleans data, writes complex formulas (XLOOKUP, dynamic arrays) and creates visualisations. ‘Copilot in Excel’ can also score leads, categorise text and answer questions about the sheet in chat. It respects your existing data model and permissions.
Strengths#
- Plain-English formula and chart generation
- Cleans and categorises data automatically
- Deeply integrated with Microsoft 365
- Explains the formulas it writes
- Enterprise governance and security
Weaknesses#
- Requires a Microsoft 365 Copilot license (pricey)
- Works best on tidy, structured tables
- Occasional wrong formulas need review
- Not available in standalone Excel
Pricing#
-
M365 Copilot — $30/user/mo: Across Word, Excel, Outlook, etc.
-
Excel alone — part of M365: Copilot needs the add-on license
Verdict#
Excel Copilot is the easiest on-ramp to real analysis for non-analysts already in Microsoft 365. For a lighter formula helper, see Formula Bot.
FAQ#
Q: Do I need a special license?
Yes, Microsoft 365 Copilot is a paid add-on per user.
Q: Can it write any formula?
It handles common and advanced formulas but you should verify edge cases.
Q: Does it work on messy data?
It helps clean it, but structured tables give far better results.