If you manage shipments using spreadsheets, you’ve probably wished you could check delivery status without switching between dozens of carrier websites. Now you can — directly from Excel.
What Is the WhereParcel Excel Tracker?
It’s a free VBA macro that lets you track parcel delivery status in bulk from Microsoft Excel. Enter your carrier codes and tracking numbers, click a button, and get results populated right in your spreadsheet.
No coding required. No complex API integration. Just Excel.
Key Features
- Batch tracking — Register up to 100 items per batch, automatically split for larger sets
- 200+ carriers — UPS, FedEx, USPS, DHL, CJ Logistics, Yamato, Royal Mail, Correos, and many more across 19 countries
- Smart carrier input — Type “ups” instead of “us.ups”, or “FedEx” instead of “us.fedex”. Korean users can even type carrier names in Korean
- Color-coded results — Green for delivered, blue for in transit, red for failed
- Selective tracking — “Untracked Only” mode skips rows that already have results
- Auto-update — Check for macro updates and apply them without re-downloading
How It Works
The macro uses WhereParcel’s webhook API under the hood:
- Register — Your tracking items are sent to the WhereParcel API in batches
- Process — The server queries carrier websites in the background (5-10 seconds)
- Fetch — Results are pulled back into your spreadsheet with a single click
This two-step approach is lightweight and doesn’t tie up your Excel while waiting for carrier responses.
Getting Started
Step 1: Download
Download the macro-enabled workbook (.xlsm) from our Spreadsheet Tracker page. It includes the VBA macro, settings, and a full carrier code reference.
Step 2: Enable Macros
Open the file and click “Enable Content” when prompted by Excel’s security bar.
Step 3: Run Setup
Press Alt+F8, select SetupAll, and click Run. This creates:
- Settings sheet — API keys, column mappings, execution options
- Tracking sheet — Where you enter data and see results
- Carrier Codes sheet — Full list of 200+ supported carriers
- Instructions sheet — Usage guide
Step 4: Enter API Keys
The macro comes pre-filled with demo keys for testing. For production use, sign up for free to get your own API keys.
Step 5: Track!
- Enter carrier codes (column B) and tracking numbers (column C) in the Tracking sheet
- Click “Register Tracking”
- Wait 5-10 seconds
- Click “Fetch Results”
Your delivery status, location, receiver name, and timestamps will be populated automatically.
Supported Carriers
The macro supports 200+ carriers across 19 countries, organized by region:
| Region | Examples |
|---|---|
| US | UPS, USPS, FedEx, DHL, Amazon Logistics, OnTrac, LaserShip |
| Korea | CJ Logistics, Lotte, Hanjin, Korea Post, Logen, Kyungdong |
| Japan | Yamato, Sagawa, Japan Post, Seino, Nippon Express |
| UK | Royal Mail, DPD, Evri, Parcelforce, Yodel |
| Germany | DHL, Hermes, DPD, GLS, Deutsche Post |
| Spain | Correos, SEUR, MRW, Nacex, CTT Express |
| International | DHL Express, EMS, Aramex, TNT, Cainiao, SF Express |
And many more across Australia, Canada, China, Hong Kong, India, Ireland, Italy, New Zealand, Philippines, Singapore, Turkey, and South Africa.
Carrier Code Shortcuts
You don’t need to memorize the full carrier codes. The macro automatically normalizes common inputs:
| You Type | Becomes |
|---|---|
ups | us.ups |
fedex | us.fedex |
usps | us.usps |
dhl | intl.dhl |
yamato | jp.yamato |
royal mail | gb.royalmail |
cj | kr.cj |
롯데택배 | kr.lotte |
If you need a specific regional variant (e.g., de.dhl for DHL Germany vs intl.dhl for DHL International), just enter the full code with the dot notation.
Tips for Best Results
- Wait before fetching — Give the server 5-10 seconds after registering to query carriers
- Use “Untracked Only” mode — Avoids re-querying items that already have results
- Check the Error column — If a tracking fails, the error message tells you why
- Set Tracking Number column to Text format — Prevents Excel from converting long numbers to scientific notation (the macro handles this automatically for new sheets)
System Requirements
- Windows with Microsoft Excel (VBA macro support required)
- Internet connection for API calls
- Excel for Mac is not supported (limited VBA support)
On a Mac? Use Google Sheets Instead
The same tracking features are available as a Google Apps Script — works on Mac, Windows, Chromebook, and even mobile. No downloads needed.
Read the Google Sheets guide or go directly to the Spreadsheet Tracker page.
Download Now
Ready to save hours of manual tracking? Download the free Excel Tracker and start tracking parcels in bulk today.
Have questions or feature requests? Join our community or email us at help@whereparcel.com.