Constant Contact
Freshsales Contacts11 fieldsHow to import Constant Contact data into Freshsales
Move your Constant Contact list into Freshsales. This template maps name, email, phone, company, title, and the full address to Freshsales's snake_case contact fields. Freshsales splits phone numbers into Work and Mobile; Constant Contact only exports one phone column, so we map it to Work by default.
Field-by-field mapping
This is the complete column mapping from Constant Contact to Freshsales. The left column is the header in your CSV export. The right column is the Freshsales field it should map to.
Before you start
This template's destination has a required field that needs attention before upload. You can still use this template. The steps below tell you what to add and where.
- Last Namelast_name
Freshsales requires Last Name on every contact. Constant Contact exports ship a Last Name column whenever the field was collected on the signup form; older lists may have it blank if the form never asked.
What to do. Scan your CSV for blank Last Name rows before uploading. Fill them by hand from the email signature where possible, or remove those rows.
| Constant Contact column | Freshsales field | |
|---|---|---|
| First Name | First Namefirst_name | |
| Last Name | Last Name*last_name | |
| Emailemail TransformLowercased and trimmed | ||
| Phone Number | Work Numberwork_number Freshsales splits phone into Work and Mobile. Constant Contact only exports one phone column, so we map it to Work by default. TransformStandardized to international format (+1, +44, etc.) | |
| Company Name | Company Namecompany_name | |
| Job Title | Job Titlejob_title | |
| Address Line 1 | Addressaddress | |
| City | Citycity | |
| State | Statestate | |
| Postal Code | Zip Codezipcode | |
| Country | Countrycountry |
Required by Freshsales.
Columns we don't use
Your Constant Contact export includes 3 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Freshsales.
- Birthday
Freshsales doesn't have a built-in birthday field on contacts.
If you need it. Add a custom date field on the Freshsales Contact called Birthday, then re-run this template to map it.
- List Memberships
Constant Contact list memberships export as a comma-separated string. Freshsales uses lifecycle stages and custom fields rather than list memberships.
If you need it. Add a custom multi-select field on the Freshsales Contact called Lists, or build saved filters matching your Constant Contact lists after import.
- Email Permission Status
Constant Contact's permission column records subscription state (Implicit, Explicit, Unsubscribed). Freshsales tracks email opt-in through its own subscription status.
If you need it. Filter Unsubscribed rows out of the CSV before upload. For the rest, set the Freshsales subscription status manually or via a custom field.
Formatting and cleanup
Constant Contact exports rarely match the format Freshsales expects. Fix these before you import.
- 1.Lowercases and trims email addresses
- 2.Standardizes phone numbers to international format (+1, +44, etc.)
- 3.Renames Constant Contact columns to Freshsales's snake_case API names
- 4.Maps Phone Number to Freshsales's work_number field by default
- 5.Maps Constant Contact's address block to Freshsales's address, city, state, zipcode, country fields
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Constant Contact export and download a clean, import-ready file for Freshsales.
Constant Contact to Freshsales FAQ
How do I export contacts from Constant Contact?
In Constant Contact, go to Contacts, select the list you want, click Manage > Export, and download the CSV.
Why does Phone Number go to work_number?
Freshsales splits phone numbers into Work and Mobile. Constant Contact only exports one phone column. We default to work_number; remap to mobile_number after upload if your subscribers' phones are consistently mobile numbers.
What about unsubscribed contacts?
Filter rows where Email Permission Status is 'Unsubscribed' before upload to avoid importing contacts who've opted out.
Will this create duplicate contacts in Freshsales?
Freshsales uses email as the unique identifier on contacts. Contacts with matching emails update the existing record. New emails create new contacts.
What about Constant Contact custom fields?
Custom fields appear in the export with their Constant Contact names. This template maps the standard fields only. Add custom fields manually in Operelio after uploading.
