How to Import List of Audiences Data from Mailchimp into Excel

using Coefficient excel Add-in (500k+ users)

Learn how to import your Mailchimp List of Audiences into Excel using Coefficient for comprehensive list management.

“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”

5 star rating coeff g2 badge

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.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

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.

Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

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.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

  • How to get List of Audiences from Mailchimp?

    down-chevron

    Use “Import from Objects” in Coefficient, select “List of Audiences,” and click “Import.” All audience lists load instantly.

  • How do I get a list of List of Audiences in Mailchimp?

    down-chevron

    Open Coefficient › “Import from Objects” › “List of Audiences.” Click “Import” to fetch every audience list.

  • How do I import List of Audiences from Excel to Mailchimp?

    down-chevron

    Edit audiences in Excel and use Coefficient’s “Export to Mailchimp” for two-way sync.

  • How to automate importing Mailchimp List of Audiences to Excel daily?

    down-chevron

    Go to “Refresh” › “Schedule,” choose daily. Coefficient will update your lists every day automatically.

  • How to send email alerts about List of Audiences data from Mailchimp?

    down-chevron

    Create a Coefficient automation to email you when the import completes.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies