Microsoft Excel: Summarize text columns and generate categories with Copilot
Microsoft 365 Copilot in Excel will automatically analyze unstructured text columns to generate categories and tags, aiding data analysis like survey responses. Rolling out worldwide mid to late July 2026, it requires no setup, affects licensed users, and maintains existing data compliance and controls. What and Why We are introducing a new Microsoft 365 Copilot capability in Excel that helps users analyze columns of unstructured text and automatically generate categories or tags for each entry. This feature helps users quickly identify themes and patterns in data such as survey responses or customer feedback, improving productivity and reducing manual analysis effort. Rollout Schedule General Availability (Worldwide): Rollout will begin in mid-July 2026 and is expected to complete by late July 2026. Impact on Your Organization Who is affected Users with a Microsoft 365 Copilot license using Excel Platforms and services Excel for Microsoft 365 Copilot in Excel What will happen: Copilot will analyze columns of unstructured text to identify themes and generate categories or tags for each entry. Users will be able to summarize and categorize content such as survey responses, customer feedback, or comments. The feature is available automatically to licensed users in environments where Microsoft 365 Copilot in Excel is enabled. No configuration or setup is required. There is no change to how customer data is stored, processed, or shared. Existing Microsoft 365 Copilot controls remain unchanged. View image in new tab Action Required or Recommendations No action is required. Consider the following: Inform users about this new capability and how it can support data analysis workflows. Update internal training or documentation if your organization provides guidance on using Excel or Copilot. Review existing Copilot controls if you want to manage feature access for users. Learn more: Edit with Copilot in Excel | Microsoft Support Compliance considerations This feature does not introduce new data storage, change how customer data is processed, or modify existing Microsoft 365 Copilot compliance controls. Message ID: MC1430543
The post Microsoft Excel: Summarize text columns and generate categories with Copilot appeared first on M365 Admin.
Published on:
Learn moreWe can help you with Microsoft Excel: Summarize text columns and generate categories with Copilot
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Related posts
Microsoft OneDrive and SharePoint: Generate smart tables of contents for PDFs on the web with Copilot
Microsoft 365 Copilot users can generate AI-created, hierarchical, clickable tables of contents for PDFs in OneDrive and SharePoint on the web...
Microsoft Defender for Office 365: Changes to Unified RBAC permission mapping for Microsoft Entra Security Operator role
Microsoft is updating Microsoft Defender for Office 365’s Unified RBAC mapping for the Microsoft Entra Security Operator role, removing ...
Microsoft 365 Copilot: new guided Copilot onboarding experience
Microsoft 365 Copilot introduces an optional, admin-enabled guided onboarding experience for Frontier participants starting late October 2026....
Microsoft Purview |Unified Classification Management Experience
Microsoft Purview is launching a unified Classification Management experience for admins to manage classifiers consistently. Public Preview st...
Microsoft Purview | Data Loss Prevention: Administrative Units support for DLP policies for Microsoft Copilot
Microsoft Purview extends Microsoft Entra Administrative Units support to Copilot DLP policies, enabling delegated management within units whi...
Action required: Update Teams devices to a minimum app version ahead of the retirement of Exchange Web Services (EWS)
Update Microsoft Teams Rooms on Android, phones, and panels to the minimum app version released in February 2026 before October 2026 to avoid ...
Microsoft Power Platform governance and administration – Secure Dataverse record with column-based filtering
We are announcing the ability for admins to use filtered views to select and manage record-level access securely by defining security based on...
Microsoft Teams: Impersonation Protection for Teams meetings
Impersonation Protection for Teams meetings helps users identify potentially deceptive participants and meeting organizers. When Teams detects...
Microsoft Copilot (Microsoft 365): Use Dataverse Business Skills in Sales Agent
Business Skills are natural language instructions authored and stored in Microsoft Dataverse that teach Sales Agent how work gets done within ...