Clean Up Messy Excel Data With One Copilot Prompt

Clean Up Messy Excel Data With One Copilot Prompt

Messy spreadsheet data can quietly interfere with formulas, lookups, PivotTables, reports and AI-generated insights. Microsoft's new Clean Data skill for Copilot in Excel can inspect your data, explain potential problems and propose corrections for you to review.

By Rodger Mansfield, Technology Editor

Nov. 9, 2026

Subscribe | Read the Newsletter Version

A date entered differently in a few rows or a customer name with an extra space may look harmless.

In Excel, those little inconsistencies can cause much bigger headaches when you build formulas, PivotTables, lookups or reports.

Microsoft is giving Copilot a more direct way to help.

The new Clean Data skill examines relevant spreadsheet data for problems including extra spaces, inconsistent text and number formats, inconsistent dates, duplicate values and values stored as the wrong data type.

It explains what it finds and proposes corrections in the workbook.

You review those recommendations and decide which changes to apply.

That last part matters.

Cleaning a spreadsheet isn't simply about making everything look uniform.

A duplicate customer name, for example, might indicate a mistake, or it might represent perfectly legitimate data. Context still counts.

Here’s a Cool Tip: Type @clean-data and let Copilot spot the spreadsheet mess, then review the fixes yourself.

Feature Explanation

Microsoft calls the capability clean-data.

It's a Copilot in Excel skill designed to find and correct data-quality problems.

@clean-data is the direct way to invoke it.

You can also find available skills by opening Copilot, selecting Add > Choose plugins and skills, and choosing an available skill.

What makes Clean Data particularly useful is its review-first approach.

Copilot identifies potential trouble, explains what it found and why it matters, then proposes corrections.

You decide which changes should be applied to the workbook.

Clean Data checks for issues such as:

Extra spaces
Inconsistent text formats
Inconsistent number formats
Inconsistent dates
Duplicate values
Values stored as the wrong data type

These problems can affect formulas, lookups, PivotTables, reports and AI-generated insights.

That makes the skill particularly appealing when you've inherited someone else's spreadsheet, imported information or combined data from several sources.

Instead of manually hunting through column after column, you can ask Copilot to perform the initial inspection.

What You’ll Gain

Find hidden inconsistencies: Spot extra spaces, conflicting formats, inconsistent dates and duplicate values.
Catch problems before analysis: Identify issues that could affect formulas, lookups, PivotTables and reports.
Stay in control: Review proposed corrections and decide which changes to apply.
Reduce tedious checking: Let Copilot perform an initial inspection for common data-quality problems.

Step-by-Step Instructions

Here's how to do it.

Windows, Mac and Web:

Open the workbook you want to check in Excel.
Open Copilot.
In the Copilot prompt, type @clean-data.
Tell Copilot which data you want it to examine.
Review the issues Copilot identifies and its explanation of why they matter.
Review the proposed corrections.
Select the changes you want to apply.
Check important records, formulas and totals before relying on the cleaned data.

fig. 1 - Copilot Can Clean Up Your Excel Data

Pros and Cons

Pros:

Finds several common data-quality problems within one workflow.
Explains what it found and why the problem matters.
Lets you choose which proposed corrections to apply.
Could save time when preparing data for formulas, PivotTables, reports or AI analysis.
The @clean-data command is simple and easy to remember.

Cons:

Clean Data is still rolling out, so some users may not have it yet.
Copilot availability can depend on your Microsoft 365 subscription and organization settings.
AI-generated recommendations still require human judgment.

Who Should Skip This

If your spreadsheet is small, carefully controlled or already validated, manually checking the data may be faster.

You may also want to skip Clean Data if you don't have access to Copilot in Excel, your organization restricts Copilot or the feature hasn't reached your account yet.

If Copilot doesn't appear in Excel, it may not be included with your Microsoft 365 subscription or could be unavailable because of your organization's settings.

For important financial, academic or business records, treat Copilot's proposed corrections as recommendations to review rather than changes to accept without checking.

Real-World Examples

Small Business

A shop owner combines customer or inventory lists from several sources. Clean Data can inspect the information for documented problems such as inconsistent formatting, duplicate values and values stored as the wrong data type before that information is used for analysis.

Business User

A manager inherits a large workbook and wants to create a PivotTable. Running Clean Data first can identify data-quality problems that can interfere with PivotTables and reports.

Student

A student combines survey responses into one Excel sheet. Clean Data could flag formatting inconsistencies or duplicate values, but the student still needs to decide whether an apparent duplicate is actually an error.

Troubleshooting and Limitations

