Odoo Help


How can I import a complet chart of accounts from excel file to OpenERP?

fougeron léa
on 4/25/13, 6:34 AM 12,677 views

I've got a chart of accounts on excel file and I want to import all of it in OpenERP? How and where can I do this?


michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 4/25/13, 6:45 AM

Menu Accounting -> configuration-> Accounts -> import

Before importing you should export the existing accounts to create a file template (CSV format, UTF-8); you will reuse the column names for your own excel file (transform it into a csv file).




| 5 6 8
Cornwall, Canada

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

On 4/25/13, 8:16 AM

Probably you should read this: https://accounts.openerp.com/forum/Help-1/question/105/

Note that there have been many questions about this in the recent past.

Type import chart into the search box above and skim through the listed questions. You will find the answer you require or enough description of the experience of others to be able to reframe your question into something more specific.

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

2 follower(s)


Asked: 4/25/13, 6:34 AM
Seen: 12677 times
Last updated: 3/14/18, 12:12 PM