Purchased lists allowed

Realtor email list + Google Sheets

Five minutes of prep here doubles the performance of whatever tool comes next.

Every import guide above gets easier if you spend five minutes in Sheets first: split names, dedupe against your CRM, and cut one CSV into per-city campaign files.

Step by step in Google Sheets

1
Split Name into first/last
Insert two columns beside Name and use =SPLIT(A2," ") — most outreach tools greet by first name.
2
Dedupe against your CRM
Export your existing contacts' emails to a second sheet, then flag overlaps with =COUNTIF(CRM!A:A, B2)>0 and filter them out — never cold-email someone already in your pipeline.
3
Segment into campaign files
Data → Create a filter on City or Brokerage, then File → Download → CSV per segment. Smaller, tighter campaigns beat one blast.
4
Keep the master intact
Do all cutting on copies. The original CSV is your source of truth for re-imports.

Column mapping

Our CSV headers → where they go in Google Sheets.

AgentRoster column Google Sheets Note
Name =SPLIT(A2," ") first + last columns
Email =COUNTIF(CRM!A:A,B2) dedupe check
City / Brokerage / Region Filter views one campaign file per segment

Questions

How do I split realtor names into first and last?

Insert two columns next to Name and use =SPLIT(A2, " "). Double-barrelled names may need a manual pass, but it handles the bulk instantly.

How do I avoid emailing contacts already in my CRM?

Paste your CRM's email column into a second sheet and flag matches with =COUNTIF(CRM!A:A, B2)>0, then filter flagged rows out before importing anywhere.

Get the list, then import it into Google Sheets

47,058 verified Canadian realtor emails. Filter by city, brokerage or top producers — from $19, instant CSV.

Build your realtor list →