Overview
If you have your own mailing list, you can upload it directly when building a campaign. We accept CSV and Excel files. This guide explains the required format, field names, and tips for ensuring high deliverability.
Accepted File Formats
- .csv - Comma-separated values (most common)
- .xlsx - Microsoft Excel workbook
- .xls - Legacy Excel format
Required Fields
Every record in your mailing list must include these fields:
- Address Line 1 - Street address (e.g., "123 Main Street")
- City - City name
- Province - Two-letter province code (e.g., ON, BC, AB, QC)
- Postal Code - Canadian postal code in A1A 1A1 format
Optional Fields
Including these fields enables personalization and better targeting:
- First Name, Last Name - For personalized greetings (e.g., "Dear Sarah,")
- Company - Business name for B2B campaigns
- Address Line 2 - Suite, unit, or apartment number
- Phone, Email - For multi-channel follow-up campaigns
Formatting Tips
- Use a header row - The first row should contain column names matching the fields above
- One record per row - Each row represents one recipient
- Remove duplicates - Duplicate addresses waste postage
- Verify postal codes - Incorrect postal codes cause undeliverable mail. Use our Address Verification service to clean your list automatically.
- UTF-8 encoding - Save your CSV with UTF-8 encoding to preserve French characters and special symbols
Sample Format
Here is what your CSV file should look like:
FirstName,LastName,Address1,City,Province,PostalCode
Sarah,Mitchell,123 Main Street,Toronto,ON,M5V 2T6
James,Rodriguez,456 Oak Avenue,Vancouver,BC,V6B 1A1
Address Verification
We strongly recommend running your list through our Address Verification service before mailing. This service validates each address against the Canada Post database, corrects minor errors, flags undeliverable addresses, and applies NCOA (National Change of Address) updates for recipients who have moved. It typically improves deliverability by 5-15%.
Was this article helpful?
Let us know if you need more help.
