Odoo Help


Importing from excel with Labels or mass asigning labels

Tristan Grootenboer
on 3/8/17, 9:49 AM 485 views


My problem is that I want to import all my customers (leads) with an excel sheet. But it is not possible to import them with a Label. I now have given them the label in the notes but I can't mass-assign a label to them. So my question is if it is possible to import with label from excel or to mass assign them a label when they are already imported.

I am using the web version of Odoo

Thanks in advance

What do you mean by "label"? Isn't it just the subject of a lead?

Ermin Trevisan
on 3/8/17, 1:35 PM

Hi Ermin,

We mean this label. (please see print screen)

Vriendelijk groetend,

Tristan Grootenboer
Mob.: +31 (0)6 3000 89 42 

Eikenlaan 14
3203 BK Spijkenisse
Email: tristan@studionewmedia.nl
Telefoon: +31 (0)181 - 657 062
Fax: +31 (0)181 - 616 493
Bezoek StudioNewMedia.nl
Bezoek StudioNewMedia.nl
Dit e-mailbericht is uitsluitend bestemd voor de geadresseerde. Als dit bericht niet voor u bestemd is, wordt u vriendelijk verzocht dit aan de afzender te melden. Studio NewMedia B.V. staat door de elektronische verzending van dit bericht niet in voor de juiste en volledige overbrenging van de inhoud, noch voor tijdige ontvangst daarvan. Voor informatie over Studio NewMedia B.V. raadpleegt u studionewmedia.nl.

Op 8 mrt. 2017, om 19:35 heeft Ermin Trevisan <trevi@twanda.com> het volgende geschreven:

What do you mean by "label"? Isn't it just the subject of a lead?

Ermin Trevisan

Sent by Odoo S.A. using Odoo.

Tristan Grootenboer
on 3/9/17, 3:47 AM

Bejaoui Souheil

--Bejaoui Souheil--
--Bejaoui Souheil--

Odoo developer,  functional and technical consultant


Bejaoui Souheil
On 4/21/17, 3:46 AM


First you have to import all tags used for leads.

1- Activate the developer mode (this how)

2- Go to CRM/Configuration/Leads & Opportunities/Lead Tags

3- Import a file in this format


Now you can use tag name for leads import. Your file should look like

lead 1 name
lead 2 name


Best regards

On 3/9/17, 11:16 AM

I think the best way is to first import the tags in Odoo. 

The tags will get an ID. Click on a tag in the url you will see id=number  or use debug mode and view  the metadata.

Use the Id in your excel file. At the import use tag /database id . 

You can also use the XML ID to do the import. Than you use tag / external id 

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

3 follower(s)


Asked: 3/8/17, 9:49 AM
Seen: 485 times
Last updated: 4/21/17, 3:46 AM