May 2025 Excel Update: AI Data Cleaning, Python Analysis & Enhanced Mac and Web Features

Posted by

Discover the May 2025 Excel update featuring six powerful new tools! From AI-driven data cleaning and Python-powered deep analysis to text sentiment insights and enhanced accessibility with voice responses. Mac and web users gain forms integration and extended change tracking. Boost your Excel productivity today! Unique :

What’s New in Excel: May 2025 Update

Microsoft just dropped the May 2025 Excel update, packed with AI-powered features to boost your productivity. From Windows to Mac and web, these enhancements make data handling smarter and faster.

Clean Data with Copilot on Windows

Excel’s AI-driven Clean Data tool now helps Windows users tidy up messy data with a single click. It spots inconsistent text, number formats, and extra spaces instantly. Just hit the Clean Data button in the Data tab or use the pop-up banner. This feature already shines on the web and is rolling out to Windows Current Channel users.

“Excel’s AI-based Clean Data feature enables the cleaning of data with only the touch of a button.”

Think Deeper with Python in Copilot

Across Windows, Mac, and web, Copilot now supports Python-powered deep analysis. It doesn’t just spit out answers—it creates detailed plans, runs Python code in a dedicated sheet, and explains each step. No coding skills needed! This is a game-changer for tackling complex data questions.

Text Analysis Made Easy

Pressed for time? Copilot can now analyze huge text datasets, detect sentiment, summarize themes, and even generate PivotTables or charts. It supports tens of thousands of rows, helping you uncover trends quickly and efficiently.

“Copilot can now quickly identify sentiments in text and summarize themes, providing sources for efficient validation.”

Hear Copilot Out Loud on Windows and Web

Multitasking just got easier. When chatting with Copilot, click the speaker icon to have responses read aloud. This feature improves accessibility and lets you keep your hands free while getting insights.

Forms Integration Comes to Mac

Mac users can now create and sync Microsoft Forms directly inside Excel workbooks. This feature was previously exclusive to Windows and web, making Mac a more seamless part of your workflow.

Extended Change History on Excel for Web

The “Show Changes” pane now tracks workbook edits for up to one year—up from just 60 days. This extended lineage helps you audit and understand your workbook’s evolution over time.

Why This Update Matters

Microsoft listens closely to user feedback, and these features reflect real-world needs. Whether cleaning data, diving deeper with Python, or analyzing text, Excel is becoming smarter and more user-friendly.

Stay ahead by subscribing to the Excel Blog and joining the Excel Community. As they say, “Your continued Feedback in Action (#FIA) helps improve Excel for everyone.”

  • AI-powered Clean Data tool fixes text inconsistencies, number formats, and extra spaces with one click.
  • “Think Deeper” in Copilot uses Python to generate detailed data analysis plans and execute code automatically.
  • Copilot now analyzes large text datasets, identifying sentiments and summarizing themes efficiently.
  • Excel for Mac users can create and sync Microsoft Forms directly within workbooks for seamless data collection.
  • Show Changes feature on Excel for web extends history tracking from 60 days to 1 year for better version control.
  • From the New blog articles in Microsoft Community Hub



    Related Posts
    Unlock New Possibilities with Windows Server Devices in Intune!

      Windows Server Devices Now Recognized as a New OS in Intune Microsoft has announced that Windows Server devices are Read more

    Unlock the Power of the Platform: Your Guide to Power Platform at Microsoft Ignite 2022

    Microsoft Power Platform is leading the way in AI-generated low-code app development. With the help of AI, users can quickly Read more

    Unlock the Power of Microsoft Intune with the 2210 October Edition!

    Microsoft Intune is an enterprise mobility management platform that helps organizations manage mobile devices, applications, and data. The October edition Read more

    Unlock the Power of Intune 2.211: What’s New for November!

    Microsoft Intune has released its November edition, featuring new updates to help IT admins better manage their organization’s mobile devices. Read more