Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

CSV Import Multiple Select Values

Topic Labels: ImportingExporting
16018 11
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.

11 Replies 11

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.