Importing Currency field from CSV

[Shomrei_Emunah]

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.

[Dawn_Christense]

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

[jhoneybairstow1]

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]

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