Problem: Clean Data doesn't appear.

Why it happens: The capability is rolling out to general availability.
Fix or workaround: Check for the Clean Data skill again as Microsoft's rollout progresses and consult the current Microsoft support documentation.

Problem: Copilot itself is missing.

Why it happens: Copilot might not be included with your Microsoft 365 subscription or could be unavailable because of your organization's settings.
Fix or workaround: Check your subscription and Copilot access. With an organization-managed account, contact your administrator.

Problem: Clean Data is disabled.

Why it happens: Copilot skills can be turned on or off.
Fix or workaround: Open Settings (...) > Manage plugins & skills. a disabled skill can still be invoked with a direct @mention.

Problem: A suggested correction doesn't look right.

Why it happens: Spreadsheet context matters. A legitimate value might appear inconsistent with surrounding data.
Fix or workaround: Don't apply the proposed change until you've checked the underlying information.

Privacy and Data Notes

Clean Data works with relevant data in your Excel workbook, so use appropriate caution with personal, financial, proprietary or confidential information.

The broader Copilot in Excel experience can edit and analyze the contents of a workbook. Microsoft emphasizes that the workbook remains editable and that users retain control over modifications.

For sensitive or organization-managed information, follow your organization's data-handling and AI policies.

A good practical rule applies to any AI-assisted spreadsheet task: Review, edit and verify important output before relying on it.

Feature Access

Microsoft's October 2026 Excel update lists Clean Data for Excel for Windows, Mac and web.

Access to Copilot itself may depend on your Microsoft 365 subscription or organization settings.

Because the feature is rolling out, availability should not be characterized as universal.

Score

Criterion |  Score (0–10) |  Justification

Value |  9
Data-quality problems can interfere with everyday Excel work, and Clean Data provides a useful check before analysis.

Usability |  8
@clean-data is simple to remember, although the ongoing rollout means some users may not have the feature yet.

Wow Factor |  7
Data cleanup isn't new, but combining detection, explanations and proposed corrections inside Copilot makes the process more useful.

Total: 24/30 | 👍 Good

Clean Data tackles an everyday Excel headache while keeping users in control of which proposed corrections are applied.

Compared with manually inspecting columns for inconsistencies, Clean Data can check for several documented categories of data-quality problems and explain what it finds.

Key Takeaways

Clean Data is most useful as an initial check before you rely on a spreadsheet for formulas, PivotTables, reporting or other analysis.

Its biggest benefit isn't that AI blindly cleans a spreadsheet for you.

It's that Copilot can surface potential problems, explain why they matter and let you decide what actually needs fixing.

Cool Tip Snapshot

Feature Name: Copilot in Excel: Clean Data
Platform(s): Windows, Mac and web
Quick Benefit: Finds common data-quality problems and proposes corrections
Best For: Imported lists, inherited workbooks and data being prepared for analysis
Access Type: Rolling Out
Difficulty: Easy

Learn More

Use built-in skills with Copilot in Excel explains Microsoft's current Copilot skills, including how to invoke Clean Data using @clean-data.

Microsoft Support: Use built-in skills with Copilot in Excel

Microsoft's October 2026 Excel update provides the official announcement and rollout information.

Try It Yourself

Open an Excel workbook that could use a cleanup and try @clean-data in Copilot. Review what it finds, check its proposed corrections and see whether it catches something you missed.

Then tell us what happened in the comments.

Subscribe to the One Cool Tip newsletter for more useful technology tips, and share this Cool Tip with family, friends and coworkers who spend too much time cleaning up spreadsheets.

READ MORE

Stay Connected with One Cool Tip
👍 Like and Share: Help others discover OneCoolTip.com!
📬 Subscribe: Get the FREE OneCoolTip Newsletter delivered straight to your inbox.
💡 Support the Site: Chip in through TIPJAR to keep the Cool Tips coming.

Explore More

📺 YouTube: One Cool Tip Channel

✍️ X (Twitter): @OneCoolTip

🧵 Threads: @onecooltip

Have a great tip or tech question?

📧 Email: onecooltip.com@gmail.com

Rodger Mansfield, a seasoned technology expert and editor of OneCoolTip.com, transforms complex tech into practical advice for everyday users. His Cool Tips empower readers to stay productive, secure, and one step ahead in the digital world.

One Cool Tip

www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#MicrosoftExcel #ExcelTips #MicrosoftCopilot #CopilotInExcel #Microsoft365 #ProductivityTips
@msexcel @Microsoft365 @Microsoft
#TechTips #OneCoolTip @OneCoolTip

Monday, November 9, 2026