Marine & Ports Dashboard in Google Sheets

The Marine & Ports Dashboard in Google Sheets covers 6 linked tabs, 16 headline KPI cards, 18 pivot-driven charts and 15 slicers across four analysis pages – Overview, Terminals, Cargo and Carriers – plus a Call ID search tab and a built-in Instructions page. Every pivot, slicer and formula is already stretched to 1,000 data rows, so pasting new vessel calls updates the whole file with no setup. The download ships with 500 demo vessel calls; replace them and the dashboard redraws itself.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Marine & Ports Dashboard in Google Sheets

⚓ Four analysis pages, one data sheet. Overview reports network-wide performance, Terminals reports berth and terminal operations, Cargo reports tonnage and TEU by country, and Carriers reports shipping line and service tier performance. All four read the same vessel call log, so a number never disagrees with itself between pages.

📊 Native pivot tables behind every chart. Each chart is fed by a real pivot table parked to the right of its page, past a wide spacer column. Scroll right and you can inspect the exact numbers behind any visual – nothing is hidden inside a formula chain.

🎚️ 15 slicers, grouped in a Filters strip. Overview filters by Month, Port, Cargo Type and Status. Terminals filters by Terminal, Vessel Type, Berth Class and Month. Cargo filters by Country, Cargo Type and Service Tier. Carriers filters by Shipping Line, Service Tier, Status and Month. One click re-filters every chart, pivot and Top 5 panel on that page.

🕐 Turnaround and dwell analysis built in. The dashboard tracks average dwell hours, a Vessel Turnaround Hours distribution, and a Dwell Hours vs Call Revenue scatter that shows whether your slowest calls are also your most valuable ones.

🎯 Berth utilisation gauges against a 75% target. Three gauges – Deep-Water, Feeder and Multi-Purpose – read straight off the data sheet so you can see at a glance which berth class is running hot and which is idle.

🔎 A Search tab that returns a full record. Pick any Call ID and the page returns every field held for that call: date, port, country, terminal, cargo type, vessel type, shipping line, berth class, revenue, TEU handled, cargo tons, dwell hours, berth utilisation %, status, service tier, month and quarter.

📦 What’s Inside the Marine & Ports Dashboard in Google Sheets

Page 1: Overview – Port Network Performance

The landing page reports four headline KPI cards – Port Revenue, Vessel Calls, TEU Handled and Avg Dwell (Hrs) – alongside a Port Performance Snapshot panel showing on-time calls, average berth utilisation and total cargo tons. Charts on this page are Berth Utilisation vs 75% Target, Cargo Tons by Cargo Type, Vessel Turnaround Hours, Monthly Cargo Tons Handled and Revenue by Port, with a Top 5 Shipping Lines by Revenue table and a Vessel Call Status Mix bar set in the sidebar.

Page 2: Terminals – Terminal & Berth Operations

This page reports Completed Calls, Cargo Tons, Container Terminal Revenue and Avg Berth Util %, with a Terminal Snapshot for average dwell hours, revenue per ton and TEU per call. Charts are Revenue by Terminal, Vessel Calls by Vessel Type, Cargo Tons by Berth Class, Revenue by Terminal & Cargo Type, Monthly TEU Handled, and Dwell Hours vs Call Revenue, plus a Top 5 Terminals by Revenue table and a Terminal Revenue Share bar set.

Page 3: Cargo – Global Cargo Flow

The Cargo page reports Cargo Tons, Container Tons, Countries Served and Avg Tons / Call, with a Cargo Snapshot for reefer share and ports served. Charts are Cargo Tons by Country, Revenue by Cargo Type and TEU Handled by Service Tier, supported by a Top 5 Countries by Cargo Tons table and a Cargo Mix by Tonnage bar set that splits containers, dry bulk, liquid bulk and Ro-Ro vehicles.

Page 4: Carriers – Shipping Line & Service Tier Performance

This page reports Total Revenue, Shipping Lines, Priority Calls and Delay Rate, with a Carrier Snapshot for revenue per call and TEU per call. Charts are Line Revenue vs Vessel Calls (a combo chart pairing revenue bars with a call-count line), TEU Handled by Shipping Line, Vessel Calls by Status and Monthly Port Revenue, plus a Top 5 Service Tiers by Revenue table and a Service Tier Revenue Share bar set.

Page 5: Search – Vessel Call Lookup

Type or pick a Call ID and the Vessel Call Details panel returns every field recorded for that call in one clean list – useful when a colleague asks about one specific arrival and you do not want to scroll the raw data sheet.

Page 6: Instructions – How This Dashboard Works

A 10-step user guide explaining the pivot and slicer architecture, how to clear a slicer, why the KPI cards stay unfiltered by design, how the 1,000-row auto-expand works, and where to edit the colour palette. Behind these six tabs sits the Data sheet holding the vessel call log itself.

📊 Marine & Ports Dashboard in Google Sheets vs. Microsoft Excel Dashboard vs. Terminal Operating SaaS (Navis / Octopi) – Where This Fits

For port, terminal and shipping teams that want a shared operations picture without a terminal-system implementation project, the Marine & Ports Dashboard in Google Sheets sits in the sweet spot.

👥 Who This Template Is For – and Who It’s Not For

✅ This template is built for:

