Already using Google Sheets to manage orders? Now you can track delivery status without leaving your spreadsheet — on any device, including Mac.
Why Google Sheets?
Unlike Excel VBA macros (Windows-only), Google Apps Script works everywhere:
- Mac, Windows, Chromebook, even mobile
- No software to install — runs in the browser
- Easy sharing — just copy a link, no file downloads
- Free — Google Sheets is free with a Google account
Two Ways to Get Started
Option 1: Copy Our Template (Easiest)
- Click here to make a copy
- A “WhereParcel” menu appears at the top
- Click WhereParcel > Setup All (use the menu, not the button — this installs the triggers)
- Done — start tracking! Checkbox buttons now work too.
Option 2: Add to Your Existing Spreadsheet
Already have an order management sheet? Add tracking to it:
- Open your Google Sheet
- Go to Extensions > Apps Script
- Delete any existing code
- Download Code.gs and paste the contents
- Press Ctrl+S to save
- Go back to your spreadsheet and refresh the page
- A “WhereParcel” menu appears — click Setup All
This creates Settings, Tracking, Carrier Codes, and Instructions sheets automatically. Your existing data sheets are untouched.
How to Track Parcels
- Enter carrier codes (column B) and tracking numbers (column C) in the Tracking sheet
- Go to WhereParcel > Register Tracking
- Wait 5-10 seconds
- Go to WhereParcel > Fetch Results
Results populate automatically: delivery status, location, receiver name, and timestamps.
Smart Carrier Codes
You don’t need to memorize carrier codes. Just type the common name:
| You Type | Becomes |
|---|---|
ups | us.ups |
fedex | us.fedex |
dhl | intl.dhl |
yamato | jp.yamato |
royal mail | gb.royalmail |
cj | kr.cj |
The script normalizes them automatically. Need a specific variant? Use the full code like de.dhl for DHL Germany.
Color-Coded Results
Results are color-coded for quick scanning:
- Green — Delivered
- Blue — In Transit / Out for Delivery
- Orange — Pending
- Red — Failed / Returned / Cancelled
200+ Carriers Supported
The full carrier list covers 19 countries:
- US: UPS, USPS, FedEx, DHL, Amazon Logistics
- Korea: CJ Logistics, Lotte, Hanjin, Korea Post
- Japan: Yamato, Sagawa, Japan Post
- UK: Royal Mail, DPD, Evri
- Germany: DHL, Hermes, DPD
- International: DHL Express, EMS, Aramex, TNT, Cainiao
Check the “Carrier Codes” sheet for the complete list.
Google Sheets vs Excel — Which Should I Use?
| Google Sheets | Excel | |
|---|---|---|
| OS | Any (Mac, Windows, Chromebook) | Windows only |
| Install | None — browser-based | Download .xlsm file |
| Sharing | Link sharing | File sharing |
| Offline | Limited | Full |
| VBA macros | No (Apps Script instead) | Yes |
Use Google Sheets if you work on Mac, share sheets with a team, or prefer browser-based tools.
Use Excel if you work offline or already have an Excel-based workflow. Download the Excel version.
Tips
- First-time authorization: Google will ask you to authorize the script when you first run it. This is normal — the script needs permission to make API calls.
- “Untracked Only” mode: Set this in Settings to skip rows that already have results, saving API usage.
- Batch processing: Up to 100 items per batch, automatically split for larger sets.
Get Your API Keys
The template comes with demo keys for testing. For production use with higher limits, sign up for free.
Need help? Join our community or check the Excel & Google Sheets tracker page for more details.