Upload Multiple Picklist Values from a .csv file | Community
Skip to main content
A
Anonymous
June 6, 2014
Question

Upload Multiple Picklist Values from a .csv file

  • June 6, 2014
  • 2 replies
  • 2867 views
Hello,

I'm importing an Excel spreadsheet, and one of the columns imports to a multi-picklist values, and can have more than one value in the list. How do I format this properly to import multiple values? Have done some research online, finding conflicting answers, and the tests are importing values as text fields.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Josh_Hill13
Josh_Hill13
Level 10
June 6, 2014
You can do this in Marketo using semi colon:

Marketing Rockstar; Marketing Maven; Marketing Cat

I would test this on a test lead FIRST to confirm it works. This is how Marketo views multi select values.
A
Anonymous
February 16, 2016

When building a multi picklist - where would you see all the values that someone has selected, would it show up in their contact view?

J
Adobe Employee
JohnCl9Adobe Employee
Adobe Employee
February 16, 2016

Hi Todd,

I would show up in the lead record in Marketo under the field name you uploaded to.  It would look like the list in Josh's response above.

John

Grégoire_Miche2
Grégoire_Miche2
Level 10
February 16, 2016

HI All,

FYI, using semicolons to separate the values can very tricky on some non english versions of MSOffice. In French, for instance, the default column separator for CSV files is the semicolon. As a result, one need to reprocess CSV files and replace semicolons with commas, but it your file has semicolons within field values, it completely breaks the import file, adding unwanted columns.

Of course, we can workaround this, but I just wanted to give a heads up for international companies.

-Greg

Terms & ConditionsAccessibility statement

Loading footer...