Enable the "Import Chart Of Account" group.

Click on the "Import Chart Of Account" menu.

After that, this wizard will open enter details and apply it.

Success message looks like below.

Following COA are imported, Imported data with list view.

Following fields are imported.

About Fields

---

Column	invoice Model	Field Name	Description	Required
A	Chart of Accounts (account.account)	Code	You have to write a Code here.	Yes
B	Chart of Accounts (account.account)	Account Name	You have to write a Account Name here.	Yes
C	Chart of Accounts (account.account)	Type	Define the Type.	Yes
D	Chart of Accounts (account.account)	Default Taxes	Taxes are separated by comma(,). You have to provide Default tax here.	No
E	Chart of Accounts (account.account)	Tags	Define the Tags.	No
F	Chart of Accounts (account.account)	Group	Define the Group.	No
G	Chart of Accounts (account.account)	Allow Reconciliation	Define the Allow Reconciliation.	No
H	Chart of Accounts (account.account)	Deprecated	Define the Deprecated	No
I	Chart of Accounts (account.account)	Custom Fields	You can import custom fields from here. Please go to the "Custom Fields" tab for more details.	No

1) Don't remove the column from the sample sheet given, you can leave an empty column if the column is not the required type. You can see the table above for that.

2) Don't change the sample sheet column sequence.

3) Please don't use excel if you don't know the very well sheet formatting which is given in the sample sheet. Use CSV for hassle-free import without format issue. If you want to use excel and want to clear the format then please check this video.

4) Add Custom Fields or Non-Exist Standard odoo fields at the end, For adding those fields pls check the custom fields section.
Watch Video

Your CSV file format must match like below.

Your Excel/XLS/XLSX file format must match like below.

You can import any number of custom fields. All custom fields format must same as this.