Export Data

Dashboard Reports

Purpose:

To allow customers access to their shipment data for months at a time.

Requirements:

• Line items cannot be exported from the Dashboard Reports.

Step By Step:

Step 1

Navigate to ship.desktopshipper.com and Select the month & year by clicking the calendar icon within the Monthly Report Files.

Step 2

After you have selected the month & year you need you will click the "Click to Download" button to begin processing the file.

Step 3

You will then select the "GenericDetailsReport.zip" button.

Step 4

After your file is downloaded you will look in your downloaded files for the excel spread sheet

Step 5

When you open your excel sheet you will see your tracking numbers not in a proper format, to change this you will highlight the "Tracking & Alt Tracking numbers" and press the drop-down menu where it says "General" and select numbers.

Step 6

To get rid of the decimals, you are going to press the "Decrease decimals" button 2 times

Step 7

You will then go to File > Save As > then rename your file to the appropriate month.

Order Manager Exports

Purpose:

To allow customers access to their order data.

Requirements:

• Line items can be exported from the OM.
• Data is only saved for up to 2 months.
• Custom Exports are available for 2022 and newer data. These can be requested by talking to our sales team. 

Step By Step:

• Select All
• Individually Click
• Shift-Click. See how-to Click Here.

5. Select Export in the top right of the grid.

• You can select which fields you would like to export by selecting the filter Icon. 

VSB Export

(void and search shipments)

Purpose:

To allow customers access to their package data.

Requirements:

• Line items cannot be exported from the VSB.
• Data is only saved for up to 2 months.

Step By Step:

• Select All
• Individually Click
• Shift-Click. See how-to Click Here.

5. Select Export in the top right of the grid.

Importing CSV/Txt Files into Excel

Purpose:

a how-to guide for importing CSV and Text files into Excel.

Requirements:

• Excel
• A CSV or Text file to import

Step By Step:

1. Open Excel

2. Select Data Tab 

3. Select Get Data> From File> From Text