Ham Radio Log Sheet Excel Template [repack]

Recording time in Universal Coordinated Time (UTC) is highly recommended to avoid confusion across time zones.

Indicate whether the contact was via SSB, CW, FT8, or another digital mode. Signal Reports and Location ham radio log sheet excel template

(Note: This counts unique values in the list. Adjust the range I2:I100 to match your log size). Recording time in Universal Coordinated Time (UTC) is

Instead of typing "20m" every time, let Excel calculate it from the frequency. Paste this into a new column labeled "Band": ham radio log sheet excel template

Google Sheets has a built-in template gallery. Search for “Call Log” or “Contact Log” and modify the columns for amateur radio. You get cloud backup and real-time collaboration (great for multi-op Field Day).