Track Parcels in Bulk from Excel — Free VBA Macro
A free VBA macro that pulls delivery status for hundreds of parcels straight into Excel. 39+ carriers — UPS, FedEx, USPS, DHL and more.
WhereParcel Team
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
- 39+ carriers — UPS, FedEx, USPS, DHL, Canada Post, Yamato, CTT Express, and many more across 9 countries + international
- Smart carrier input — Type “ups” instead of “us.ups”, or “FedEx” instead of “us.fedex”
- 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 all 39+ supported carriers
- Instructions sheet — Usage guide
Step 4: Enter API Keys
The macro comes pre-filled with demo keys for testing. For production use, subscribe to get your own API keys — cancel anytime.
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 39+ carriers across 9 countries + international, organized by region:
| Region | Examples |
|---|---|
| US | UPS, USPS, FedEx, OnTrac |
| UK | FedEx UK |
| Germany | Hermes, GLS, Deutsche Post, FedEx Germany |
| Spain | CTT Express, FedEx Spain |
| Japan | Yamato, Japan Post |
| Korea | CJ Logistics, Lotte, Hanjin, Korea Post, Logen, KD Express |
| International | DHL Express, TNT, Cainiao, YunExpress, Yanwen, Chronopost |
And many more across Canada, Italy, and Turkey.
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 |
cj | kr.cj |
If you need a carrier that has no shortcut (e.g., de.hermes for Hermes Germany), 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 [email protected].
Can't find your carrier? We add new carriers on request — just let us know.
Request a carrier →Got a question? Just ask. Drop by our Discord — the developer behind WhereParcel reads every message and replies personally. No bots, no tickets, just a real conversation.
Join Discord → Join Slack →