Ham — Radio Log Sheet Excel Template

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.

A "Data Validation" list for Mode (SSM, CW, FT8) so he could click instead of type.

#HamRadio #AmateurRadio #Hams #TwoWayRadio #RadioGeek #ShackUpdate #73 ham radio log sheet excel template

The Maidenhead Grid Locator, which is essential for VHF/UHF and satellite work. Tips for Managing Your Excel Log

This is an array formula (Press Ctrl+Shift+Enter). =SUM(1/COUNTIF(J:J, J:J)) (Assumes DXCC is in column J) If you are sharing the template with a

A good log sheet is more than just "Call Sign" and "Time." To be truly useful for contest submissions (like the ARRL Sweepstakes) or award tracking (DXCC, WAS), your template must include specific ADIF (Amateur Data Interchange Format) compatible fields.

Select the columns and format them as Text or custom time code ( hh:mm ) to prevent Excel from automatically adding local dates to your UTC timestamps. Allow only data entry in unlocked cells

Use =COUNTA(C:C)-1 to instantly display your lifetime total number of contacts based on your Callsign column.

Want this formatted into an actual Excel file (.xlsx) or a downloadable CSV?

Set up drop-down menus for "Mode" and "Band" columns to keep your data consistent and prevent typos.