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 Entra ID: Risk-based anti-bot verification (CAPTCHA) for SMS and voice multi-factor authentication
Starting mid-November 2026, Microsoft Entra ID will add risk-based CAPTCHA verification for SMS and voice MFA to prevent automated fraud. Some...
[Outlook for iOS and Android] Copilot Chat in Outlook UX improvements
Copilot Chat in Outlook for iOS and Android is being updated with a refreshed, consistent design across Microsoft 365 apps, improved chat inte...
Microsoft Word: Retirement of legacy compatibility settings
Microsoft Word will retire legacy compatibility settings for documents in Compatibility Mode starting December 2026 (Windows) and early 2027 (...
Power Platform – Information regarding the end of support for SharePoint temporary authentication URLs
Starting April 1, 2027, SharePoint temporary authentication URLs will be retired. Power Apps and Automate functionality that relies on these U...
Windows Office Hours: November 19, 2026
If you are an IT admin with questions about managing and updating Windows, we want to help. Every third Thursday of the month, we host a live ...
Scheduled prompts in Microsoft 365 Copilot are moving to native Copilot scheduling and the Tasks view
Microsoft 365 Copilot is moving scheduled prompts from Power Platform to native Copilot scheduling, enabling automatic execution of one-time o...
Prevent issues with NetApp SMB shares: Learn about new Windows Server security requirements
Microsoft introduced additional security requirements for LDAP authentication on Active Directory domain controllers starting with the October...
60-day reminder: Hardening changes for ReFS volumes on removable media
Microsoft is making hardening changes to the Resilient File System (ReFS). The changes improve the security posture of Windows by adding visib...
Microsoft 365 Copilot: Copilot Workspaces is replacing standalone agent selection with agentic chat
Microsoft 365 Copilot Workspaces will replace standalone agent selection (Researcher, Analyst, Designer) with an agentic chat that applies ski...
Microsoft Teams: Updated recording and transcript access setting behavior for town halls and webinars
Microsoft Teams is updating the “Who has access to the recording or transcript” option for Events App town halls and webinars. It ...