whereparcel

Stuck on integration? Have a question? The developer is standing by.

Tutorial 5 min read

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:

  1. Register — Your tracking items are sent to the WhereParcel API in batches
  2. Process — The server queries carrier websites in the background (5-10 seconds)
  3. 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!

  1. Enter carrier codes (column B) and tracking numbers (column C) in the Tracking sheet
  2. Click “Register Tracking”
  3. Wait 5-10 seconds
  4. 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:

RegionExamples
USUPS, USPS, FedEx, OnTrac
UKFedEx UK
GermanyHermes, GLS, Deutsche Post, FedEx Germany
SpainCTT Express, FedEx Spain
JapanYamato, Japan Post
KoreaCJ Logistics, Lotte, Hanjin, Korea Post, Logen, KD Express
InternationalDHL 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 TypeBecomes
upsus.ups
fedexus.fedex
uspsus.usps
dhlintl.dhl
yamatojp.yamato
cjkr.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

  1. Wait before fetching — Give the server 5-10 seconds after registering to query carriers
  2. Use “Untracked Only” mode — Avoids re-querying items that already have results
  3. Check the Error column — If a tracking fails, the error message tells you why
  4. 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 →

Tags: #excel #macro #vba #bulk-tracking #free-tool #download