Tool
Parcel Tracking for Excel & Google Sheets
Track delivery status in bulk directly from your spreadsheet — Excel VBA Macro · Google Apps Script · 39+ carriers worldwide
How to Use
-
Open the File
Open the
.xlsmfile and click "Enable Content" to allow macros.Or import the
.basfile into your own workbook via Alt+F11. -
Initial Setup (First Time Only)
Press Alt+F8 and run
SetupAll.This creates the Settings sheet, Carrier Codes list, Tracking sheet, and action buttons automatically.
-
Enter API Keys
Enter your API Key and Secret Key in the Settings sheet.
Demo keys are pre-filled for testing. Get your own API keys.
-
Track Parcels
- Enter carrier codes and tracking numbers in the Tracking sheet
- Click "Register Tracking" to submit items
- Wait 5-10 seconds
- Click "Fetch Results" to see delivery status
Key Features
- Batch Processing
- Track up to 100 items per batch. Larger sets are automatically split and processed.
- 39+ Carriers
- Supports carriers across 9 countries + international: UPS, FedEx, USPS, DHL, Canada Post, Yamato, and more.
- Color-Coded Status
- Delivery status is color-coded: green for delivered, blue for in transit, orange for pending, red for failed.
- Smart Input
- Type "ups" instead of "us.ups", or "FedEx" instead of "us.fedex". Carrier codes are auto-normalized.
- Track Only New Items
- "Untracked Only" mode skips rows that already have results, saving time and API usage.
- Auto-Update
- Check for macro updates and apply them automatically without re-downloading the file.
Google Sheets Version
Prefer Google Sheets? The same tracking features are available as a Google Apps Script.
Option 1: Use Our Template
Click the link below to copy our pre-built template to your Google Drive. Everything is set up and ready to use.
Requires a Google account (free). Works on any OS including Mac.
Option 2: Add to Your Own Spreadsheet
Already have a spreadsheet you use? Add the tracking macro to it:
- Open your Google Sheet
- Go to Extensions > Apps Script
- Download Code.gs and paste the contents
- Save and reload the spreadsheet
- A "WhereParcel" menu will appear — click Setup All
Supported Carriers
39+ carriers across 9 countries + international. Here are some of the most popular:
| United States | UPS · USPS · FedEx · OnTrac |
|---|---|
| Europe | FedEx UK · Hermes · Deutsche Post · GLS · CTT Express · Poste Italiane |
| Japan | Yamato · Japan Post |
| South Korea | CJ Logistics · Lotte · Hanjin · Korea Post · Logen |
| International | DHL Express · TNT · Cainiao · YunExpress · Yanwen · Chronopost |
Full carrier list is available in the "Carrier Codes" sheet inside the macro file. View all carriers
Important Notes
- Windows + Microsoft Excel required (VBA macro support)
- Do not add or delete rows between registering and fetching results
- Usage charges may apply — avoid unnecessary repeated registrations
- The pre-filled demo keys are for testing only and have limited usage
Need API Keys?
Pick a plan to get your own API keys with higher usage limits.