Excel

Tracking shipping containers manually or through web dashboards can be time-consuming and inflexible. This integration allows you to automate container tracking queries and export the results to a CSV file, which is compatible with:

• Excel
• Google Sheets
• Business Intelligence tools (Power BI, Tableau, etc.)
• Any data processing pipeline

This makes it easy to analyze, share, and visualize shipping data as part of your logistics workflow.

📥 Download

Download the integration package:

👍

Download ZIP

The archive contains:

• tracking_notebook.ipynb — the Jupyter Notebook script
• shipment.csv — a sample input file
• data.csv — a sample output file
• README.md — this documentation

📝

You can run the notebook in Visual Studio Code or launch it online using Jupyter Lab.

🛠️ What It Does

• Reads shipment.csv to find the shipments and sealines to be tracked

• Queries the container tracking API

• Generates data.csv with all container events:

  • Location
  • Vessel
  • Event description
  • Event code
  • Status

One row per container — if your shipment has multiple containers, each will have its own line.

🔐 Before You Start

Make sure to enter your API key at the top of the notebook:

API_KEY = "your-api-key-here"

Without this, the script won’t be able to access the tracking API.

🧩 Easy to Customize

The notebook is written in Python and fully annotated for clarity. It’s easy to modify for advanced use cases.