Shipment Tracking Spreadsheet: ETA, ETD and Import Status in Excel

A shipment tracking spreadsheet gives logistics teams one place to see what is moving, what is late and what needs attention.

Core shipment tracking fields

  • Customer or internal reference
  • BL, AWB or container number
  • Origin and destination
  • Transport mode
  • ETD and ETA
  • Status and priority
  • Owner or responsible person
  • Last update and notes

Use ETA and ETD as operational dates

ETD helps plan departure-related tasks, while ETA helps prioritize arrival, customs and delivery actions. When these dates change, a tracker should make the change visible rather than leaving it buried in email.

Add a dashboard

A useful dashboard can summarize active shipments, upcoming arrivals, overdue operations and shipments with issues. This is often faster than filtering a long table repeatedly.

The ImportVista Shipment & Import Tracker includes ETA/ETD control, statuses, priorities, alerts and a dashboard for up to 200 operations.