Exports

Exports

Frappe has multiple ways to get data out. Pick by use case.

List view export

Any list (Sales Invoice, Customer, anything) has an export button in the Menu. You get CSV or XLSX of the visible filter set. Useful for ad-hoc one-offs.

Report Builder

Reports → Report Builder lets you build custom queries against any DocType, save them as named reports, and re-run on demand. Output is downloadable as CSV/XLSX or scheduled to email.

Query Report

For more complex reports with SQL or Python logic, developers create Query Reports in code (a .py and .json per report). End users see them in the Reports list and run them like any other.

API

For programmatic exports, use the REST API:

curl -X GET 'https://mysite/api/resource/Sales Invoice' \
  -H 'Authorization: token <api_key>:<api_secret>' \
  -d 'fields=["name","customer","grand_total"]' \
  -d 'filters=[["docstatus","=",1]]' \
  -d 'limit_page_length=1000'

See API for details.

Scheduled exports

Reports can be scheduled to email users via Report → Set "Send to Users" with a frequency. Useful for daily sales summaries, weekly stock positions, monthly P&L.

Audit exports

For SAF-T / XAF / Dutch tax exports specifically, see ERPNext Netherlands.