Can Copilot create Excel sheets?

Yes, Copilot can create Excel sheets: describe the workbook you want and Microsoft Copilot builds it for you, either through the Excel Agent in the Copilot app or with Copilot inside Excel itself.

As of November 17, 2026, according to Microsoft Support:

  • Excel Agent: in the Microsoft Copilot app (web, desktop or Teams), choose Excel from the Tools or Agents menu and enter a prompt such as “Set up a budget tracker with monthly sheets and summary charts.” The agent may ask clarifying questions, shows a preview and saves the finished file to your OneDrive. It requires a Microsoft 365 Copilot license.
  • Copilot in Excel: inside Excel, edit mode can add worksheets, generate data and formulas, and build charts, PivotTables, dashboards and templates from scratch. Edit, chat and plan modes work on Windows, Mac and the web, while mobile apps have fewer modes.
  • Access: if Copilot does not appear in Excel, your Microsoft 365 subscription or organization settings may not include it.

Review generated formulas and figures before you share the file.

Related: Can Copilot read Excel files?, Can Copilot make PowerPoints? and Can Gemini create Excel sheets?

Source: Microsoft Support, Get started with Word, Excel, and PowerPoint Agents in Microsoft Copilot and Microsoft Support, Get started with Copilot in Excel

Image: Microsoft Copilot wordmark by Microsoft, public domain, via Wikimedia Commons. Placed on a white background and resized. Copilot and Excel are trademarks of Microsoft. FreeAnswers is not affiliated with or endorsed by Microsoft.



Related answers

Leave a Comment