How can I import into a Multi Picklist field? | Community
Skip to main content
Yifat_Danieli
Yifat_Danieli
Level 3
September 13, 2017
Question

How can I import into a Multi Picklist field?

  • September 13, 2017
  • 1 reply
  • 1844 views

Does anybody knows how to import from a CSV into a Multi Picklist field?

I've defined the field in Salesforce to be a Multi Pick List - now what?

How do I define it in Marketo?

Which changes do I have to do in my Excel?

I thought of maybe dividing to columns called by the same field name, would that work? Any best practice for that?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Josh_Hill13
Josh_Hill13
Level 10
September 13, 2017

This is also in the forums.

Multi Select boxes are defined in Marketo as

Value 1;Value 2; Value 3

so you need to use the CONTAINS or actually list out the combinations you want. You must do this as well in the Form. This is one reason I do not recommend Multi Select use in Marketo.

This also means you need to be careful with list uploads because CSV and semi-colons could get confused by some people. But it should work if you do one column and then use semi-colons inside each "cell".

if you divide the CSV into separate comma separated columns, you will have problems. I'd run some tests to figure this out for yourself.

    Terms & ConditionsAccessibility statement

    Loading footer...