Skip to main content

USPS Tracking in Google Sheets: A Practical Guide for Sellers

· 8 min read
Your Package Tracker Team
The team behind Your Package Tracker

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.

The short path​

If you have Your Package Tracker installed, drop this into any cell:

=PKG_STATUS("9400111899223100012345", "USPS")

You'll see Delivered, In Transit, Out for Delivery, or Alert (USPS's word for exceptions). The formula works for every USPS service — Priority, First-Class, Parcel Select, Certified, Registered, international, and the hybrid products FedEx and UPS hand off to USPS.

The rest of this guide gets into the specifics sellers actually care about.

USPS tracking number formats (all of them)​

USPS uses more tracking number formats than any other carrier. The add-on detects all of them automatically — this table is just for your own sanity when reading a number:

Prefix / LengthExampleService
9400 1 (22 digits)9400 1118 9922 3100 0123 45USPS Tracking (Priority, First-Class)
9205 5 (22 digits)9205 5000 0000 0000 0000 00Priority Mail
9407 3 (22 digits)9407 3000 0000 0000 0000 00Signature Confirmation
9303 3 (22 digits)9303 3000 0000 0000 0000 00Certified Mail
9208 8 (22 digits)9208 8000 0000 0000 0000 00Registered Mail
EA/EC (13 chars)EA123456789USPriority Mail Express, International
CP / RA / RR (13)CP123456789USInternational Parcel, Registered
LC / LK / LZLC123456789USInternational First-Class
420 + ZIP (26–30)420 90210 9400 ...Embedded destination ZIP (strip it)

The 420 prefix: if you're pasting numbers from some shipping platforms, you'll see 420 90210 9400111899223100012345. The 420 plus 5-digit ZIP is a routing hint, not part of the trackable number. Strip it (or let the add-on handle it — it does).

Step-by-step: a USPS tracking sheet​

1. Install the add-on​

Extensions → Add-ons → Get add-ons → Your Package Tracker. 3 free lookups to test.

2. Lay out your sheet​

The columns a typical Etsy or eBay seller ends up with:

ColHeaderExample
AOrderEtsy-3104
BBuyer@pinkbunny22
CShipped date2026-04-15
DTracking #9400111899223100012345
ECarrierUSPS
FStatus(formula)
GSummary(formula)

3. The formulas​

F2:  =PKG_STATUS(D2, E2)
G2:  =PKG_SUMMARY(D2, E2)

PKG_SUMMARY is especially useful for USPS because it combines status + last location + timestamp. You get a sentence like In Transit — Jamaica, NY (arrived 4/18, 9:42 AM) instead of just a status word.

4. Bulk track the list​

For any sheet with more than ~20 rows, use Bulk Track Packages — don't fill-down the formula. USPS rate-limits aggressively and a 200-row drag will produce 200 errors.

  1. Your Package Tracker → Bulk Track Packages
  2. Tracking range: D2:D300
  3. Carrier range: E2:E300
  4. Output: Summary
  5. Start Bulk Tracking

The add-on paces, caches, and writes into the column right after your carrier column.

What each USPS product looks like when tracked​

Priority Mail & Priority Mail Express​

Most reliable tracking. You'll see: Acceptance → In Transit → Arrived at Regional Facility → Out for Delivery → Delivered. Express adds guaranteed delivery windows.

First-Class Package Service​

Tracks similarly to Priority. Sellers sometimes see longer gaps between scans — First-Class packages don't always get regional facility scans, so the timeline jumps straight from Acceptance to Out for Delivery. That is USPS's behavior, not a bug in the lookup.

Media Mail​

Tracks, but scans are even sparser. Media Mail is processed alongside standard mail and often has only 2–3 events across a 5–10 day journey. Set customer expectations accordingly.

Certified Mail / Registered Mail​

PKG_SUMMARY surfaces the key certified-mail event — the signature acceptance. For hard proof-of-delivery (the actual signed receipt), you still need usps.com; only the text event is exposed in the API.

