• Import Subscribers to a List

    After creating a list in MailChimp you can import your opted-in subscribers or contacts. We offer many options for importing your list including uploading a CSV or tab delimited text file, copying and pasting from Excel, or importing directly from an integrated application. If you're using an application that doesn't…

  • View or Export a List

    From the View subscribers screen, you can view and export active subscribers and segments as well as the unsubscribed and cleaned addresses from your list. Below we walk you through how to view and export subscribers from your account and also show you how to view the subscriber export history…

  • Clean a List with Microsoft Excel

    MailChimp was originally built for companies that already have a list management system, but needed help with delivery. Since we clean your bounces for you in the list area, only those who clean an internal database manually would need to use these instructions. Instructions for removing duplicates from your list:…

  • Special characters aren’t working when I export my list to excel.

    If there is information in your list that contains special characters (like non English language characters), then you're probably not seeing your list export to excel the way you'd expect. There are 2 workarounds for you and both require saving the file rather than opening directly in Excel. Workaround 1:Rename…

  • Combine Address Fields in a List

    One of our awesome users provided us with this Excel hack to format the address field for use with our address field type: Create an empty column in your Excel spreadsheet Enter a formula in the first cell of that column that "concatenates" the contents of each of the address…