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 all data

Maxime Meunier
on 8/28/14, 9:47 AM 857 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.

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

1 follower(s)


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