The import and export feature has always been one of the standard functions in Odoo. This results in numerous possible applications for us for various use cases. 

The reporting and analysis system of Odoo ERP is often keen about the info and data it gathers from the client. Odoo systematically stores and processes the info of a business to provide an accurate output. Within the case of the implementation of Odoo new to a company, we want to import all the past data into Odoo.

In Odoo, the user can import any kind of data in different formats. By default, Odoo imports data on any business using Excel (.xlsx) or CSV (.csv) formats. The user can easily import details like contacts, products, bank statements, journal entries, and sale orders to Odoo in any of the formats. Odoo provides import in almost all the models. By using this we can import data from the XL file and CSV file.

IN this blog we will explain to you how import and export features help us in Odoo and how we use both features.

How to Export Data : Let’s begin with “EXPORT”, to export a set of data into Odoo, you just need to select the respective data file in .csv or .xlsx format and upload it.

Steps : Go to the Sales Module > Orders > Action > Export. For reference you can see the screenshot below.


When you click on the export button you can see the form will popup, for reference you can see the screenshot below.

KB9IVFygIbHQTozz1ohdw z6RAW8wU5Szp3BecNcsjDXingYVRx5Is bLobq8RVXCbSzhEhiu9C2Aek7nMYgDWwvohcGhCFBToPrdAOVRvEg5bXthYYeg4sugfkrwcz96oRQPXvu

Now we shall add new data to the exported files.

OFmoZr68xojcyycUZuvnNwD93sOaof5QzCj42yRhs1HhxZfbZvDTMUtQHYkfnGZ0rvZWkeT148ZFyIn0HBOgIXRP7h0dxfzsd9H663YyAw SVvgwLoHgp HqID6xFGHipEH zFlv

So the exported file will be like this and we will add new data there.

How to Import Data : for this go to the Sales Module and see the dashboard. For reference you can see the screenshot below.

h9tSBnimqnhGhLJ2mm46OkFpOhK3nNGkY9EK8hXrHdfWNA0qyYle42 Y8lTxnWfUp4YS SavZ8qJ11KSWZCBAvJx379OvEA8vNr4guhAH zrA5f6Gp y1 GKRLNHFrFok1vuODcm

Then, go to the favorites options, you will be seeing the “Import records” option. For reference you can see the screenshot below.

FX3MzR8tURDx1rfzQwXoKWJBiS NPYuF p41A6Qgd2w3D3YgjijPPgBehgfZnHfL9hdQ6u6TWXcimifLP1bgfC p1Tgip83sN5LqVVF3grqrAP mH35LA rYE1XtP ZiWJntX5sp

We can load the Excel file or CSV file to import the data in Odoo.

Zg8vSoZGO fzu5xCjOoc8WAhLQUQWZJaIqbBnLYsyUBhOM4wGZESDzMKBNZt6Bkt3bJQ1FSnKKuTruN3w q0FUSwmGqWc1OJsuRfwAEP75sYG7UNBTgi9lPtMaqi 1nuxn2J Okd

Then click on the “Upload File” button to upload the file.

Through this process you can import and export data in Odoo.

Leave a Reply

Your email address will not be published. Required fields are marked *