Microsoft Excel Tutorial: Excel Clean Data with Copilot
Microsoft Excel just introduced the Clean Data feature in Win32, bringing AI-powered data cleaning straight to the desktop! This tool, previously available in Excel Online since October 2024, promises to detect and fix inconsistencies in your dataset—like inconsistent text, formatting issues, and more. But does it really work as expected?
In this episode, I put Clean Data to the test with a variety of messy datasets. It does well in some areas, like recognizing spelling variations and fixing number formats. However, it struggles with company name inconsistencies, date issues, and partial data cleaning—sometimes catching errors and sometimes missing them entirely. Why the inconsistency? And what does Excel’s AI need to improve?
Here’s what you’ll learn in this video:
How to use the Clean Data feature in Excel
What types of data errors it catches—and what it misses
Limitations with inconsistent text, date formats, and company names
Why AutoSave is required (but not well-documented)
Thoughts on how this feature can improve in future updates
Subscribe for more Excel tips & deep dives.
Like & Comment if you’ve tried Clean Data—what’s your experience?
#Excel #Microsoft365 #ExcelTips #ExcelCopilot #DataCleaning #CleanData #Spreadsheet
To download the workbook from today: https://www.mrexcel.com/youtube/swvBTKHPigI/
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
Table of Contents
(0:00) Take Seven
(0:15) AI Temperature
(0:33) Data Size Limits
(0:53) Inconsistent Text Results
(1:18) SWA and Southwest Airlines
(1:32) Variability of results
(1:53) Walmart variations
(2:04) 3 Decades of Marriage
(2:20) Text numbers but not Text dates
(2:53) Ambigious Matches
(3:10) Airline Codes
(3:36) Valid date with apostrophe
(3:56) Inconsistency is frustrating
(4:16) Blog says it will improve
(4:29) Wrap-up
This video answers these common search terms:
Excel Clean Data feature
How to clean data in Excel
Excel Copilot Clean Data
Microsoft Excel data cleaning tool
Fix inconsistent data in Excel
AI-powered data cleaning in Excel
Excel Copilot AI data cleanup
Best way to clean messy data in Excel
New Excel features 2025
Microsoft 365 Excel AI tools