AI WORLD HQClean up a messy customer list in Excel with Copilot in under 2 minutes
Paste your messy customer list into Excel, ask Copilot to find duplicates, and delete them with one click.
This guide was written by AI. It passed automated fact and quality checks; no human editor reviewed it.
See AI World HQ first on GoogleAdd us as a preferred source and our stories show up higher in Google’s Top Stories.Add on GoogleYou’ll have a tidy, duplicate-free customer list ready to use in under two minutes. No formulas, no manual sorting — just paste your messy data and let Copilot do the heavy lifting.
💡 Tip: tap a step’s number when you finish it — a green tick appears and your browser remembers how far you got.
- A Microsoft 365 subscription (Copilot is included in most business plans).
- The Excel desktop app (Windows or Mac) or the Excel web app in Microsoft 365.
- A customer list in a simple format (one row per customer, one column per field like Name, Email, Phone).
- Rough time: 2 minutes.
Open your customer list in Excel
Open the Excel app on your computer or go to Excel for the web and sign in. Open the file that contains your customer list. You’ll see a grid of rows and columns. Each row is a customer, and each column is a piece of information like Name, Email, or Phone.
you see your customer data displayed in the familiar Excel grid.
Start Copilot in Excel
Look at the ribbon at the top of the Excel window. Find the Home tab. On the right side of the ribbon, you’ll see a button labeled Copilot. It looks like a small chat bubble with sparkles. Click it to open the Copilot pane on the right side of your screen.
If it’s still missing, your plan may not include Copilot — check with your IT admin.
If you don’t see Copilot, look for a button like Ask Copilot or Copilot in the Home tab.
a chat window appears on the right side of Excel, ready for your prompt.
Ask Copilot to find duplicates
In the Copilot chat box, type or paste:
Copilot will process your request and show a message like “I’m checking for duplicates…” while it scans your data. After a few seconds, it will display a list of duplicate customers, grouped by the fields that match (for example, two rows with the same email address).
Copilot shows a clear list of duplicate customers and the rows they appear on.
Review the duplicates Copilot found
Copilot will show you the duplicate customers and the rows they appear on. It may also suggest which row to keep (for example, the most recent entry). Read through the list and decide which rows to keep or remove.
If the list looks different on your screen, look for a section labeled Duplicates found or Review duplicates in the Copilot pane.
you see a clear list of duplicates and the rows they appear on.
Ask Copilot to remove the duplicates
In the same Copilot chat box, type or paste:
Copilot will confirm the action and show a preview of the changes. After you approve, it will remove the duplicate rows and leave only one entry per customer.
If you don’t see a preview, look for a button like Apply changes or Confirm in the Copilot pane.
your customer list no longer contains duplicate rows and each customer appears only once.
Mistake: Copilot doesn’t find any duplicates even though you know there are some. Fix: Make sure your data is in a simple table format (one row per customer, one column per field). If your data is merged or formatted strangely, Copilot may miss duplicates.
Mistake: Copilot removes the wrong row when deleting duplicates. Fix: Before asking Copilot to remove duplicates, review the list it shows. If you want to keep a specific row, ask Copilot to “keep the row with the most recent date” or “keep the row with the longest name.”
Mistake: Copilot doesn’t appear in Excel. Fix: Copilot is only available in Microsoft 365 plans that include it. If you don’t see Copilot, check with your IT admin or try opening Excel in a browser at Excel for the web.
Open Excel, paste a small customer list into a new sheet, and ask Copilot to find and remove duplicates. You’ll have a clean list in under two minutes — and you’ll be ready to use it for your next task.
❓ Quick questions
How long does this take?
About 6 minutes — the guide has 6 steps, and you can tick each one off as you go.
Which tool do I need?
This guide uses Microsoft Copilot — but the approach works very similarly in other AI assistants.
Do I need to prepare anything?
- A Microsoft 365 subscription (Copilot is included in most business plans).
- The Excel desktop app (Windows or Mac) or the Excel web app in Microsoft 365.
- A customer list in a simple format (one row per customer, one column per field like Name, Email, Phone).
- Rough time: 2 minutes.
What mistakes should I avoid?
Mistake: Copilot doesn’t find any duplicates even though you know there are some. Fix: Make sure your data is in a simple table format (one row per customer, one column per field). If your data is merged or formatted strangely, Copilot may miss duplicates.
Mistake: Copilot removes the wrong row when deleting duplicates. Fix: Before asking Copilot to remove duplicates, review the list it shows. If you want to keep a specific row, ask Copilot to “keep the row with the most recent date” or “keep the row with the longest name.”
Mistake: Copilot doesn’t appear in Excel. Fix: Copilot is only available in Microsoft 365 plans that include it. If you don’t see Copilot, check with your IT admin or try opening Excel in a browser at Excel for the web.
Keep reading
✦ Generated by AI in AI World HQ's automated newsroom, written in plain language. Checked by automated fact and quality gates — no human editor reviewed this guide. Spot a mistake? Use the buttons above.
← Back to all stories