Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 15, 2018 07:07 AM
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.
Sep 02, 2022 05:14 AM
Brilliant! Worked!!! Thank you for saving me LOTS of time!!!
Aug 02, 2023 04:15 AM
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.