Importing your Mailchimp Audience Segments into Excel lets you analyze specific subscriber groups without manual exports. In this tutorial, you’ll connect Coefficient and load segment data in under five minutes.
TLDR
-
Step 1:
Install Coefficient in Excel and authenticate Mailchimp.
-
Step 2:
Import “Audience Segments” via “Import from Objects.”
-
Step 3:
Optionally schedule auto-refresh for live updates.
Step 1: Installation and Connection
In Excel, go to Insert › Get Add-ins › search “Coefficient” › Install. Open the Coefficient sidebar and sign in to Mailchimp.

Step 2: Import Audience Segments Data
Select “Import from Objects,” choose “Audience Segments,” then click “Import.” Your segment definitions will populate the sheet.

Step 3: (Optional) Set Up Auto-Refresh
Click “Refresh” › “Schedule” in the Coefficient pane. Pick a cadence—daily or hourly—for automatic segment updates.

Available Mailchimp Objects
- Audience
- Campaigns
- Audience Activity
- Audience Growth History
- Audience Locations
- Audience Segments
- List of Audiences
- Conversations
- Contact List
- Reports
- Audience Clients
- Audience Interest Categories
- Audience Webhooks
- Automations
- Connected Sites
Frequently Asked Questions
Trusted By Over 50,000 Companies