All posts

How to Verify Contacts Exported From a Small CRM (Capsule, Insightly, Nutshell) Before a Campaign

··2 min read

To verify contacts from a small CRM such as Capsule, Insightly or Nutshell, export the contacts as a CSV, check the email column with a verifier, and import a status back so your team knows which addresses are safe. A small business CRM grows for years and rarely loses a contact, so it usually holds more dead addresses than anyone expects.

What to export

Export people or contacts, not companies, with these columns: email, first name, last name, company, owner, last contacted or last activity date and tags. The last activity date is the most useful, because stale contacts are the ones most likely to bounce. Each CRM has its own export path and it changes over time, so use the CRM's current help pages.

Step 1: Clean the file

  1. Remove duplicate emails with remove duplicate emails. CRMs often hold one person under several company records.
  2. Split any cell with several emails using split multiple emails in cell.
  3. Use the duplicate contact finder if the same person appears with different addresses.

Step 2: Verify

Upload the CSV on the verify page or sample with the CSV email verifier. The CRM export to email list tool shows how to prepare a CRM export for a list check.

Result CRM status to set
Valid Safe to email
Catch-all Email with care
Unknown Re-check
Invalid Do not email; look for a new contact
Disposable Do not email

Step 3: Import a status back

Most CRMs let you update contacts by importing a CSV that matches on email or ID. Add a custom field such as "Email status" and import the verified result, or add tags like email-invalid. Our HubSpot guide shows the idea for one CRM, and the same pattern applies elsewhere. Check your CRM's import options so you update contacts instead of creating duplicates.

Step 4: Make the oldest rows the priority

Sort by last activity and look at the invalid rate by age. If contacts older than two years are mostly invalid, it is worth finding new contacts at those companies instead of mailing the old ones. The email list decay calculator shows how fast a list loses addresses.

Step 5: Keep it clean

Check new contacts as reps add them, using the API or an automation, and verify the whole list before each campaign. Verify emails in Pipedrive shows a similar CRM workflow.

Checklist

  • People exported with last activity date and owner
  • Duplicates removed
  • Every address verified
  • Status or tag imported back, no duplicate contacts created
  • Oldest contacts reviewed for replacement

Verify the whole file

Upload the cleaned CSV on the verify page. You get 100 free email checks when you sign in with Google, no card, which is enough to test a sample. For a full list, Pro is $39 a month with unlimited email verification*, and the other columns stay attached so each person keeps their context next to the result.

*Fair use: the first 100,000 checks a month run at full speed, then slower, never cut off. See pricing.

Common questions

How often should I clean CRM contacts?

Before any big campaign, and at least once or twice a year. Contacts that have not been touched for a year or more are the most likely to have gone stale.

Will verification change the CRM?

No. The verifier works on an exported file. You choose what to import back, such as a tag or a field marking each address valid, risky or invalid.

Should I delete invalid contacts?

Usually mark them rather than delete, so you keep the company and history and can find a new email later.

Do I need an integration?

No. A CSV export and import is enough for a periodic clean-up. An automation can check new contacts as they are added.

Check your list before you send

Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.