Mailchimp
Copper People9 fieldsHow to import Mailchimp data into Copper
Export your Mailchimp audience and bring those subscribers into Copper. The template combines First Name and Last Name into Copper's single name field, then maps email, phone, the per-subscriber notes column, and the address block to Copper's snake_case fields. Copper calls contacts People.
Field-by-field mapping
This is the complete column mapping from Mailchimp to Copper. The left column is the header in your CSV export. The right column is the Copper field it should map to.
| Mailchimp column | Copper field | |
|---|---|---|
| First Name + Last Name | Name*name Copper uses a single name field on the People record, so we combine the two Mailchimp columns into one. TransformFirst Name and Last Name combined with a space | |
| Email Address | Emailemail TransformLowercased and trimmed | |
| Phone Number | Phone Numberphone_number TransformStandardized to international format (+1, +44, etc.) | |
| Address | Streetaddress_street | |
| City | Cityaddress_city | |
| State | Stateaddress_state | |
| Zip | Postal Codeaddress_postal_code | |
| Country | Countryaddress_country | |
| NOTES | Detailsdetails Mailchimp's per-subscriber notes land in Copper's native Details field on the Person. The free text is preserved verbatim. |
Required by Copper.
Columns we don't use
Your Mailchimp export includes 3 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Copper.
- MEMBER_RATING, OPTIN_TIME
Mailchimp's engagement score and opt-in timestamp are Mailchimp-specific. Copper People records don't have equivalent fields by default.
If you need it. Add custom number and date fields on the Copper Person called Member Rating and Opt-in Time, then re-run this template to map them.
- TAGS
Mailchimp tags export as a comma-separated string. Copper uses its own Tags feature, which is applied after import.
If you need it. After import, apply Copper Tags matching your Mailchimp tag values using Copper's bulk-edit tools.
Formatting and cleanup
Mailchimp exports rarely match the format Copper expects. Fix these before you import.
- 1.Combines First Name and Last Name into Copper's single name field
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Maps Mailchimp's address block to Copper's address_street, address_city, address_state, address_postal_code, address_country fields
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Mailchimp export and download a clean, import-ready file for Copper.
Mailchimp to Copper FAQ
How do I export my Mailchimp audience?
In Mailchimp, go to Audience, click View Contacts, then click Export Audience. Download the CSV when it's ready.
Why do you combine First Name and Last Name?
Copper People records use a single name field. The template combines the two Mailchimp columns with a space so each Person displays correctly.
What about unsubscribed Mailchimp contacts?
Mailchimp exports include subscribed and unsubscribed addresses. Filter unsubscribed rows out of the CSV before upload to avoid importing people who opted out.
Will this create duplicate People in Copper?
Copper deduplicates People on email by default. Subscribers with matching emails update the existing record. New emails create new People.
Where do I import the CSV into Copper?
In Copper, go to Settings, then Data, then Import Records, and upload the file Operelio produces. The import wizard matches the column headers to People fields.
