Feature

Remove duplicates from a contact list

Use this when the same contact appears twice with slightly different formatting. A common case is one row with JANE@EXAMPLE.COM and another with jane@example.com, or one phone number written three ways.

Why duplicates cause problems

Duplicates usually come from merged exports, list handoffs, or a CSV that has been edited by more than one person. The hard part is not obvious duplicates. It is near-duplicates hiding behind email casing or phone punctuation.

Use email first when it is the most stable identifier in the file
Use phone as a useful fallback when the email column is patchy
Full-row matches help catch literal duplicates from exports
Before

Messy rows

Jane Miller | JANE@EXAMPLE.COM | (555) 222-0101
Jane Miller | jane@example.com | 555.222.0101
After

Cleaned rows

Jane Miller | jane@example.com | 5552220101

How TrimMyList removes duplicates

The point is to catch duplicates before import, not after the CRM is already messy. TrimMyList checks repeated rows using the same fields people usually scan by hand, then shows the result in a before and after preview.

Email match for the common case
Phone match when names or emails drift
Full-row match for duplicate exports

Works with CSV and XLSX files

This is most useful on CRM exports, lead list merges, and spreadsheets passed around between teams. Start from CSV or XLSX, then export one cleaned CSV for the next step.

When to run dedupe

Run dedupe before CRM import, before email outreach, and before reporting. Once duplicates enter the system, they tend to create second-order cleanup work in segmentation and attribution.

Try it

Run this cleanup on the actual file.

Open the cleaner, check the before and after view, and export one cleaned CSV you can actually use.

Related

Related pages for this cleanup job