Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

CSV Import Multiple Select Values

Topic Labels: ImportingExporting
18354 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Shomrei_Emunah
6 - Interface Innovator
6 - Interface Innovator

Trying to import via CSV file Multiple Select Values. I want to import Value1, Value2, Value3 as three separate multiple select items. If I separate the values in the cell of the CSV file with commas I get one item “Value1, Value2, Value3”.

is there some delimiter i need to use between seperate values?

Thanks.

12 Replies 12

Brilliant! Worked!!! Thank you for saving me LOTS of time!!!

jhoneybairstow1
4 - Data Explorer
4 - Data Explorer

Yes, when importing multiple select values from a CSV file, you need to use a specific delimiter to separate the individual values within a cell. Since using commas as the delimiter may cause confusion with the commas already present in the multiple select values, you can choose a different delimiter that is not used in the data.

A common choice for such scenarios is to use a pipe symbol, as the delimiter. This symbol is not commonly found in text and can serve as a clear separator for multiple values.

 

Matt_Kennedy1
7 - App Architect
7 - App Architect

Convert the column type to single line text, then convert back to multi-select.