About Services Tools Blog Contact us

CRM Contact List Hygiene

Matches an incoming contact spreadsheet to Salesforce, merges duplicates, splits messy names and files new people by region, so campaigns and sales use one current set of contacts.

  • Data Merge & Cleaning
  • Water utilities
  • Scheduled worker
  • Productised
  • Cloud
  • 2025

The problem

New contacts arrive in spreadsheets and regions overlap. The same person is created again from another role column. Contact groups and lead lists then hold duplicates, so nobody trusts them.

What it does

An import is matched to existing contacts on email and company. The tool creates new people, merges duplicates and sets a region or owner. Names buried in role columns are split into given name and surname before the upload. A contact group that will not save is logged and retried once the field is corrected.

Outcomes

  • Each person has one current contact, with a region and an owner.
  • Duplicates from role columns are merged before the Salesforce upload.
  • A failed contact group is logged and can be retried.
  • New prospects land in a regional list.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Contact import

1. Spreadsheet
Load show_contacts.csv

Badge export plus a supplier sheet. Match on email and company. Role columns still hold person names.

2. This run
  1. Read the sheet
  2. Split names
  3. Match email and company
  4. Merge duplicates
  5. Set region and owner
  6. Save segments
Load a file to start
As received 7 of 20 rows
Role columnName as writtenCompanyEmail
Site leadMOREAU ELISEFENLOCK TREATMENT[email protected]
BillingE MoreauFenlock[email protected]
EmergencyElise M.Fenlock Treatment Ltd[email protected]
DirectorMoreau, EliseFenlock[email protected]
BuyerBRIGGS, CALLUMASHMERE CATCHMENT[email protected]
Site leadCallum BriggsAshmere[email protected]
VisitorJ DoyleRookley Worksblank

Prospect queue

New prospects by region
Eight new people
ProspectCompanyRegionOwnerStatus
Elise MoreauFenlock TreatmentEastRowan HaleQueued
Yusuf DemirRookley WorksEastRowan HaleQueued
Anika BosePebbleford EstatesEastRowan HaleQueued
Nadia CroweAshmere CatchmentNorthIdris ColeQueued
Leila OkoyeLowford MainsNorthIdris ColeQueued
Caleb NwosuNenebridge LabMidlandsFelix BrennanHeld
Greta HolmWhitfen StorageWestMaeve QuinnQueued
Hugo PellQuayfield NetworksWestMaeve QuinnQueued

Segments

Open failures
1
Region code was blank
Retry
Waiting for a correction
Tonight’s segments
SegmentPeopleOwnerStatus
East works managers3Rowan HaleSaved
North catchment2Idris ColeSaved
West networks2Maeve QuinnSaved
Midlands lab visitors1Felix BrennanFailed
Held row

Caleb Nwosu, Nenebridge Lab. The segment refused to save because region code was empty. The correction is M-LV.

Status on this row: Held

How it works

  1. Read the spreadsheet and the role columns that hold person names.
  2. Trim names, split given name and surname, and drop empty rows and obvious non-names.
  3. Match the remaining rows to existing contacts on email and company.
  4. Merge duplicates, create the new people and set region or owner.
  5. Log a contact group that fails to save, correct the field and retry.
  6. Hand sales a list of new prospects.

Pipeline

flowchart LR
  A[Sheet] --> B[Names]
  B --> C[Match]
  C --> D[Merge]
  D --> E[Region]
  E --> F[Segment]
  F --> G[Queue]