Ham Radio: Log Sheet Excel Template Repack

For amateur radio operators, keeping a detailed and accurate log of contacts (QSOs) is not just a regulatory requirement in some regions, but also a vital practice for tracking awards, analyzing propagation, and managing QSL cards. While digital logging software (like Logger32 or N1MM) is popular, many operators prefer the flexibility, simplicity, and portability of an .

If you are sharing the template with a club, lock the dupe-check and serial columns. Select those columns > Right-click > Format Cells > Protection > Locked. Then protect the sheet (Review > Protect Sheet). Allow only data entry in unlocked cells. ham radio log sheet excel template

Use the COUNTA function to count how many contacts you have made.=COUNTA(C2:C1000) For amateur radio operators, keeping a detailed and

Mark whether a physical QSL card or digital confirmation (LoTW, eQSL) has been sent and received. Select those columns > Right-click > Format Cells

In an empty cell at the top of your sheet (or on a separate dashboard tab), use the formula =COUNTA(C:C)-1 (assuming Column C is your Call Sign column). This will display a live count of your total logged contacts. Tips for Maintaining an Accurate Excel Log