Built around the jobs fly anglers actually do
Remember the fly and the size that worked
Pick the fly from your own Fly Box when you log a fish, and the pattern, hook size and fly type fill in. The dashboard ranks your top flies and counts fish by hook size and fly type.
Fish, fly from your boxTop flies and sizesLearn the flow your river fishes best at
Log the CFS and water temperature each day. Waters works out each river's good-day flow range and temperature range from the days you caught fish, and saves its USGS gauge number.
CFS, water tempGood-day rangesBuild your own hatch calendar
Note the insect, stage, size, how heavy the hatch was and whether fish were rising. The Hatch Calendar turns it into a month-by-month heat map for one river or all of them, with each bug's peak month and typical hook size.
What's hatchingHatch heat mapSee which rig and tippet catch more
Record the rig, leader and tippet each day. Compare fish per hour for dry fly, dry-dropper, Euro nymph, indicator and streamer, and fish caught on 4X against 5X and 6X.
Rig, leader, tippetFish per hourKnow what to tie or buy before the next trip
Set how many of each pattern and size you like to carry. Anything running low shows Tie or Buy with a count and the restock cost. Fly Recipes and Materials keep your tying list and the materials to reorder.
On hand, targetTie / Buy listMatch your rods and look after the fish
Rod Setups flags a line that's a weight off and a reel outside its rating. Water at 65°F turns amber and 68°F turns red, both editable, and air time over your limit is highlighted on each release.
Rods, temps, releasesWarnings15 tabs in one file
- Start Here
- Dashboard
- Day Log
- Catch Log
- Hatch Log
- Hatch Calendar
- Waters
- Fly Box
- Rod Setups
- Fly Recipes
- Materials
- Trips
- Personal Bests
- Charts
- Settings
- Start Here
- Eight setup steps and the color key.
- Dashboard
- Season numbers, alerts, top flies, hook sizes, catch by water temperature, rigs, tippets, this month's hatches and best waters.
- Day Log
- One row per day: water, hours, weather, water temp, CFS, clarity, rod setup, rig, leader and tippet.
- Catch Log
- One row per fish: species, length, fly, presentation and release details, with personal best and trophy flags.
- Hatch Log
- Insect, stage, size, color, time, intensity, rising fish and the fly that matched.
- Hatch Calendar
- A month-by-month heat map of hatches for one river or all, with peak month and size.
- Waters
- Each river or lake with its gauge number, fish per hour and good-day flow and temperature ranges.
- Fly Box
- Count against target for each pattern and size, a Tie / Buy next step, restock cost and fish per fly.
- Rod Setups
- Rod, reel and line matching, days on the current line, fish and cost per day.
- Fly Recipes
- Recipe cards with every material, cost and minutes per fly and how many to tie.
- Materials
- Tying materials on hand against a reorder point, with a shopping list.
- Trips
- Guided floats and road trips with guide fee, suggested tip, lodging, travel and cost per fish.
- Personal Bests
- Longest and heaviest fish of each species, with the fly, size, water and date.
- Charts
- Tippet size chart, a tippet picker, AFFTA line weights, line weight by species and a water temperature guide.
- Settings
- Season year, good-day bar, trophy length, temperature and air-time limits, tip % and every dropdown list.
Try the free Tippet Size Chart
Every tippet X size with its diameter, breaking strength and the fly sizes it balances.
Also free: Fly Line Weight Chart
Pair it with
“Well thought out worksheets nicely presented”
“Excellent! Very easy to use.”
Before you buy
Do I have to log every fish?
No. Log the fish you want to learn from and add the rest as a number in Extra Fish on the Day Log. Day totals and fish per hour still count them.
Is it only for trout?
It is built around trout water, with hatches, flows and the 68°F limit, but the species, rig and fly lists are all editable. It works for bass, carp, steelhead and saltwater too.
How is it different from the Fishing Log Spreadsheet?
The Fishing Log covers any kind of fishing with lures, spots and trips. The Fly Fishing Journal is built for fly anglers: the fly and hook size on every fish, hatches, CFS, rigs and tippet, a fly box with a tying list, and rod and line matching.
Will it work on my phone?
Yes, in the Google Sheets or Excel app. Most columns are dropdowns, so logging at the truck is quick.
Is my fishing data private?
Yes. It is your own file, so your spots stay yours. Nothing is shared and there is no feed.
Are the tippet and line weight charts on the site too?
Yes. The free Tippet Size Chart and Fly Line Weight Chart on this site use the same reference data as the Charts tab, so you can check them before you buy.
What do I get?
An Excel file (.xlsx), a filled-in sample to look at, and a quick-start PDF guide with a link that makes your own copy in Google Sheets.
How does delivery work?
You get your download links right after checkout, and Stripe emails your receipt. There is nothing to ship and nothing to wait for.
How do I set it up in Google Sheets?
Open the quick-start PDF and click the Google Sheets link. Google makes a copy in your own Drive that only you can edit. You need a free Google account.
Will it work on a Mac?
Yes. It works in Excel on Mac and Windows, and in Google Sheets in any browser.
I'm not a spreadsheet person. Is that a problem?
No. You only type in the yellow cells. Everything in gray works itself out, and the Start Here tab shows you where to begin.
Can I get a refund?
Templates are digital downloads, so sales are final. If a file won't open, is broken or doesn't match its description, email hello@cleanpixelstudios.com within 30 days and we'll fix it, or refund you if we can't.
What if I get stuck?
Email hello@cleanpixelstudios.com and we'll help you get it working.
More in Home, hobbies & travel
See all Home, hobbies & travel templates
Made by Clean Pixel StudiosWe start every template by reading what people in that line of work say they struggle with, then build the spreadsheet around those problems. This one was made for fly anglers and nobody else.
How we build templatesFly Fishing Journal$18.99 · Excel + Google Sheets