Answers

How do you clean up a messy customer list or CRM?

Ascent Vision · Published October 30, 2026

Work on a copy, decide which fields matter, then merge duplicates, fix the obvious gaps, mark anyone who asked to stop getting email or texts, and archive people you have not contacted in a long time instead of deleting them. Name one person who owns the list and give them a short monthly check. A list kept this way is usually quicker to use and easier to trust than a large one nobody maintains.

Start with a copy and a short field list

Export the list or duplicate the spreadsheet first, and leave that first file as it is. Every change after that happens on the copy.

Then decide which fields you will keep accurate. A short list is easier to hold: name, phone, email, where the person came from, the last time you were in touch, and a status of won, lost or still open. The related answer on what a CRM is describes what a customer record usually holds. Fields nobody fills in or reads can usually go.

Merge duplicates

Duplicates often show up as the same phone number or email under two names, one name spelled two ways, or a person and their company entered separately. Sort the list by phone and then by email to see them side by side.

• Pick one record to keep, usually the most complete or the newest.
• Move across anything the other record has that this one lacks, including notes and job history, before you remove it.
• If the two records show different sources, keep both in the notes rather than guessing which one is right.
• When two records may be different people, such as a parent and a grown child at the same address, leave them apart.

Fix the obvious gaps

• Fill in a missing source where you can remember or find it, and write unknown where you cannot, rather than inventing one.
• Update old statuses. An inquiry marked still open from long ago is probably lost or won, and an honest status makes your numbers more useful.
• Correct phone numbers with missing digits and emails with obvious typos, and delete test entries and blank rows.
• Mark everyone who asked to stop getting email or texts, in a field that is easy to see, and treat that mark as final. Text only with the person's consent; where the list does not show consent, treat it as no. The related answer on texting a new lead covers consent and stop requests.

Archive instead of deleting

For people you have not heard from in a long time, a status such as inactive usually works better than deletion. Their history may still matter for a warranty question, a billing question or a returning customer. This is general advice: for invoices and payment records, ask your accountant which records to keep and for how long before you delete anything.

Keep it clean

One person should own the list, and it helps if everyone else knows who that is. A monthly check of about ten minutes often catches problems while they are small: new entries with no source, two records for one person, and statuses that have gone stale.

If the list is moving to a new tool, the related answer on switching business software covers merging duplicates before an import and keeping a copy of the export.

Related answers

• What is a CRM, and does a small business need one?
• Can you text a new lead or a past customer, and what consent do you need?
• How do you switch business software without losing your data?