Guides
Plain-English guides on cleaning lists: how duplicates happen, how to remove them without losing data, and how to keep a list clean once it is clean.
How to Remove Duplicates from a CSV File Without Losing Data
A safe way to remove duplicates from a CSV file: match on the right columns, review each group, fill gaps before you merge, and check the counts at the end.
Why Your CRM Import Created Duplicates (and How to Stop It Happening Again)
Why a CRM import so often creates duplicates: weak match keys, name variants, and no check before the import. Plus the fixes that stop it next time.
How to Merge Two Mailing Lists Without Duplicates
How to merge two mailing lists into one clean list: stack the lists, line up the columns, dedupe across both, respect opt-outs, and check the final count.
Why Exact-Match Dedupe Misses Most Duplicates
Exact-match dedupe only finds rows that are the same letter for letter. Typos, short names, and format slips hide the rest. Here is what it misses, and what works better.
How to Dedupe a List When Names Are Spelled Differently
Names come in many forms: nicknames, typos, initials, and swapped fields. How to group those rows as one person, without merging two real people who share a name.
How to Clean a CSV File Before Importing It Into Your CRM
Clean your CSV before the CRM import, not after: fix the file shape, tidy the values, dedupe the file, and test with a small batch so the import lands once and lands right.
How Duplicate Records Hurt Your Email Campaigns
Duplicates make people get the same mail twice, skew your open and click rates, raise spam flags, and waste spend. How the harm works, and how to measure it on your own list.
How to Choose Which Record to Keep When Duplicates Disagree
When two rows for one person disagree, which facts win? A clear order: trust dates, trust fullness, never let a blank beat a value, and keep the loser in the audit file.
Why You Should Keep an Audit File of the Duplicates You Remove
An audit file lists every row you removed, its group, and why. It makes merges undoable, answers hard questions, and keeps your records honest. What to keep, and how long.
How to Dedupe Lists From Different Sources When the Columns Don't Match
Lists from different sources name and shape their columns differently. Map the columns to one schema first, convert the values, then dedupe — with a worked plan.