Comparable List
CRM workflow

How to compare CRM contact lists before a merge

A private checklist for reconciling contact exports by email or ID, reviewing exceptions, and avoiding accidental duplicate records.

5 min readBy Comparable List Editorial Team

Prepare → compare → reviewPrivate, local list reconciliation

A useful list comparison starts with a clear decision, not an upload. This workflow keeps the comparison in your browser and makes the matching rules visible, so the resulting exception list can be reviewed rather than blindly acted upon.

1. Choose the matching field

Choose one stable identity field: a CRM contact ID when both exports share it, or a normalized email address when they do not.

2. Prepare comparable sources

Export comparable audience segments and remove headers from pasted lists. Keep the untouched files so an exception can always be traced back to its source.

  • Use exports created for the same scope and approximate date.
  • Keep the original source files untouched for audit and recovery.
  • Compare one meaningful field at a time instead of mixing identifiers.

3. Normalize intentionally

For email, trim spaces and ignore case. Do not combine records merely because names look alike: a shared name is not proof that two people are the same contact.

4. Review the result before acting

Confirm the Common list first, then assign owners to records only in each export. Use the duplicate audit to find repeated source rows before import.

Ready to check your data?

The tool runs locally in your browser. Review the result before you act on it, especially when a list contains customer, account, or operational data.

Open CRM contact compare

Frequently asked questions

Does this comparison upload my list?

No. The comparison, normalization, audit, and export happen in the browser tab. A share link is an exception: it intentionally encodes list data in the URL, so do not use it for confidential information.

Should I turn on every cleaning option?

No. Use only rules that preserve the identity of every item. Review the Common result and the suggested normalizations before exporting or acting on a difference.

Can I keep this workflow for next time?

Yes. You can save a local template with the selected options, or save a result summary in this browser. Full source lists are never stored unless you explicitly choose that local-device option.

Related tools and guides

Need a spreadsheet column selector? Try CSV & Excel compare. For a general workflow, return to the two-list comparator or browse all data-cleaning guides.