Export Data in Excel/CSV
These are steps to export any data from a Doctype to Export/CSV format. Currently, you have to use Data Import for this:
1. Go to Data Export in your instance.
2. Select Document Type. Accounts for Chart of Accounts, Item, and so on along with the File Type (Excel/CSV).
3.Select the list of fields to be exported.
4.You can click on Add Filter to export data based on specific conditions.
5.Once you are ready, click on the Export button.
This will export all your data in spreadsheets. You can open the file and check the same if it has the correct values (say accounts).