By installing the SeoTools for Excel add-in you get access to an set of features that are useful when working with online marketing. SeoTools includes a Mailchimp integration allowing you to query campaign, list and member stats directly in Excel.
Additional Information & Help
Access Mailchimp in Excel
Download SeoTools for Excel
Troubleshooting