Tools for contact lists, mailing lists and CRM data
Contact data decays in predictable ways. The same person signs up twice with different capitalisation, a phone number is typed four different ways, an import from an old system garbles every accented surname, and a list exported from one CRM won’t match records in the next. Email platforms bill by contact and penalise bounces, so each of those costs money as well as looking careless.
These pages deal with people data specifically: addresses, names and numbers. The files hold personal data, which is why everything here runs in your browser and nothing is sent to us.
The order that works
- 1
Fix the text before you compare anything: repair accents, trim spaces and lower-case email addresses.
- 2
Standardise the fields people type freely, such as phone numbers and name casing, in the columns you choose.
- 3
Remove duplicates once the values are normalised, matching on the email column alone if names and dates differ between copies.
- 4
Look at the flagged rows in the quarantine file and decide which addresses to fix and which to drop before importing.
Whole-file cleanups
Presets for a complete export, when you want one pass before a re-import, a migration or a campaign.
Clean a CRM Export
For HubSpot, Salesforce or Pipedrive exports, keeping the original headers so the file can go back in.
Clean an Email List
For a mailing list before Mailchimp or a similar platform: normalised addresses, duplicates removed, bad ones flagged.
Merge CSV Files
Join lists from several events or forms into one file before you de-duplicate it.
Single fields
When only one column is the problem and you don’t want the rest of the file touched.
Validate Emails
Checks each address’s shape and puts malformed ones in a separate quarantine file; it never contacts mail servers.
Format Phone NumbersPro
Rewrites numbers in E.164 form for dialers and SMS tools; pick the phone columns so IDs and dates are left alone.
Proper Case TextPro
Turns ANA RUIZ and ben ode into Ana Ruiz and Ben Ode for mail merges and labels.
Remove Duplicates
Match on every column, or only on the email or customer ID column, keeping the first copy of each contact.
Guide
For lists that still look duplicated after Excel says it removed the duplicates.