The Scenario
You are the marketing ops lead at a nonprofit. Your organization has been on Mailchimp for six years. 8,000 members in the main audience. You are migrating to a new email platform next quarter.
Before the migration team will start the import, they want a full audit workbook: every member's email, subscription status, tags, and last campaign open date. They need it by Monday morning.
It is Thursday.
The bad version of the next four days:
- You go to Mailchimp's audience export and download the members as a CSV
- You open the file in Excel and discover the "tags" column is a single cell with all tags comma-separated
- The "last campaign activity" column is blank for 40% of members
- You start reformatting columns, splitting tags, handling blanks
- Saturday afternoon you realize the export you downloaded Thursday does not match the current list because 30 people unsubscribed since then
- You walk into Monday's meeting with stale data and half-formatted columns.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your workbook that pulls a live audience snapshot from Mailchimp and writes it into the Audience tab, without downloading or reformatting a CSV file.
Open the SheetXAI sidebar and type:
Export all members from Mailchimp audience ID in cell A1 and write email, first name, last name, subscription status, tags as a comma-separated list, and last campaign open date into columns A through F of the Audience tab. One member per row. Include all statuses: subscribed, unsubscribed, cleaned, and pending.
SheetXAI fetches all 8,000 members from the live audience and populates the Audience tab. If you run the same prompt on Sunday night, you get the same structure but with current data.
What You Get
8,000 rows in the Audience tab, one per member, pulled live from Mailchimp:
- Email and name — as stored in the audience
- Subscription status — subscribed, unsubscribed, cleaned, or pending
- Tags — as a comma-separated list in one column
- Last campaign open date — the most recent date that member opened a campaign, blank where no activity exists
The migration team has a working file by Thursday afternoon. They can filter by status, count tag coverage, identify inactive subscribers, and build their import mapping without waiting on you.
What If the Data Is Not Quite Ready
Audience audits rarely stop at the raw export. SheetXAI handles enrichment and reshaping in the same prompt.
When Mailchimp returns the last open date as a UTC timestamp string
The API returns "2025-11-14T09:23:00+00:00" and the migration team wants just "2025-11-14."
Export all members from Mailchimp audience ID in cell A1 into the Audience tab. Format the last campaign open date as YYYY-MM-DD only. If last open date is null, write "Never."
When the migration team wants a summary count at the top
They want total by status before they open the detail rows.
Export all members from Mailchimp audience ID in cell A1 into the Audience tab starting at row 5. Before the member rows, write a summary in rows 1 through 4: total subscribed in B1, total unsubscribed in B2, total cleaned in B3, total pending in B4.
When the audit needs to flag low-engagement subscribers
Members who have never opened a campaign are likely to hurt deliverability at the new platform. The migration team wants them flagged.
Export all members from Mailchimp audience ID in cell A1 into the Audience tab. For each member, write "Low Engagement" into column G if last campaign open date is blank, or "Active" if it has a date. Include all other columns: email, first name, last name, status, tags, last open date.
When you also need the unsubscribe and hard bounce history in a separate tab
The suppression list for the new platform needs not just who is currently unsubscribed, but which campaign triggered each unsubscribe.
In the Audience tab, export all subscribed members from Mailchimp audience ID in cell A1: email, first name, last name, tags, last open date. In a second tab called "Suppression," fetch all members with status unsubscribed or cleaned and write their email, status, the date the status changed, and the last campaign they received before unsubscribing.
The pattern: pull the full audience in one prompt, then enrich or segment in a follow-up. Re-run on Sunday night and get current data without starting over.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to export your full Mailchimp audience. The Mailchimp integration is included in every plan. For related workflows, see how to pull quarterly campaign performance stats from Excel or the Mailchimp in Excel overview.