Merge Mailchimp Exports (Email Marketing Guide)

You have three different audiences in Mailchimp. Or you exported your "Unsubscribed" list separately from your "Cleaned" list. Now you need them all in one place—maybe to move to a new platform, or just to analyze your total reach.

Merging Mailchimp CSV exports is a common task, but it requires care to avoid duplicates and data loss.

The Challenge

Mailchimp exports usually come as ZIP files containing multiple CSVs:

• subscribed_members_export.csv
• unsubscribed_members_export.csv
• cleaned_members_export.csv

Or you might have exports from different dates.

Simply copy-pasting them together isn't enough because:

1. Duplicates: A person might be "Subscribed" in List A but "Unsubscribed" in List B.
2. Columns: Different lists might have different merge tags (columns).
3. Status: You need to track who is active vs. unsubscribed.

Step-by-Step Merge Guide

Step 1: Unzip and Organize

Extract all your CSVs into one folder.

Step 2: Standardize Columns

Open each CSV. Ensure the core columns match:

• Email Address
• First Name
• Last Name
• MEMBER_RATING
• TAGS

If one file has a "Birthday" column and another doesn't, decide if you want to keep it. If yes, add an empty "Birthday" column to the other files so they align.

Step 3: Add a "Source" or "Status" Column

Before merging, add a column to each file identifying where it came from.

• In subscribed.csv, add a column Import_Status with value "Subscribed".
• In unsubscribed.csv, add Import_Status with value "Unsubscribed".

Why? When you merge, you'll want to know the status of each row.

Step 4: Combine the Files

Method A: Excel

1. Open the first file.
2. Open the second file.
3. Copy all data (excluding header) from File 2.
4. Paste at the bottom of File 1.
5. Repeat.

Method B: Merge Tool (Faster) Use a CSV merge tool to stack them automatically. -> Merge CSV Files

Step 5: Deduplicate (Crucial!)

Now you have one big file, but "john@example.com" might be in there twice.

Which one do you keep?

• Usually, you want the most recent status.
• Or you want to prioritize "Unsubscribed" (to ensure you don't accidentally email them).

1. Sort your merged file.
2. Use a "Remove Duplicates" tool.
3. Deduplicate based on Email Address.

Handling Tags

Mailchimp stores tags in a single column, comma-separated: "Newsletter, Customer, 2024-Lead".

If you merge two entries for John, you might want to merge his tags too, not just pick one row.

Complex Merge: Row 1: John, "Tag A" Row 2: John, "Tag B"

Desired Result: John, "Tag A, Tag B"

This requires a more advanced script or manual processing (Text to Columns -> Combine -> Join).

Re-Importing to Mailchimp

If you are merging to re-import:

1. Clean the list first. Remove bounces (Cleaned) and Unsubscribes if you only want to pay for active contacts.
2. Check the limit. Mailchimp charges by contact count. Don't import 10,000 old, inactive emails.
3. Map columns. When uploading, ensure your new Import_Status column maps to a tag or field so you know these contacts were part of the merge.

Summary

1. Standardize your columns.
2. Label your data sources (Status).
3. Merge the files.
4. Deduplicate carefully (respect Unsubscribes).
5. Clean before re-importing.

---

Merging lists? HappyCSV can combine multiple Mailchimp exports in seconds, handling headers automatically.