Odoo Help


This community 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.


Export product list, Add products, Import New list

on 3/21/13, 8:22 AM 1,799 views

Hi everyone,

  1. So i've inserted several products with as much as details possible.
  2. After that, I've selected the fields I was interested in and exported in CSV files (because excel don't work for me).
  3. Now I have a CSV file with , ; / ;; etc..

What do I need to do to open it clearly on excel? And after that, how to import this new list with many products added?

I cannot add my CSV file here but I can send it in PM if needed.

Thank you!

On 3/21/13, 8:44 AM

Just open excel (or any other option like LibreOffice Calc) and go to File/Open and select your .csv file

A wizard will be launched where you will be able to select the desired separators for rows/columns and that is it, the program will do all the work. I use " as text delimiter, ; as separator and 'UTF-8' as encoding. You can also select in a previous that will see every column and select the type of it (e.g. date, text). This works for me using LibreOffice Calc, it might be suitable for you to, but maybe you have to change a few details, but the overall picture looks the same.

After that, to save the file again as a .csv to import into OpernERP, just go to 'File/Save as...' and select .csv where it says file format (or something like that, the place where you can choose the extension of the file).

Hope it is the same with Excel (or at least that you can figure it out from this tips)!

Dear Lucio, thank you for your quick answer. I'm a little further...

But when I validate import on openERP (utf-8) , (Semicolon) , (") I have this red line "incorrect padding"

on 3/21/13, 9:55 AM

Ok, great! Can you please add some of the csv to your question to see where the problem can be coming from? (Obfuscate the data if you want! )

on 3/21/13, 10:04 AM

You are using ' / ' (slash) as separator, not ' ; ' (semicolon).

on 3/21/13, 11:46 AM

Sorry but I need to use (comma) as separator when I import on openerp. If I use semicolon I only have one column "A single column was found in the file, this often means the file separator is incorrect "

on 3/21/13, 12:12 PM
On 3/21/13, 12:13 PM

image descriptionimage descriptionimage descriptionimage descriptionimage description

Ok, I see and seems right but the csv line that you copy-pasted here is using ' / ' as separator, not comma, maybe it is a bug on the openERP exporting tool or something.

Also, in the preview in the, where you can set the type of each column, you are getting the correct view as it is. What happens if you change 'Virgule' for another thing (like 'point-virgule' for example)?

on 3/21/13, 12:54 PM

Maybe because I am still on the trial version? I've inserted more images...

on 3/21/13, 1:16 PM

OK it works !

I followed your steps and used openoffice and I can Import/Export everything :-D (i'm very happy)

on 3/22/13, 11:38 AM

You can mark it as answered then :D

on 3/22/13, 11:56 AM
On 3/21/13, 9:52 AM

Dear Lucio, thank you for your quick answer. I'm a little further...

But when I validate import on openERP (utf-8) , (Semicolon) , (") I have this red line "incorrect padding"

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 3/21/13, 8:22 AM
Seen: 1799 times
Last updated: 3/16/15, 8:10 AM