Parcel Select / Parcel Select Ground​

This is the service FedEx SmartPost and UPS Mail Innovations hand off to. When those carriers hand a package to USPS, the 9400/9205-series USPS tracking number becomes active. You can track the final mile with either the FedEx/UPS number or the USPS number — the add-on resolves both.

International (EA/EC/CP/LC etc.)​

International tracking adds customs events: Departed Origin Country → Arrived at Destination Customs → Customs Clearance Processing → Released from Customs → Out for Delivery. Lots of packages stall at step 3 — that's the call-your-buyer moment.

Five USPS quirks that matter to sellers​

1. "Delivered" can precede the actual delivery scan by an hour​

USPS carriers sometimes scan packages as delivered while they're still on the truck, at the end of their route, to save time. If a buyer says "tracking says delivered but I don't have it," wait 24 hours before panicking.

2. "Alert" doesn't always mean something's wrong​

USPS uses Alert for things as minor as weather delay or missort routing correction. Look at the Last Event text to distinguish a real problem from noise. A reasonable rule: only escalate if Alert persists more than 48 hours.

3. First-Class to PO Boxes can skip the delivery scan​

Deliveries into a PO Box box-section sometimes never get a final Delivered scan — they just stop updating after Arrived at Post Office. Treat Arrived at Post Office, 3+ days ago on a PO Box recipient as likely delivered.

4. "Label Created" sits forever for Sunday drop-offs​

If a label is printed Sunday and handed to USPS Monday, it stays at Label Created until the Acceptance scan on Monday. No tracking engine can show what USPS doesn't scan. Your sheet won't show it either.

5. International tracking often stops once the package leaves the US​

Many destination-country post offices don't share their scans with USPS. You might see Departed Origin — ISC New York NY and then silence for 10 days. The buyer's local post office in Germany / Japan / Brazil has scans you can't see. This is not fixable from the US side.

A worked example: Etsy seller, 60 sales a week​

A one-person Etsy store doing ~60 orders per week, shipping mostly First-Class Package and Priority Mail.

Setup:

  1. One sheet per month: Orders_2026_04.
  2. Columns: Date, Order, Buyer, Tracking, Carrier (always USPS), Status, Summary, Notes.
  3. Morning routine: run Bulk Track Packages over the month-to-date range, takes 1–2 minutes.
  4. Conditional formatting:
    • Row turns green when Status = Delivered
    • Yellow when Status contains Out for Delivery
    • Red when Status contains Alert or Exception
  5. Filter view "Red rows only" is the daily customer-service queue.

Before: 60 buyers × potential message = 60 tabs open on usps.com on a bad day. After: one sheet, one filter.

Frequently asked questions​

Do I need a USPS developer account / Web Tools API key? No. The add-on handles the carrier integration. You never deal with USPS's developer portal.

Does it work with USPS Click-N-Ship tracking numbers? Yes — Click-N-Ship labels are standard Priority / First-Class numbers.

What about PS Form 3811 green card signatures? Not available via tracking APIs. You'll still need usps.com for the image. The event "Delivered, Signed for by [Name]" does appear in PKG_SUMMARY.

Can I track informed-delivery items / letters? Only packages and certified/registered letters have tracking. Standard letters don't get tracking numbers.

How fresh is the data? Results are cached per tracking number to save quota (cached reads are free). For a hard refresh, use =PKG_REFRESH(D2, E2).

What does it cost? 3 free lookups to try. Paid plans from $19/month. See full pricing.

The takeaway​

USPS is the carrier small sellers ship with most and track the worst — because usps.com is genuinely bad and because small sellers don't justify a logistics platform subscription. Google Sheets + one formula splits the difference: all your USPS shipments in one place, one status column, filter view for exceptions, done.

Install Your Package Tracker free from the Google Workspace Marketplace →

Shipping multi-carrier? See our FedEx, UPS, and DHL guides — or browse all articles.