Skip to Content
This question has been flagged
4 Replies
761 Rodiniai
Portretas
ivan liu

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, thanks


Portretas
Atmesti
Portretas
ivan liu
Autorius Best 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, it only accepts comma. Any way to change the delimiters ?

Portretas
Atmesti
Portretas
Thuy Ngoc
Best 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

Portretas
Atmesti
Portretas
Balagopal R
Best Answer

Hello,

Add the Tags value like the following and try to import


https://youtu.be/X0ADWmqLdAM

Portretas
Atmesti
Portretas
Rakesh Patel (patr)
Best 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"

Portretas
Atmesti