Mailchimp2Excel

Built With

Visual Basic for Applications (VBA)

Installation

1. Download modules
2. Open Microsoft Excel
3. Open Visual Basic editor by pressing Alt + F11 or selecting it from the developer tab
4. File > Import File...
   • Import JSONConverter.bas Module
   • Import Base64Encoder.bas Module
   • Import Mailchimp2Excel.bas Module
5. Add Dictionary reference/class
   • For Windows-only, include a reference to "Microsoft Scripting Runtime"

Usage

• Select the sheet you would like to import your subscriber data into from the VBAProject window
• Within a Sub procedure call the get_list() sub.

 Sub your_sub_name()
   Call get_list("[YOUR API KEY]", "[YOUR LIST ID]", 100, "[YOUR SHEET NAME]"
 EndSub

• The parameter that contains 100 is the total number of subscribers you would like to import.
• Run your Sub procedure.
• Your data should now be displayed in the appropriate sheet!

Prerequisites

• Microsoft Excel
• MailChimp Account
• When saving workbook be sure to select Excel Macro-Enabled Workbook from save-as file type dropdown.
• Mailchimp API key
• List id

Resources

• Getting API key
• MailChimp API documentation
• Show the developer tab
• VBA-JSON documentation and installation
• base64 encode script

License

This project is licensed under the MIT license.