Importing your Mailchimp List of Audiences into Excel lets you view and manage every audience at once. This tutorial shows how to connect Coefficient and import all lists.
TLDR
-
Step 1:
Install Coefficient in Excel and authenticate Mailchimp.
-
Step 2:
Import “List of Audiences” via “Import from Objects.”
-
Step 3:
Optionally schedule auto-refresh for up-to-date lists.
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 List of Audiences Data
Select “Import from Objects,” choose “List of Audiences,” then click “Import.” All audience names and IDs will load into your sheet.

Step 3: (Optional) Set Up Auto-Refresh
Click “Refresh” › “Schedule” in Coefficient. Choose daily or custom cadence—Coefficient will refresh your list of audiences automatically.

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