A minimalist log might hurt you later when you want to apply for an award. Here are the 18 critical columns you should include in your template. You can hide unused columns, but it is better to have them ready.
| Column | Field Name | Description | Example | | :--- | :--- | :--- | :--- | | A | Date | QSO date in YYYY-MM-DD format (UTC) | 2025-04-07 | | B | Time On | Start time in UTC (00:00 to 23:59) | 14:35 | | C | Call | Station worked (uppercase) | W1AW | | D | Band | Wavelength in meters | 20m | | E | Freq (MHz) | Actual frequency | 14.250 | | F | Mode | Operating mode | SSB, CW, FT4 | | G | RST Sent | Readability, Strength, Tone (CW) | 59 | | H | RST Rcvd | Signal report received | 59 | | I | Name | Operator’s first name | Dave | | J | QTH | City/state or general location | Newington, CT | | K | DXCC | Country entity | United States | | L | State/Province | For WAS or RAC awards | CT | | M | CQ Zone | CQ World Wide Zone | 5 | | N | ITU Zone | ITU Region zone | 8 | | O | Grid Square | 4 or 6-character Maidenhead grid | FN31pr | | P | POTA Ref | Parks on the Air reference | K-1234 | | Q | SOTA Ref | Summits on the Air reference | W1/PH-001 | | R | Notes | Any special info (rig, antenna, QSL sent) | QSL via bureau |
Once you have your template, follow these rules to avoid disaster.
| Feature | Formula / Method |
|--------|------------------|
| UTC Time Insert | Ctrl + Shift + ; (manual) or =IF(A2="", "", TEXT(NOW(), "HH:MM")) |
| Auto Serial Number | =ROW()-1 |
| Band from Frequency | =VLOOKUP(Frequency_MHz, BandTable, 2, TRUE) |
| Unique DXCC Count | =SUM(1/COUNTIF(DXCC_Range, DXCC_Range)) (array formula) |
| QSO per Band | =COUNTIF(Band_Range, "20m") |
| Conditional Format (Duplicates) | =COUNTIFS(Callsign_Range, $C2, Time_Range, ">"&$D2-1/1440) | ham radio log sheet excel template
Instead of typing "20m" every time, let Excel calculate it from the frequency. Paste this into a new column labeled "Band":
=IF(D2>=28,"10m",IF(D2>=21,"15m",IF(D2>=14,"20m",IF(D2>=7,"40m",IF(D2>=3.5,"80m","Other")))))
If you don’t want to build your own, several excellent templates are available for download. Always scan downloads for viruses.
1. The ARRL Basic Log Sheet
The American Radio Relay League offers a simple .xls file on its website. It focuses on the bare essentials: Date, Time, Call, Band, Mode, RST. Best for beginners. A minimalist log might hurt you later when
2. N3FJP’s Excel Companion While N3FJP makes paid software, they provide a free generic Excel log sheet that mimics their popular contest loggers. Includes columns for multipliers and zones.
3. The DXCC Tracker Pro A fan-made template available on HamSphere or QRZ forums. This is a massive spreadsheet with multiple tabs: one for raw logs, one for a world map visualization, and one for award progress.
4. Field Day Score Calculator Several clubs publish a hybrid log/scoresheet that automatically calculates your Field Day points based on power source (Battery vs. Commercial) and mode. Instead of typing "20m" every time, let Excel
5. The Google Sheets Cloud Log Not strictly Excel, but a live template you copy to your Google Drive. The advantage is real-time collaboration—three operators in your club can log to the same sheet from different phones during a contest.
Turn your log into a powerful analysis tool using formulas. Assuming your Frequency is in Column D and Mode is in Column E: