Importing Mailchimp contacts into Trackdrop

Sending promos to your contacts with Trackdrop is simple for Mailchimp users. 

All you need to do to get started is to export your contacts from Mailchimp, then use our CSV importer to check the details and add them to your audience. 

Step one: export your contacts from Mailchimp 

1. Log in to your Mailchimp account.

2. Click Audience in the left sidebar, then select All contacts.

3. Optional: Click Columns to customize the data you export. 

4. Click Export Audience (top-right of the contacts table).

5. Mailchimp will prepare a ZIP file and email you a download link, or let you download it directly from the page.

6. Unzip the file - inside, you'll find a CSV named something like audience_export_*.csv.

This CSV file is what you'll need to upload your contacts to Trackdrop.

Step two: upload the CSV to Trackdrop

1. Log in or sign up to Trackdrop. 

2. Click Audience in the menu bar on the left. 

3. Click the Add contacts button near the top of the screen, then click Import from CSV.

4. Drag the exported CSV file into the upload area, or click to browse for it.

5. On the Select header step, confirm that row 1 is highlighted as the header row (it will be, for a standard Mailchimp export).

6. On the Map columns step:

   • Email Address will be mapped to Email automatically.

   • For Name, see the next section.

7. Optional: you can add tags to help organize your audience list.

   • Bulk tags will be applied to all the contacts you’re importing. 

   • If you want to sort your contacts later, you can skip this step for now.

8. Click Import contacts to finish.

Once your contacts have been imported, you’re ready to create and send your first promo! [​​Link to "Creating a promo"]

Why isn't my contact name mapped automatically?

Mailchimp exports first and last name as two separate columns (First Name and Last Name), but Trackdrop stores a single Name field.

Because neither column is an exact match, you’ll need to select the column you’d like to import. You have two options - 

Option A: Select one column (quickest) 

On the Map columns step, find the Name row and use the dropdown to select either First Name or Last Name. Leave the other unmapped. Your contacts will be imported with whichever value you chose.

Option B: Combine the first and last names before importing

Before uploading, open the CSV in a spreadsheet app (eg. Excel, Google Sheets, Numbers) and create a new column called ‘Name’ that combines the first and last names:

You can manually copy or type the names into the rows in the Name column, or you can use a formula. 

Assuming Name is column A, First Name is column B, and Last Name is column C: Enter =B2&" "&C2 into column A, and copy the formula into the cells below. 

Once you’ve created the combined ‘Name’ column, save the file as a CSV, then upload it. Trackdrop will auto-map the Name column, and each contact will be imported with their full name.

Common issues