Template · Free

A CSV template for a tank log

Eight columns, one row per test, the same header the app writes on export. Download the blank file or the example and open it in whatever spreadsheet you already use.

Blank or exampleExcel · Numbers · SheetsNo sign-up

The file, as text

date,ph,nitrate_ppm,nitrite_ppm,ammonia_ppm,water_changed,water_change_percent,notes
2026-11-01 09:15,7.2,15,0,0,yes,25,"Nitrate before the water change, 20 L out"
2026-11-04 19:40,7.1,20,0,0,no,0,"Added 6 neon tetras"
2026-11-08 10:02,7.3,15,0,0,yes,25,"Filter media rinsed in tank water"

Column names stay in English on purpose: they match the app export, so two files can be merged without a mapping table.

A spreadsheet is the smallest possible log system: one file, no account, opens anywhere, and you can sort it, chart it or hand it to a spreadsheet-minded friend. This page gives you the header row so you do not have to invent one.

The columns

ColumnFormatExample
dateYYYY-MM-DD HH:MM2026-11-01 09:15
phdecimal7.2
nitrate_ppmdecimal15
nitrite_ppmdecimal0
ammonia_ppmdecimal0
water_changedyes / noyes
water_change_percent0–10025
notesfree text, quoted if it contains a comma"20 L changed"

Two things that trip people up

  • If your spreadsheet uses a comma as the decimal separator, it may expect semicolons between columns instead. Import the file with “comma” as the separator rather than letting the app guess.
  • Keep the header exactly as it is: lowercase, underscored. The moment you rename a column, the file stops matching the app export and any script that reads it.
Same header as the app

The app exports CSV with these eight columns. This template exists so a spreadsheet started today can grow into the same shape as an export from your phone.

What it is not

There is no import into the app in the current release — the CSV is a backup and an escape hatch, not a sync format. The browser log exports the same header if you want a middle step, and the printable sheet is for paper.

Questions

Frequently asked

Is the file UTF-8?
Yes, with a byte-order mark, which is what makes Excel open accented notes correctly on Windows. If your tool complains about the BOM, strip it — the rest is plain CSV.
Can I add columns?
You can, but keep the eight original ones in the same order if you ever want to merge the file with an app export.
Why is water_changed “yes” instead of true?
It is what the app writes today. A spreadsheet reads it as text; if you want a real boolean, add a formula column rather than editing this one.
Does this work with Google Sheets?
Yes — File → Import → Upload, then choose “comma” as the separator if the preview looks wrong.
Download

Stop guessing what your tank did last week

Log a test in twenty seconds, get reminded before maintenance is overdue, and keep a history you can actually read back. Free for one tank — no account, no subscription.

Download on the App Store Free · No account · Works offline
QR code linking to FishTank Diary on the App Store
Point your camera at the code FishTank Diary is an iPhone and iPad app. Install it now — no account, no email, no setup.
Open the App Store link