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.