Free Template
Contacts Master List (Dedupe-Ready)
A canonical contacts workbook with built-in dedupe helper columns — normalized key and dupe-count formulas that flag duplicates in red as you type.
excelgoogle-sheets
What’s Included
- Contacts — 9 canonical columns + 2 helper columns (Normalized Key, Dupe Count) that auto-flag duplicates.
- Change Log — audit-trail table for any edits you make (date, contact ID, field, old/new, reason).
How to Use
- Start typing contacts into the Contacts sheet. The Normalized Key column (name + email, lowercased) populates automatically.
- Dupe Count shows how many times the same key appears. Anything > 1 flags red.
- When you edit a contact, log the change in Change Log so the team can trace who changed what.
- Export the Contacts sheet for mail-merges — filter out rows with Dupe Count > 1 first.
Related Tutorials
- Clean & Dedupe Your Rights-Holder Contacts (
/tutorials/clean-dedupe-rights-holder-contacts)
Common Pitfalls
- Same person, two emails. The key uses name + email; a person with a new email reads as a new contact. Manual merge is still required.
- Typos in names. “Anna Reyes” vs “anna reyes” normalize to the same key; “Ana Reyes” does not. Fuzzy matching needs Apps Script (see tutorial).
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.