Office CRM feature
Duplicate detection and merge
Returning leads get flagged instead of duplicated, and the duplicates you already have merge field by field.
The same person, not a second lead
Every automated intake (web form, inbound email, import, API) checks for an existing lead or contact with the same email or phone number. Phone numbers are compared in one standard format, so "(555) 014 2290" and "+15550142290" match.
When there's a match, no new record is made. The existing one gets the new source, a timeline entry with what they sent, and a Re-engaged badge, and its owner is notified. That's often the best moment to call: they came back on their own.
Typing one in by hand
If you add a lead by hand and the email or phone already exists, you see "Possible duplicate" with a link to open the existing one, or you can create it anyway.
Merge what's already doubled
Pick two or three records of the same type (leads, contacts, companies or deals) and merge them. You choose which value to keep for each field. Every link moves to the record that stays: deals, tasks, notes, emails, files, quotes, tags and meetings. Old BCC addresses keep working, and the merge is written in both changelogs.
Example
A lead that went cold and came back
Tom from Northgate HVAC was imported from a trade-show list in September, got one unanswered call, and went quiet. 74 days later he fills in the contact form: "Ready to talk about the second building." Instead of a new lead nobody recognizes, Theo (his owner) gets a notification, Tom's record shows Re-engaged with the form answers on top of the old history, and an automation rule creates a call task for today.
How to set it up
- 1
Nothing to turn on: matching runs on every form, email, import and API intake.
- 2
Add an automation rule on Lead re-engaged if you want a task or a notification to the team.
- 3
To merge, select the records in a list and choose Merge.
Duplicate detection and merge is part of Office CRM and included on every plan.
Questions people ask
Does an import create duplicates?
You choose per import: skip rows that match, update the existing record, or create anyway.
Can I undo a merge?
No, so you pick the surviving value for each field before it runs. The changelog keeps a record of what was merged.
More CRM features
- Lead managementOne list for every new inquiry, wherever it came from, with a clean path to a deal when it's real.
- Import from Zoho CRM and spreadsheetsBring your data over from Zoho CRM or a spreadsheet with columns already mapped, and undo the whole import if it's wrong.
- Automation rulesWhen this happens, if that's true, do these things. Plain rules for the busywork, with a log of every run.
- Web-to-lead formsA contact form for your website that turns each submission into a lead, assigned and tagged, with the spam filtered out.
Compare
- folk alternativefolk is a contact-first CRM priced per user, with deals and sequences on Premium. Compare Office CRM for a team that sells deals. Prices checked November 2026.
- Freshsales alternativeFreshsales prices per user, with sequences on Pro and forecasting insights on Enterprise. Compare Office CRM for small teams. Prices checked November 2026.
- Zoho CRM alternativeCompare Office CRM and Zoho CRM line by line: quotes, invoices, forecasting and what a team of 10 pays a year. Zoho prices checked November 2026.
Try Office CRM with your whole team
7-day trial with every feature. Cancel from the billing page whenever you like.