Export CSV in DPO

The CSV export provides a detailed overview of all costs from P.O.s, expenses, and invoices. In Excel, you can filter the data by department and supplier to monitor budgets, track spending, and quickly identify variances. This makes it ideal for reporting, whether you need data for P.O.s, invoices, or expenses.

Good to know

• The export feature lets you generate reports and transfer data to accounting software, showing current amounts, statuses, and details for P.O.s, invoices, and expenses/petty cash in a single export.
• You can also view all costs in one place by filtering by department in Excel.
• Additionally, you can assign a user role with export permissions, allowing team members in your organization to create exports and view the costs associated with their respective departments.

Create a CSV Export

1. Navigate to the Admin area and select the appropriate tab:

• Export → for P.O.s
• Export Expenses → for Expenses
• Export AP Automation → for Invoices

2. Enable “Export CSV2” by checking the box.
3. Click “REQUEST NOW”. This step is required for every export to ensure the most up-to-date data is included.
4. Refresh the page and verify that today’s date appears above the download button.
5. Click “DOWNLOAD”.

Open the CSV File in Excel

1. Open Excel and create a new workbook. Go to Data → Get Data → From Text (Legacy).

2. Select the downloaded CSV file and click “Import Data”.
3. Choose Delimited, make sure UTF-8 is selected as the file origin, and click “Next”.

4. Select Comma and Tab as delimiters, then click “Finish”.

(Check the preview to ensure the columns are displayed correctly.)

5. Click “Import” to load the data into Excel.

Filter Data by Department

1. Select the first row and enable Filters using the toolbar.

1. Open the filter of the column you want to use (e.g. “Department”), uncheck “Select All”, and choose the desired department.
2. Click “Apply Filter” to display the filtered results.

Questions or need help?

Our customer support is always available to help with any questions or setup assistance

Contact us

Email: support@digitalpurchaseorder.com

Support: +1 888 DPO 7254

Support Int'l: +44 20 331 88 338

Berlin Office: +49 (0)30 55 572 5956

Or book a personalized support call

We look forward to hearing from you.

Updated on: 29/05/2026