Export Shipments from Shippo via CSV

Shippers often want the gritty details (numbers, dates, etc) from their past shipments. We've heard you loud and clear and 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 chosen date range.


How to Export Your Shipments

  • Open the Shipments Page in Shippo and click on the Export button at the top right of the page.
  • Enter your desired date range.
  • 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.





Date ranges allow for a maximum of 90 days for each export.


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?

Related articles