How to Import Past Clients Into Your Newsletter List

You have a spreadsheet. Maybe it lives in your CRM, maybe it’s a years-old Excel file you’ve been meaning to do something with. It’s full of past clients, open house visitors, referrals, people from your network — hundreds of contacts you’ve met in real life.

The question is whether you can turn that spreadsheet into an email list. The short answer: yes, with conditions. Here’s how to do it cleanly.

Understand What You’re Starting With

Before importing anything, sort your contacts into three buckets:

1. Active past clients — people who transacted with you in the last two years
2. Older contacts — people you worked with more than two years ago, or met at events, or collected from sign-in sheets without explicit opt-in
3. Purchased or scraped contacts — anyone you didn’t acquire through a direct relationship

Buckets 1 and 2 can work. Bucket 3 should not be imported into a newsletter list, period. Purchased or scraped emails will damage your deliverability and violate most platforms’ terms of service. (For the full case against this approach, should you buy a real estate email list walks through the math on why it fails.)

The Legal Baseline: US vs Canada

United States (CAN-SPAM): The US framework is opt-out based. You can email someone you have a business relationship with as long as you include a physical address, a clear sender identity, and a working unsubscribe link. Past clients generally fall under this. The practical risk is deliverability, not fines — spam complaints hurt you regardless of legal permissibility.

Canada (CASL): More stringent. CASL requires either express consent (they checked a box) or implied consent (an existing business relationship within the past 2 years). A client you closed on 18 months ago? Implied consent applies. A contact from a 2019 open house? That implied consent window has closed. You’d need to run a re-permission campaign before emailing them commercially.

If you serve both US and Canadian clients, apply the CASL standard to everyone. It’s cleaner and protects you in both jurisdictions.

Clean the Spreadsheet First

Don’t import a raw spreadsheet. Spend 30–60 minutes on cleanup:

• Remove duplicate rows (same person, multiple entries)
• Fix broken email addresses (missing domain, extra spaces, obvious typos)
• Delete rows where you have no email, or only have a phone number
• Add a column noting the source (past client, open house, referral) — you’ll use this for tagging
• Flag contacts you haven’t communicated with in more than 3 years as “re-permission” rather than direct import

A messy import leads to bounces, which hurt your sender score. Most email platforms allow you to import with column headers — first name, last name, email, and any custom tags. The cleaner your file, the smoother this goes.

How to Actually Import

Every major email platform (Mailchimp, Kit, ActiveCampaign, Klaviyo) has a CSV import flow. The steps are roughly:

1. Export your spreadsheet as a CSV file
2. Log into your email platform, go to Contacts or Audience
3. Find the import option (usually “Add Contacts” or “Import”)
4. Map your columns to the platform’s fields (first name → first name, email → email address, etc.)
5. Tag the imported group at this step — something like “past-client-import-2026” — so you can track their engagement separately

Tag them at import. This lets you see how this group performs compared to your organic signups, and clean aggressively if their engagement is low.

The Re-Permission Play for Older Contacts

For contacts that fall outside the CASL implied-consent window — or anyone you haven’t emailed in over two years — the right move is a re-permission email before adding them to your regular list.

The email is simple. It goes out to the questionable contacts as a standalone send (not through your newsletter list):

“Hi [First Name], it’s [Your Name] — we worked together on [address or transaction, if you have it]. I wanted to reach out directly before adding you to the monthly market updates I send to clients. If you’d like to stay on my list, just click here. If not, no worries at all — you won’t hear from me again.”

This accomplishes two things: it re-establishes consent where it’s legally required, and it filters out contacts who have moved, changed emails, or genuinely don’t want to hear from you. A smaller list of people who actively opted in will always outperform a large list of resentful non-engagers.

For ideas on what to actually send these re-engaged past clients once they’re on your list, realtor newsletter ideas for past clients has a content breakdown by relationship stage.

Setting Expectations After Import

Your first email to newly imported contacts should acknowledge who you are and why they’re hearing from you. Don’t assume they remember your name, especially for older contacts.

A short re-introduction — “You’re getting this because we worked together when you bought your home on Elm Street in 2023. I send a monthly market update to past clients and wanted to make sure you were on the list” — reduces confusion and spam complaints.

It also reminds them of a good experience, which sets the tone for everything that follows. The post-close relationship is one of the most valuable things an agent can cultivate, and for more on building it systematically over time, how to stay in touch with past clients after closing covers the full cadence.

A Note on Platform Limits

Most email platforms have daily or one-time import limits on free plans. Mailchimp’s free tier caps at 500 contacts. If your spreadsheet is larger, you’ll need a paid plan before importing.

Also check whether your platform auto-suppresses unsubscribes and bounces globally. Most do. If someone unsubscribed from a previous email you sent, they should already be suppressed — re-importing them won’t work and could trigger a platform warning.

Do this right once, and you have a clean list with real engagement. Do it wrong, and you’ll spend months recovering your sender reputation.