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.
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:
| Column | Write it as |
|---|---|
| Date | One date per row, one style all the way down (2026-09-13) |
| Dive site | The place, as you would say it |
| Time of day | 09:30 |
| Country | The country's name |
| Max depth | A number, in metres or in feet, never both |
| Dive time | Minutes, as a number |
| Buddy | A name |
| Dive number | 1, 2, 3 … |
| Water temperature | A number |
| Visibility | A number in metres |
| Gas mix | Air, or the oxygen percentage |
| Cylinder size | Litres |
| Start pressure, end pressure | bar |
| Notes | Anything else |
| Sightings | What 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.

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.