Import multiple values with commas form Excel

Question

Anyone could advise how to import multiple values with commas form Excel
For example, import "Sport, Exercise" and "Fruits, Vegetables" to the "Tags" field in CRM > Customer

Tried to import as
"Sport, Excerise","Fruits,Vegetables"
but a warning of "Sport not found was shown, the system seems split the value by comma

I have created two tags with commas in the odoo form and export
The excel is separated to two rows which cannot be import back to odoo

Any way we can escape the commas in value, t

ivan liu · Answer

When one of the tags is "Sport, Exercise" that means it include comma in it, the system will split up to Sport and Exercise, but I would like to have a tag "Sport, Exercise".
I have tried semicolons but it is not working, it only accepts comma. Any way to change the delimiters ? When one of the tags is "Sport, Exercise" that means it include comma in it, the system will split up to Sport and Exercise, but I would like to have a tag "Sport, Exercise".I have tried semicolons but it is not working,

Thuy Ngoc · Answer

Hi ivan liu,
I think this video can help you (starting at 30:00 in this video):
https://www.youtube.com/watch?v=Auaqj6WtdcM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=5

Balagopal R · Answer

Hello,
Add the Tags value like the following and try to import
Image [2]

https://youtu.be/X0ADWmqLdAM [1]

[1] https://youtu.be/X0ADWmqLdAM
[2] data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwwAAAC4CAYAAABOzGuFAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAACEMSURBVHhe7d2/b9tY2ujxx7eP4ToO0orGpHPGmNkyC6Q1jfuWE6x2UzlFyrWMmTLZlbZM4dsK2C2DNdW6cLkbOHbnwFIbTPy2gvMH6J6HPBR/iKQom7RN6/sZcCJRNEXyiIfn4fnBlfF4PJGYf/zjH/L+/Xv7Dnj4/v3vf8vz58/tu3qcnp7K2dmZ/PWvf7Vz8NB5nid/+tOf7DsAAJqLgAFL

Rakesh Patel (patr) · Answer

*Use Semicolon Separator for Multiple Tags*: Odoo recognizes semicolons (;) as delimiters between multiple tag values in a single cell. So, if your tag values have commas within them, try formatting them in the Excel file like this: *"Sport, Exercise; Fruits, Vegetables"*

This question has been flagged

Enjoying the discussion? Don't just read, join in!