• Port and terminal operations managers who report monthly throughput, revenue and turnaround to a board or authority
• Shipping agency and liner analysts comparing revenue, TEU and delay rates across carriers and service tiers
• Freight forwarders and 3PL teams who need cargo tonnage by country and cargo type without buying an analytics seat
• Consultants and students building a port performance model from a spreadsheet of call records
• Small terminals whose data already lives in a spreadsheet and who want charts without leaving Google Sheets

❌ This template is NOT for:

• Anyone needing a terminal operating system – it does not plan berths, allocate yard slots, or issue gate moves
• Live AIS or vessel-tracking feeds – this is a reporting layer over data you enter or export, not a real-time positioning tool
• Safety, customs, certification or regulatory submissions – it makes no compliance or conformance claims of any kind
• Datasets beyond roughly 1,000 vessel call rows without extending the pivot and formula ranges yourself
• Teams that require SSO, audit logging or role-based permissions inside the file

⚙️ How to Use the Marine & Ports Dashboard in Google Sheets

1. Download the PDF from your order, open it, and click the “Make a copy” link to create your own editable copy in Google Drive.
2. Open the Instructions tab first – the 10-step guide explains the pivot and slicer architecture in about two minutes.
3. Go to the Data sheet and replace the 500 demo vessel calls with your own, keeping the existing column headers exactly as they are.
4. Keep real country names in the Country column so the Cargo page ranking and the Top 5 panel stay meaningful.
5. Return to Overview – every KPI card, pivot table and chart has already recalculated on your data.
6. Click any slicer in the Filters strip to narrow a page by month, port, terminal, cargo type, berth class, carrier, service tier or status.
7. Open a slicer and choose Select all to clear it. Slicers are per-page, so other tabs keep their own filters.
8. Use the Search tab to pull the full record for a single Call ID when someone asks about one specific arrival.
9. Paste additional rows anywhere up to row 1001 – pivots, slicers and formulas already cover that range.
10. Edit the colour palette at the top of the script if you want the dashboard to match your own brand.

💼 Real-World Use Cases

Ana is operations manager at a mid-size container terminal. She exports last month’s vessel calls from the terminal log into the Data sheet, then opens the Terminals page to compare revenue per ton and average berth utilisation across her six berths. The Dwell Hours vs Call Revenue scatter is what she brings to the monthly review, because it shows immediately which long-dwell calls actually earned their berth time.

Diego runs commercial reporting for a regional shipping agency. He uses the Carriers page to rank ten shipping lines by revenue and TEU, and filters by service tier to see how much of the book is long-term contract versus spot call. Before this he rebuilt the same pivot by hand every month; now he pastes the new rows and screenshots the page.

Priya is a supply chain consultant advising a port authority. She uses the Cargo page to show cargo tonnage by country and the cargo mix split between containers, dry bulk, liquid bulk and Ro-Ro, sharing one Drive link with the client team rather than emailing files back and forth.

❓ Frequently Asked Questions

What KPIs does the Marine & Ports Dashboard in Google Sheets track?

The Marine & Ports Dashboard in Google Sheets tracks 16 headline KPIs including port revenue, vessel calls, TEU handled, average dwell hours, completed calls, cargo tons, average berth utilisation %, countries served, average tons per call, priority calls and delay rate, plus 12 sidebar snapshot metrics.

How long does setup take?

Under 10 minutes. Click the copy link in the PDF, open the Data sheet, and paste your vessel call records over the demo rows using the same column headers. Every pivot, slicer and chart in the Marine & Ports Dashboard in Google Sheets recalculates automatically.

Is the sample data in the dashboard real port statistics?

No. The 500 vessel calls shipped with the Marine & Ports Dashboard in Google Sheets are demo data generated to show the layout working. Port names, carriers, tonnages and revenue figures are illustrative only and must be replaced with your own records.

Does this dashboard help with maritime safety or customs compliance?

No. The Marine & Ports Dashboard in Google Sheets is a reporting template for data you enter yourself. It makes no claims about maritime safety, customs or regulatory compliance, vessel certification, or conformance with any maritime standard, and should not be used for regulatory submissions.

How many vessel call records can it handle?

Pivots, slicers and formulas in the Marine & Ports Dashboard in Google Sheets already cover 1,000 data rows out of the box. Paste new rows anywhere up to row 1001 and the dashboard updates on its own; beyond that you extend the ranges yourself.

How does this compare to a terminal operating system like Navis or Octopi?

A terminal operating system runs live operations – berth planning, yard moves, gate control. The Marine & Ports Dashboard in Google Sheets is a $9.99 one-time reporting layer over call records you already have. It reports performance; it does not run the terminal.

Why do the KPI cards not change when I click a slicer?

By design. In the Marine & Ports Dashboard in Google Sheets, KPI cards, the berth utilisation gauges and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet, so they always show unfiltered totals. The charts, pivots and Top 5 panels are the slicer-aware parts.

👤 About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

If you move cargo as well as berth it, the Shipping Dashboard in Google Sheets reports the freight leg once the box leaves the gate, and the Transportation Services Dashboard in Google Sheets covers inland fleet movements. For rail-served ports, the Railways Dashboard in Google Sheets is the closest neighbour, and bulk terminals often pair this with the Oil & Gas Dashboard in Google Sheets.

Also available as: Marine & Ports Dashboard in Excel and Marine & Ports Dashboard in Power BI – same subject, different tool. Browse the full Google Sheets Dashboards catalogue for more, or see the Port Operations Dashboard in Excel for a berth-focused alternative.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: August 2026