Skip to content
LoggerfishGet the app

Loggerfish › Guides

Logbook

Dive log template for Excel: the columns to use, and what to do next

A spreadsheet is a fine first logbook, and a hard one to outgrow. This guide gives you the columns to use and the habits that let the sheet move into an app later without retyping.

1 min read

The columns

Make one row per dive and one column per fact. These are the columns Loggerfish recognises when you import a sheet, with the first two required:

ColumnWrite it as
DateOne date per row, one style all the way down (2026-09-13)
Dive siteThe place, as you would say it
Time of day09:30
CountryThe country's name
Max depthA number, in metres or in feet, never both
Dive timeMinutes, as a number
BuddyA name
Dive number1, 2, 3 …
Water temperatureA number
VisibilityA number in metres
Gas mixAir, or the oxygen percentage
Cylinder sizeLitres
Start pressure, end pressurebar
NotesAnything else
SightingsWhat you saw

Habits that save work later

  • Keep a single header row at the top, and no merged cells.
  • Do not put units into the cells ("18" rather than "18 m"); the heading can carry the unit.
  • Write dates one way only. If you write 03/04/2026, you will need to say whether that is day first or month first when you import.
  • Leave a cell empty when you do not know a value, instead of writing 0.

Moving the sheet into an app

Loggerfish reads .xlsx, .csv and .txt files. Open the import, choose the file, and match the columns: it guesses them from the headings, and you correct any it got wrong. You tell it whether depths are metres or feet and how dates are written, then read the preview, which counts new dives and dives already in your log. Nothing is saved until you press import, and importing needs no account.

And back to paper

Loggerfish prints a logbook too: under Export, choose the logbook PDF and pick the whole log or a range. Each dive has a place for a buddy or instructor to sign. The paper logbook or app guide explains using both.

Import your spreadsheet into Loggerfish

Free to start, no card. Your logbook, and every export of it, stays yours on every plan.

The Loggerfish logbook on an iPhone

Names such as PADI, SSI, MySSI, Subsurface, MacDive, Shearwater and Garmin belong to their owners and are used only to say which product we mean. Loggerfish is not affiliated with any of them. What a guide says about them comes from their own public pages, listed beside the statement with the day it was checked. If something is out of date, write to support@loggerfish.com and we will correct it.

Download the app on the App Store