# How to Prevent Duplicate Participant Records > Duplicates inflate your counts and split one person's history in two. Here is how to prevent them at sign-in and clean up the ones you have. Published: 2026-04-08 Author: Julian (OpenCommunity Team) ## Key takeaways - Duplicates usually come from re-entering people instead of finding them, and from small spelling differences. - Duplicate records inflate counts and split one person's history across two files. - The best fix is prevention at sign-in: search first, then add only if there is truly no match. ## Why duplicates creep in Duplicate records rarely come from carelessness. They come from ordinary situations: a busy sign-in, a name spelled two ways, a nickname, a new volunteer who does not know the person is already in the system. Across paper sheets and separate spreadsheets, the same person quietly becomes two or three. Understanding the causes points straight at the fixes. ## What duplicates cost you - Counts of unique people are inflated, so reach looks bigger than it is. - One person's history is split, so no record tells the whole story. - Contact updates land on one copy and not the other. - Reporting takes longer, because someone cleans the list by hand. This is why duplicates distort the count of [unique participants versus total visits](https://opencommunity.ca/blog/unique-participants-vs-total-visits/index.md). ## Prevent them at sign-in The single most effective habit is to search before adding. Look for the person first; only create a new record when you are sure there is no match. 1. Search by last name or phone number before entering anyone new. 2. Check for nicknames and alternate spellings. 3. Link relatives to a household instead of duplicating shared details. 4. Add a new record only when no genuine match appears. Linking relatives is easier when you use [household records](https://opencommunity.ca/blog/what-is-a-household-record/index.md). ## Find and merge the ones you have For the duplicates you already have, work through them steadily rather than all at once. Look for repeated names, matching phone numbers, or the same address. When you find a pair, confirm they are truly the same person, then merge so their history and attendance combine into one record. Keep the most complete details. ## Habits that keep it clean A clean list stays clean with a few light habits: search first every time, review new records weekly at first, and give volunteers a simple rule to follow when they are unsure, which is to ask rather than add. Small, consistent care beats a big annual cleanup. ## Questions and answers ### How do we prevent duplicate participant records? Search for a person before adding them, check for nicknames and alternate spellings, and link relatives to a household rather than repeating shared details. Only create a new record when no genuine match appears. ### Why do duplicates matter? They inflate your count of unique people, split one person's history across records, and make contact updates unreliable. They also slow down reporting, because someone has to clean the list by hand. ### How do we clean up duplicates we already have? Work through them steadily. Look for repeated names, matching phone numbers, or shared addresses, confirm the records are the same person, then merge them so history and attendance combine, keeping the most complete details. ### How can volunteers help avoid duplicates? Give them one simple rule: search first, and if unsure whether someone is already in the system, ask rather than add. That single habit prevents most duplicates at the source. ## More from OpenCommunity - [All resources](https://opencommunity.ca/blog/index.md): Browse every published guide. - [OpenCommunity features](https://opencommunity.ca/features/index.md): Explore the platform.