Export Data in Excel/CSV
To export any data from a Doctype to Export/CSV format, follow these instructions. Currently, Data Import is required for this:
Open your instance's Data Export page.
Decide on the Document Type. Accounts for the Chart of Accounts, each Item, and the File Type (Excel/CSV) are included.

3.Choose the list of fields you want to export.
4.You can export data based on certain criteria by clicking Add Filter.
- When you are prepared, select Export.
Your entire data will be exported in Excel form. You can open the file and verify that the values are valid (say accounts).