If you've ever set up package tracking in Google Sheets — with any add-on — you've hit the same wall. You drop a formula, it returns In Transit, you nod, and you move on. A day later you check back and... it still says In Transit. The package was actually delivered six hours ago, but the cell never refreshed.

Every other tracking add-on we've seen has this problem. The formula evaluates once and then sits frozen, until you re-enter it, run a script, click some "refresh" button, or worse — write an Apps Script trigger that pulls new data on a schedule and inevitably breaks. Your Package Tracker is different: our PKG_STATUS_LIVE formula keeps your sheet current on its own.

This guide explains how it works, how to use it, and why it's a meaningful difference for anyone tracking packages at any scale.

Here's the situation most shipping teams eventually land in. Monday's outbound: 40 packages via UPS Ground, 20 via USPS Priority, 8 via FedEx Express, 3 international via DHL, one oversized item via Estafeta, and two inbound supplier shipments via SF Express. That's six carriers, six tracking portals, and exactly zero good ways to see all of them in one place.

You don't actually need six tools. You need one column. This guide shows how to track packages from every carrier you use — side by side, in a single Google Sheet, with one formula that doesn't care who the carrier is.

If you ship packages for a living — or even just often — you will eventually run into the same problem: your shipments are split across too many carriers. A pallet via UPS, a batch of small parcels via USPS, an international express via DHL, an Etsy order via Australia Post, a bulk run via FedEx SmartPost. Each one has its own tracking portal, its own login, its own vocabulary for "in transit."

You don't want five tracking portals. You want one view of every shipment you've ever sent, searchable, sortable, and next to the order information.

This article compares the tools that solve that problem — their strengths, their pricing, who they fit best — and where the dead-simple "just use Google Sheets" approach beats the dedicated platforms.

"DHL" is really four different carriers sharing a logo. DHL Express is the air-freight giant that competes with FedEx Priority. DHL eCommerce (now "DHL eCommerce Solutions") is the lower-cost parcel service that hands off to local posts. Deutsche Post is the German postal service DHL is part of. DHL Parcel runs domestic in Europe. Each has its own tracking number format, its own system, and — until a sheet can query all of them — its own silo.

This guide shows how to track every DHL brand from a single Google Sheet column. One formula, every format, every country.

FedEx splits its tracking across half a dozen internal systems — Ground, Express, Home Delivery, SmartPost (now Ground Economy), Freight, International — and each has its own tracking number format. If you've ever pasted a batch of FedEx numbers into a spreadsheet and tried to sort them by status, you know the problem: ups.com and fedex.com don't talk to each other, and neither talks to your sheet.

This guide shows how to consolidate every FedEx service into one Google Sheet using a single formula, so all your FedEx shipments live in one place — next to your order IDs, customer names, and everything else you already track.

If you ship even a few packages a week, you have probably lived this scene: fifteen browser tabs open to carrier websites, a spreadsheet on one screen, and you manually copy‑pasting statuses back and forth. It is slow, error‑prone, and it does not scale.

There is a much simpler approach. You can track every shipment — across UPS, FedEx, USPS, DHL, and 3,000+ other carriers — directly inside a single Google Sheet using a tracking formula. This guide walks through exactly how to set it up, copy it to bulk rows, and keep the data fresh.

UPS is still the default carrier for an enormous amount of US e‑commerce — and anyone shipping at volume eventually hits the same wall: you have 80 UPS tracking numbers in a spreadsheet and no sane way to check their status without opening 80 browser tabs.

This guide shows how to pull live UPS tracking data — status, last location, delivery events — directly into any Google Sheet using a single formula. No UPS developer account, no API key, no Apps Script.

USPS volume has a flavor all its own: lots of packages, small margins, long tails of "where's my thing?" customer emails. If you sell on eBay, Etsy, Poshmark, Mercari, or run a small Shopify store, USPS is probably 60–80% of your shipments — and the tracking experience at usps.com has not meaningfully improved in a decade.

Google Sheets + one formula fixes it. This guide is the practical version — how to set it up, which USPS products it handles (Priority, First-Class, Media, Certified, Registered, international), and the quirks that come with USPS's own tracking inconsistencies.