All posts

Clean Your List Before Importing to SendPulse, Sender or Benchmark Email

··3 min read

Before importing a CSV to SendPulse, Sender, Benchmark Email or a platform like them, verify the email column and upload only the valid rows. Smaller platforms often review new accounts and big first imports by hand or by rule, and a list full of invalid addresses is an easy reason for them to pause your sending.

This guide is general on purpose. These tools change their import screens and policies, so use it with the platform's own current help pages.

Why the first import matters most

A new account has no sending history. The first campaign is your only reputation signal, both for the platform and for the mailbox providers receiving it. Bounces on that first send are counted from a standing start. A platform that reviews accounts will often look at exactly that send.

Settled accounts can take a bad batch better, but they also can be warned. For the numbers that platforms flag, see bounce rate thresholds by platform.

Step 1: Gather and tidy

  1. Export every source into one CSV, with email, name and the source list.
  2. Remove duplicates with remove duplicate emails.
  3. Correct typos with the email typo corrector.
  4. Split cells with several addresses. This guide shows how.
  5. Make sure you have permission. Contacts must have agreed to hear from you; see re-permission email consent for old lists.

Step 2: Verify

Run the file on the verify page. Sort the results:

Result Import?
Valid Yes
Catch-all Yes, as a separate list or tag
Unknown Hold back, re-check later
Invalid No
Disposable No

If more than a small fraction comes back invalid, that is a signal about the source and not the tool. Read my list came back mostly invalid before you go on.

Step 3: Import with a source tag

Use each platform's import wizard, mapping the email, name and any custom fields. Add a tag, group or list name with the source and the date verified. The wizard screens differ between platforms, so follow their current instructions. If an import is rejected, AWeber's import rejection guide covers the usual causes, which are similar elsewhere.

Step 4: Start with a small campaign

Send the first campaign to a small group of verified valid contacts. Check the platform's report for bounces and complaints. If it is clean, send to the rest of the valid list. Send to catch-all addresses last, in a separate campaign, and watch the numbers.

Step 5: Keep a master suppression file

When you export bounces and unsubscribes later, add them to a master list outside the platform. If you migrate again, this suppression guide shows the format. When you switch between platforms, screen the new import against the file before anything else.

Checklist

  • Source and permission confirmed
  • Duplicates, typos and multi-address cells fixed
  • Email column verified
  • Only valid rows imported, catch-all in a separate group
  • Small first campaign sent and bounce rate read
  • Master suppression file updated after each send

Verify the file first

Your first 100 checks are free on the verify page: sign in with Google, no card. Pro is $39 a month with unlimited email verification*, so you can clean before every import, whichever platform you use. See pricing.

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

Common questions

Do SendPulse, Sender and Benchmark Email check my list on import?

Platforms handle this differently, and the rules change. Some review lists or new accounts, some only react after the first send. Check the platform's help pages for the current policy rather than relying on a general rule.

Is it enough to let the platform remove bounces after the first send?

It removes the address after the damage is done. The bounce is already counted in that send. Verifying first avoids the bounce entirely.

Can I import contacts I bought?

Most email platforms forbid it in their terms, and a bought list is also the most likely to contain bad addresses. Read our guide on verifying a purchased list and the platform's terms before you decide.

What if my CSV has a column with several addresses in one cell?

Split them into separate rows first. Importers read one address per contact, and one cell with two addresses fails validation.

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.