Clean up your data with Copilot in Excel
Applies To
Note: If you don’t see Copilot in Word, Excel, PowerPoint, or OneNote, it might not be included with your Microsoft 365 subscription or available based on your organization’s settings. Learn which Copilot license you have.
If you’re working on a spreadsheet over time or with other people, your data may accumulate small inconsistencies. Copilot can help you manage information smoothly by fixing inconsistencies with spacing, capitalization, number formatting, and text formatting.
Note:Â Data cleaning performs best in English.
Examples of inconsistencies that Copilot can help with:Â
-
Spacing issues: Microsoft  Excel, Microsoft Excel, Microsoft    Excel
-
Inconsistent capitalization:Â Excel, EXCEL, excel
-
Inconsistent number and text formatting: 5, five, 5.0
How to clean your data
-
First, format your data for Copilot.
-
Go to the Data tab and choose Clean Data.
-
Copilot identifies possible issues with spacing, numbers, formatting, and spelling.
-
Select Apply to change your text based on the suggestion, or choose Ignore to keep your original text.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Find solutions to common problems or get help from a support agent.
