Odoo Help


how to import excel data into database?

on 2/21/14, 2:20 AM 11,163 views

I have BOMs and product details list in excel sheets. Is it possible to import those data to openerp database?


André Schenkels
On 2/21/14, 2:35 AM

Hi Sam,

It's possible to import the files. You should save the files as .csv (Comma Seperated Value). First you need to allow import of records, this is done under -> Settings -> General

Then you are allowed to not only create records but also import records. You can choose your csv file and select the correct columns for your products / boms.

After this press validate and OpenERP checks if the import will succeed.

Regards, André Schenkels

Thanks for reply. I want to add list of materials in excel sheet to database. Can you give more details if possible. I don't know how to arrange data as want by database. Product | Category| On Hand| this is what i have in my excel sheet.

on 2/23/14, 11:30 PM

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

0 follower(s)


Asked: 2/21/14, 2:20 AM
Seen: 11163 times
Last updated: 3/16/15, 8:10 AM