One Easy Excel Formula to Track Shipments

Wouldn’t it be awesome if a Microsoft Excel formula could automatically pull tracking information for shipments sent via UPS, FedEx, USPS, YRC, and other major carriers? Well – you can. Jimmy Pena from ShipTrackAddin.com has created a great Excel add-in that does just that. Best of all, it’s free (although the author does accept donations if it helps save you time and effort in tracking shipments).

How it Works

After a quick download and an easy install of the add-in, your Excel will have a new formula called ShipTrack. Then, you just use the ShipTrack formula in your spreadsheet just as you would use a SUM formula. For example, I would type the following into a cell:

=ShipTrack(301571615207567,”FedEx”)

After a second of grabbing the information from the FedEx servers, the cell would return this value:

Delivered Monday, January 13, 2014 at 5:53 PM at signed by MMORRALIS FEDEXGROUND

It’s as easy as that. If you have a long list of tracking numbers, you can just copy the formula down and it will populate them all instantly.

You can also use references in the formula, so the following would work just as well:

ShipTrack2

ShipTrack1

Carriers Included in ShipTrack

Perhaps the best part about the ShipTrack formula add-in is the long list of carriers it covers. The current version, 4.3.1, supports the following carriers:

Carriers Included in the ShipTrack Formula
  • A1 Express
  • A-1 International
  • Blue Dart
  • CEVA Logistics
  • CMA-CGM
  • Conway Freight
  • DHL
  • DHL Global Forwarding
  • Expeditors
  • FedEx
  • Lasership
  • New England Motor Freight
  • Old Dominion
  • Ontrac
  • Pegasus Logistics Group
  • Purolator
  • R+L Carriers
  • Rworld Couriers
  • Safmarine
  • SAIA LTL Freight
  • TCIXPS
  • TNT
  • United Parcel Service (including LTL)
  • U.S. Postal Service
  • YRC Freight
  • YRC Regional (including New Penn, Holland, Reddaway)

Carriers are also being added regularly, so check the site to see if a specific carrier is in the works to be added.

Download the ShipTrack Add-in for Free

You can learn more and download the ShipTrack add-in over at ShipTrackAddin.com.

Share this article

    Leave a Reply

    Your email address will not be published. Required fields are marked *