← Back to Home

Free container tracking spreadsheet template

One row per container, the 10 milestones of an ocean shipment, ETAs, and a dashboard that shows what arrives next and which containers need a follow-up. Built for Google Sheets, free to copy.

Make a copy (free)

Opens Google Sheets and saves your own copy to your Google Drive. You need a Google account.

The Dashboard tab of the container tracking template: open shipments, containers on the water, arrivals in the next 14 days, a bar per stage and a chart of arrivals per week

What's inside

Milestones

Your data: carrier, container number, type, ETA, current status, and the place and date of each milestone. A carrier dropdown, date checks and a green trail across the milestones a container has reached.

Dashboard

Open shipments, on the water, arriving in 14 days, at the destination port, arrivals per week, a breakdown by carrier and port, and the lists Arriving next and Needs attention. It recalculates as you edit.

Start here

A one-page guide: how to fill the sheet, what each milestone means, and which containers the Dashboard flags.

How to use it

  1. Make a copy. The copy is yours: nobody else sees your containers.
  2. Delete the 4 sample rows in the Milestones sheet (yellow, containers SAMPLE-01 to SAMPLE-04). They are there so the Dashboard has something to show.
  3. Add your containers, one row each: carrier, container number, ETA, and the date and place of each milestone you know. Leave the rest empty.
  4. Open the Dashboard. See what arrives in the coming weeks and what needs a call today.
The Milestones tab of the template with four sample containers: carrier, container number, type, ETA, current status, location and status date

What "Needs attention" flags

The 10 milestones

Empty Container DispatchedThe empty container leaves the depot for loading at the shipper.
Received Full for ExportThe loaded container is back at the terminal, ready for export.
Loaded on VesselLoaded onto the first ocean vessel.
Vessel DepartureThe vessel leaves the port of loading.
Vessel ArrivalThe vessel arrives at the port of discharge.
Discharged from VesselThe container is unloaded at the port of discharge.
Available for PickupCustoms and terminal release: it can be collected.
Import to ConsigneeThe container leaves the port towards the consignee.
Delivered to ConsigneeDelivered to the consignee.
Empty Returned to DepotThe empty container is back at the carrier's depot. The trip is complete.

Fill it with one click

Copying dates from carrier websites takes time. Container Tracker is a Google Sheets add-on that can fill this Milestones sheet for you:

  • Add a container in the add-on by its number. The carrier is detected from the number.
  • It reads milestones, ETA and status from the carrier (MSC, Maersk, Hapag-Lloyd, CMA CGM, ONE, Yang Ming, Evergreen) and checks again every few hours.
  • Your sheet changes only when you click Update Milestones sheet in the add-on panel. One click refreshes all rows, and ETA changes are highlighted.
  • Rows you typed yourself are kept. When the add-on tracks the same carrier and container, it updates that row instead of adding a new one.
  • Free for your first 10 containers read from the carrier; more need a paid plan. Manual tracking for any carrier is always free.

Install Container Tracker

After installing, open it from the Container Tracker icon in the right-hand side panel of Google Sheets (not the Extensions menu). Getting started guide

Questions

Is it free?

Yes. The spreadsheet is free to copy, use and share. The optional add-on is free for your first 10 containers read from the carrier.

Does it update container status by itself?

No. The Dashboard recalculates from what is in the Milestones sheet, but the milestone dates come from you: you type them, or the add-on writes them when you click Update Milestones sheet.

Can I use it in Excel?

It is built for Google Sheets. You can download it as .xlsx (File → Download), and the Milestones data comes across, but the Dashboard formulas are written for Google Sheets and may not work in Excel.

Can I add my own columns?

Yes, after the Notes and Reference columns. Don't insert, move or rename columns A to AD of the Milestones sheet: the Dashboard and the add-on rely on them.

Make a copy (free)