How to Import Audience Locations Data from Mailchimp into Excel

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

Learn how to import your Mailchimp Audience Locations into Excel using Coefficient for geographic insights.

“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 Audience Locations into Excel helps map subscriber distribution worldwide. In this guide, you’ll connect Coefficient and import location data in minutes.

TLDR

  • Step 1:

    Install Coefficient and authenticate Mailchimp in Excel.

  • Step 2:

    Import “Audience Locations” via “Import from Objects.”

  • Step 3:

    Optionally schedule auto-refresh for up-to-date maps.

Step 1: Installation and Connection

In Excel, click Insert › Get Add-ins › search “Coefficient” › Install. Open the sidebar and log in to Mailchimp.

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

Step 2: Import Audience Locations Data

Select “Import from Objects,” choose “Audience Locations,” then click “Import.” Your geographic data will load into the 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. Select your frequency—Coefficient keeps location data fresh 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 Audience Locations from Mailchimp?

    down-chevron

    Select “Import from Objects” › “Audience Locations” › “Import.” Coefficient pulls geographic data into Excel.

  • Can I filter by country?

    down-chevron

    Yes—add a filter on the “Country” field in the import dialog. Coefficient applies filters before import.

  • How to visualize locations on a map?

    down-chevron

    Use Excel’s 3D Maps feature on the imported data. Coefficient keeps the source live for dynamic updates.

  • How to automate importing locations weekly?

    down-chevron

    Go to “Refresh” › “Schedule,” choose weekly. Coefficient will refresh location data every week.

  • How to get alerts about new location data?

    down-chevron

    Create a Coefficient automation that emails you after each Audience Locations import.

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

Trusted By Over 50,000 Companies