How to Import Mailchimp Subscribers in Google Sheet

Mailchimp users can directly import their email subscribers from any mailing list in Mailchimp to Google Sheets.

Mailchimp

Go to the mail merge menu in Google Sheets and choose Import Contacts > From Mailchimp Lists.

You'll have to authorize the connection so that Google Sheets can read and download your list of email subscribers.

Once the connection is authorized, select your Mailchimp list from the dropdown and choose Import Contacts to bring all the subscribers into Google Sheets.

Mailchimp to Google Sheets

tip

If you are using Constant Contact, Active Campaign, Convert kit or another email marketing tool, you can also import email subscribers from those services into Mail Merge sheet using the CSV import option.