Mailchimp to HubSpot: map the columns, import the CSV
Move contacts from Mailchimp to HubSpot: the audience export CSV columns matched to HubSpot’s import headers, renamed and fixed in one pass.
How the columns map
| Mailchimp column | HubSpot column | What changes |
|---|---|---|
Email Address | Email | HubSpot needs Email to create a contact, and its importer recognises the property by that name. Or by handopen the Email Address column’s ⋯ menu → Edit column… → click the name at the top of the drawer, rename it to Email and press Enter |
First Name | First name | HubSpot spells it First name, with a lowercase n. Or by handopen the First Name column’s ⋯ menu → Edit column… → click the name at the top of the drawer, rename it to First name and press Enter |
Last Name | Last name | The same goes for Last name. Or by handopen the Last Name column’s ⋯ menu → Edit column… → click the name at the top of the drawer, rename it to Last name and press Enter |
OPTIN_TIME | OPTIN_TIME | Mailchimp writes OPTIN_TIME with the time of day; a HubSpot date picker property takes the date alone, as day/month/year, month/day/year or year/month/day. Or by handopen the OPTIN_TIME column’s ⋯ menu → Format dates… → input YYYY-MM-DD, output YYYY-MM-DD (2024-12-31) → Save Rule |
TAGS | TAGS | HubSpot takes several values for one property joined by semicolons, and the options must exist before the import, so you map each tag to that property by hand. |
Before and after
8,200 contacts
Do it in DocTransform
By hand: 6 stepsDocTransform: 1 sentence
- 1. Upload mailchimp_audience.csv into DocTransform.
- 2. Type and press Send. Check the steps it adds; Undo takes them all back.
Write OPTIN_TIME as YYYY-MM-DD, then rename Email Address to Email, First Name to First name and Last Name to Last name
Or by hand
Apply the fixes: open the OPTIN_TIME column’s ⋯ menu → Format dates… → input YYYY-MM-DD, output YYYY-MM-DD (2024-12-31) → Save Rule. Then rename the three headers, one by one: open the column’s ⋯ menu → Edit column… → click the name at the top of the drawer, rename it and press Enter. Email Address becomes Email, First Name becomes First name and Last Name becomes Last name. The tags are yours to map by hand: DocTransform saves no step for them.
- 3. Download the cleaned file from Export, ready for HubSpot’s contact import.
Save these steps once, then rerun them on your next Mailchimp export with one click.
Do it by hand in Excel or Sheets
- Open mailchimp_audience.csv in Excel: choose Data → From Text/CSV, set File Origin to 65001: Unicode (UTF-8) and click Load.
- In row 1, change Email Address to Email, First Name to First name and Last Name to Last name. Leave OPTIN_TIME and TAGS as they are.
- Select the OPTIN_TIME column and press Ctrl+1 to open Format Cells.
- Choose Custom, enter yyyy-mm-dd as the format and click OK, so 2025-03-14 09:12:05 reads 2025-03-14.
- In HubSpot’s importer, map TAGS to a multiple-checkbox property you created first.
- Choose File → Save As, pick CSV UTF-8 (Comma delimited) (*.csv) and click Save.
Questions
- Can HubSpot import the Mailchimp export as it is?
- Not cleanly. HubSpot looks for its own property names, so Email Address, First Name and Last Name should become Email, First name and Last name, and OPTIN_TIME is safest as a date alone.
- Does DocTransform turn Mailchimp tags into a HubSpot property?
- No — it saves no step for that. Create a multiple-checkbox property in HubSpot first, then map TAGS to it in the importer.
- Do I redo these steps for every audience I move?
- No — save the steps once in DocTransform and rerun them on each Mailchimp audience you export.
Salesforce, HubSpot, Shopify, QuickBooks, Mailchimp, Pipedrive, WooCommerce, Klaviyo, Google Contacts, ActiveCampaign, Brevo, Zendesk, Square, Zoho CRM, and Xero are trademarks of their owners. DocTransform is not affiliated with them.