Odoo Help


Export all data

Maxime Meunier
on 8/28/14, 9:47 AM 1,865 views


I'd like to know how to export every data from my BD to a CSV file? 

Thanks a lot,



Maxime Meunier
On 8/31/14, 11:42 AM

can someone help me with that issue ?

Nicholas Burdick
On 8/31/14, 4:42 PM


Are you asking how to dump an entire odoo database into a single flat CSV file?  I'm not sure that's possible or what that would even look like.  The odoo database is a relational database and is made up many tables, some of which link to each other via foreign key relationships.  You can dump certain parts into csv using the export, but typically only if they relate to each other somehow, such as sales orders and their associated order lines.

Perhaps we're misunderstanding the question?  If you can clarify a bit as to what you are trying to achieve with the csv dump, we can maybe help.


Michael St-Georges
On 8/31/14, 7:43 PM

What is the final purpose of this. As mentioned earlier a CSV file for the whole database wouldn't be practical (It's not impossible, but it's far from ideal and very far from easy). If what you need is a texdual dump of the whole database, you could use pg_dump. If you absolutely need it in CSV, I suggest limiting yourself to the absolute minimum you need to extract and extract it via the built-in extraction functions for which you will find a good guide here.

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

1 follower(s)


Asked: 8/28/14, 9:47 AM
Seen: 1865 times
Last updated: 3/16/15, 8:10 AM