Tip #477: Exporting marketing list members to dynamic spreadsheets

One thing you may notice when on a marketing list record, the Export to Excel button doesn’t give you as many options as you are used to when you click it from the marketing list members view.

export contacts

No Excel Online option or Dynamic Worksheet. Does this mean that it can’t be done? Not necessarily, just not in that way.

Using Advanced Find, create a view of contacts filtered on the related marketing list entity.

Screenshot 2015-09-09 17.08.48

From this view you will be able to export to Excel, including Excel Online and dynamic worksheets.

7 thoughts on “Tip #477: Exporting marketing list members to dynamic spreadsheets

  1. What is ‘Count’ button on the form? Custom button for calculation number of retrieved records?

  2. Omar Sharif says:

    That worked! Thanks for your help.

    Best Regards,
    Sharif

  3. Ross says:

    I thought this article may help me as when creating a marketing list there was about 700 less contacts in it compared to a view created with the same queries. Except when I created the new view pulling the data from my marketing list as explained above, it returned no results. Anyone got any ideas on what I am doing wrong or what could be wrong?

    All the best, Ross

    • Alan says:

      Hey Ross, this will not work for Dynamic Marketing Lists. So that might explain where your missing contacts are.

  4. Jorge Olivé says:

    Indeed, word of warning: This trick won’t work for dynamics marketing lists. If you really need to perform this action, you can do through copying the list content to a static list and simply export from there.

Leave a Reply

Your email address will not be published. Required fields are marked *