How to export data from DPO to Excel

How to export data from DPO to Excel

The export from DPO will export all of the data from the DPO project, from there you can then filter out what is needed.

In order to get the export, the admin will need to go to Admin > Export

Once on the export tab there will be a .csv file that the admin can download which will open up excel.

*Note, if the file does not open with excel then do the following:

1.      Save the export file from DPO and then open up a blank excel workbook

2.      Once in the excel workbook go to Data tab

3.      Once on the data tab then select the option 'From text/ CSV' 

4.      Locate the CSV file and then select the load option


    • Related Articles

    • Supplier List Export from DPO

      Export your data and open it in Excel as usual, to export the data the admin will need to go to Admin > Export and download the .csv file. Delete all of Columns A to Y (Project ID to Creator Position) After that delete from Column O onwards ...

    • DPO to Global Vista

      If your DPO project would like the export function to be enabled so you can import from DPO to Global Vista then you will need to email Sargent-Disc (support@sargent-disc.com) with the DPO project name and the currency codes you are using within GV ...

    • DPO to PSL

      If your DPO project would like the export function to be enabled so you can import from DPO to Global Vista then you will need to email Sargent-Disc (support@sargent-disc.com) with the DPO project name and the currency codes you are using within GV ...

    • Time zone of PSL/ Global Vista Export

      The PSL/ Global Vista exports will by default run at midnight - that is midnight based on the timezone of the user enabling the export. The export is enabled by going to admin > Export PSL or Export Global Vista and ticking the checkbox enabled like ...

    • Extra Fields on DPO

      If you would like additional text fields when creating a Purchase Order then then the admin can set this up by following the steps below. Go into Admin > Extra Fields DPO will allow you to have 3 extra fields, in order to set up an extra field click ...