How do I export a list of existing entries for my custom field? | Community
Skip to main content
A
Anonymous
May 1, 2015
Solved

How do I export a list of existing entries for my custom field?

  • May 1, 2015
  • 4 replies
  • 1825 views
I have a custom field that has existed as a free form field in our CRM.  There is so much variability in the entries that now exist in Marketo.  How do I export a list of entries from Marketo?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Bruce_Jeffers
There may be an easier way than this....but here goes:

I'd create a custom view in the Lead Database which just shows that one field. Then I'd export the entire database into Excel (making sure to only use this particular view).  This will export just that one field value for every single lead, and the Excel file should just be one long column.

Then open the Excel file, and you can "Remove Duplicates" from that column. What you're left with is a single entry for each unique value.

Hope that makes sense. I'd be glad to clarify if needed.

4 replies

Bruce_Jeffers
Bruce_JeffersAccepted solution
Level 4
May 1, 2015
There may be an easier way than this....but here goes:

I'd create a custom view in the Lead Database which just shows that one field. Then I'd export the entire database into Excel (making sure to only use this particular view).  This will export just that one field value for every single lead, and the Excel file should just be one long column.

Then open the Excel file, and you can "Remove Duplicates" from that column. What you're left with is a single entry for each unique value.

Hope that makes sense. I'd be glad to clarify if needed.
    SanfordWhiteman
    SanfordWhiteman
    Level 10
    May 1, 2015
     ... just chiming in to say I agree with @Bruce.  This field might as well be "Last Name" -- text, no validation, duplicates must be allowed. You have to work with an export file to get a consolidated view.
    gkrajeski
    gkrajeski
    Level 10
    May 1, 2015
    If you only need the unique values of that field, Bruce's example should work.
    A
    Anonymous
    May 1, 2015
    This is perfect!  Thanks for the great suggestion!
    Terms & ConditionsAccessibility statement

    Loading footer...