Export Shipments from Shippo via CSV

Shippers often want the gritty details (numbers, dates, etc) from their past shipments. We've got you covered!

Shippo has an export feature that allows you to pull reports with all shipment data (e.g order numbers, recipient information, shipping rates, insurance paid, etc.). You can use this feature to aggregate information for monthly billing or to log the number of shipments you create in a given month.

 

How to export your shipments

1. Go to your Shipments Page in Shippo and click on the Export button at the top right of the page.

Screen_Shot_2018-05-16_at_12.31.16_AM.png

2. Enter your desired date range. Note: You are restricted to a maximum of 90 days at a time.

Screen_Shot_2017-05-08_at_12.05.54_PM.png

3. Click the green Export button.

Your report will be generated in a CSV file. You can then use this report to calculate shipping cost spent, or use the recipient information as an address book that you can reimport into Shippo.

 

Questions about excel's scientific notation

Microsoft Excel will sometimes reformat tracking numbers to scientific notation format (9.20559E+25). A quick solve is to upload your downloaded CSV file directly into your Google Drive and then “Open with” Google Sheets. Here are the steps:

1 - Export file from Shippo (don't open it in Excel!)
2 - Open your Google Drive
3 - Click "New" --> "File Upload" and select the file from your computer (or simply drag and drop the file in your Google Drive)

This should result in full tracking numbers!

 

To learn about importing a CSV file into Shippo you can view this article from our Help Center. 

Was this article helpful?
1 out of 4 found this helpful

Related articles