=PKG_STATUS_LIVE(A2,B2,TODAY())=PKG_STATUS_LIVE(A3,B3,TODAY())=PKG_STATUS_LIVE(A4,B4,TODAY())That's it. Paste a tracking number, write the formula, get the status — and it keeps refreshing on its own.
Popular carriers supported worldwide
One add-on, every region. Track parcels from 3,000+ carriers across 200+ countries — all from a single Google Sheets formula.
United States & Canada
UPS, FedEx, USPS, DHL, Canada Post
United Kingdom & Europe
Royal Mail, Deutsche Post, La Poste, PostNL, DPD, GLS
Asia-Pacific
Australia Post, Japan Post, SF Express, China Post, YunExpress, 4PX, Cainiao
And thousands more carriers supported through our global tracking network.
How the package tracker for Google Sheets works
Three steps. No config. No API keys. No setup screens.
- Install the add-on from the Google Workspace Marketplace. One click, no API keys.
- Write a formula like
=PKG_STATUS_LIVE("tracking_num", "carrier", TODAY())in any cell. - Forget about it. Drag the formula down for as many shipments as you have. They'll all stay up to date on their own.
Every Google Sheets tracking formula you need
Live formulas auto-update. Plain formulas only refresh when you ask.
PKG_STATUS_LIVE()LIVEAuto-updating current statusPKG_SUMMARY_LIVE()LIVEAuto-updating one-line summaryPKG_LAST_EVENT_LIVE()LIVEAuto-updating most recent eventPKG_EVENTS_LIVE()LIVEAuto-updating full event logPKG_STATUS()Manual / on-demand statusPKG_SUMMARY()Manual / on-demand summaryPKG_LAST_EVENT()Manual / on-demand most recent eventPKG_EVENTS()Manual / on-demand full event logPKG_REFRESH()Force a fresh lookup from the carrierPKG_QUOTA()How many requests you have left this monthThe only package tracker for Google Sheets that updates itself.
Every other parcel tracking add-on for Google Sheets makes you re-run a script, re-enter the formula, or click a "refresh" button every single time you want fresh data. Ours doesn't.
- Drag-fill across 500 rows. No rate-limit errors. No "too many requests" warnings.
- Cells refresh on their own. Pass
TODAY()as an argument and Sheets re-checks automatically. - Real-time updates from carriers. When the package moves, our backend hears about it within seconds and your sheet picks it up next view.
- One-click manual refresh. Need it now? Hit "Refresh Live Tracking" in the menu.
- Drag-fill breaks. Most cells return errors because the API gets rate-limited.
- Stale forever. Once a cell has a value, it never changes until you re-enter the formula.
- Polling on every read. Each refresh hits the carrier again — slow, wasteful, often blocked.
- Manual scripts. Run a macro, wait, hope nothing timed out.
How it works: we register your tracking number with the carrier network once, then the carrier pushes updates to our servers as the package moves. Your formula reads from a fast cache that's always fresh — no re-fetching, no rate limits.
Free to try — 3 shipments, no credit card
Install the add-on and track your first 3 parcels for free. When you're ready for more, pick a monthly plan.
Every plan includes live auto-updating + all carriers + email support. Full details
Package Tracker for Google Sheets — FAQ
What is the best package tracker for Google Sheets?
Your Package Tracker is a Google Sheets add-on that turns any spreadsheet into a live parcel tracking dashboard. You write a formula like =PKG_STATUS_LIVE("1Z999...", "UPS", TODAY()) in any cell, drag-fill it down hundreds of rows, and every status refreshes on its own — no scripts, no API keys, no manual reruns. It supports 3,000+ carriers worldwide.
Can I use this for parcel tracking in Google Sheets?
Yes — Your Package Tracker is built for parcel tracking in Google Sheets. Whether you call them packages, parcels, shipments, or consignments, the same =PKG_STATUS_LIVE formula tracks them from any of 3,000+ carriers worldwide, including UPS, FedEx, USPS, DHL, DPD, Hermes, Royal Mail, Australia Post, and more.
How do I track parcels in Google Sheets?
Install Your Package Tracker from the Google Workspace Marketplace, then write =PKG_STATUS_LIVE("tracking_number", "carrier", TODAY()) in any cell. The cell briefly shows "Registering…" and then displays the live carrier status. Drag the formula down to track an entire column of parcels.
Which carriers does the Google Sheets parcel tracker support?
All 3,000+ carriers — including UPS, FedEx, USPS, DHL, Amazon Logistics, Australia Post, China Post, Royal Mail, Japan Post, SF Express, Yamato, Canada Post, DPD, Hermes, GLS, and more. You can pass either the carrier name or the numeric carrier code.
Is there a free version of the Google Sheets package tracker?
Yes. Every new install gets 3 free parcel lookups — no credit card required. After that, paid plans start at $19/month for 200 parcels. Every plan includes live auto-updating, all 3,000+ carriers, and email support.
Do I need an API key to use this Google Sheets parcel tracker?
No. Most other "track parcels in Google Sheets" tutorials require you to sign up with a tracking API provider, generate a key, and paste it into Apps Script. Your Package Tracker has zero setup — install, write a formula, done.
Ready?
Install the add-on. Drag a formula across your shipments. Watch it stay fresh.
Get started for free