Copilot in Excel: what works, what fails on spreadsheets

Copilot in Excel helps create and explain formulas, summarize data, and convert sample values into reusable calculations. On unstructured worksheets, older file formats, and tasks with legal or financial implications, the function reaches clear limitations that Microsoft itself names. Anyone who wants to use Copilot in Excel productively needs an appropriate license, a file in .xlsx or .xlsm format with automatic calculation, and the willingness to review each result before adopting it. Status: August 2026.

Which license do you need for Copilot in Excel?

Copilot in Excel is tied to one of four licensing options that Microsoft names in the official FAQ for Copilot in Excel. These include a Microsoft 365 Personal or Family subscription with an AI credit plan, a Microsoft 365 Premium subscription, a commercial Microsoft 365 Copilot subscription, and a business or Enterprise license for Microsoft 365 or Office 365 that is enabled for Copilot Chat. Which variant is active in your own tenant can be checked in the account settings of Microsoft 365. Organizations without an existing Copilot licensing strategy should clarify actual use cases before deployment rather than defaulting to the most expensive tier.

How does Copilot generate formulas from plain text?

Copilot generates formulas by having you select a cell or range and describe in natural language what should be calculated, such as "Add a column that calculates the profit margin per product" or "Calculate the percentage increase from cell A1 to B1". Based on this, Copilot builds, among other things, formula columns, individual cell formulas with explanations, and lookup formulas with functions such as XLOOKUP, as Microsoft describes in its formula generation guide. Microsoft explicitly points out there: As with any AI-generated content, you should review, edit, and verify what Copilot creates before using it.

What requirements must the Excel file meet?

Copilot in Excel only works with files in modern .xlsx or .xlsm format, not with the older Strict Open XML format. In addition, the calculation option in Excel must be set to "Automatic," otherwise Copilot will not make changes to the workbook. From practice, it is also reported that Copilot works reliably especially on well-structured ranges and more frequently reaches limitations with very large or unclear worksheets. Cleanly formatted tables with clear column headers are therefore not optional but the prerequisite for usable results.

What are the limits of Copilot in Excel?

Microsoft limits the scope itself: Copilot in Excel should not be used for tasks with legal, regulatory, or compliance implications and is not intended for financial, legal, or medical decisions. The model was trained primarily on English-language sources. While Copilot supports more than 30 languages, including German, the quality may be weaker in languages other than English. Important for team collaboration: Once a file is saved, everyone with access to the file can see the changes made by Copilot. Anyone who wants to integrate Copilot specifically into reporting or automation processes should do so as part of a structured AI consulting plan rather than releasing the feature uncontrolled across the entire team.

Frequently asked questions about Copilot in Excel

Do I need an expensive subscription to use Copilot in Excel?

It depends on the access. A Microsoft 365 Personal or Family subscription with an AI credit plan is sufficient for private entry, but organizations need a Premium or Copilot-enabled Business subscription instead. Which license is already available in your own tenant is shown in the Microsoft 365 account settings.

Can I rely on the formulas generated by Copilot?

No, not without review. Microsoft explicitly points out that you should review, edit, and verify any AI-generated result before adopting it, as Copilot, like any AI model, can produce incorrect or inaccurate results.

Does Copilot in Excel work in German too?

Yes, Copilot supports more than 30 languages including German. Since the underlying model was trained primarily on English-language content, the quality of suggestions in German may fall somewhat short of the English version.

Can my colleagues see what Copilot changed in my spreadsheet?

Yes. Once the file is saved, the changes are visible to everyone who has access to the file. You should know this when working with sensitive or shared workbooks before letting Copilot make major changes.