If you have a column for "Country" (Column I):
=SUMPRODUCT(1/COUNTIF(I2:I100,I2:I100))
(Note: This counts unique values in the list. Adjust the range I2:I100 to match your log size).
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.
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. ham radio log sheet excel template
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.
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.
You can make Excel automatically color-code different bands so you can visualize your activity. If you have a column for "Country" (Column
Once you have the basics, you can make your template intelligent. Here are three game-changing additions using simple Excel formulas.
See how much CW vs. SSB you have worked:
=COUNTIF(E:E, "CW")
To avoid typos, create drop-downs for Band, Mode, and State.
Repeat for Mode: SSB, CW, AM, FM, FT8, FT4, RTTY, PSK31, SSTV. (Note: This counts unique values in the list
Turn your log into a powerful analysis tool using formulas. Assuming your Frequency is in Column D and Mode is in Column E:
Before diving into the template design, let’s address the elephant in the room. In the United States, FCC Part 97.103 states that the station licensee must maintain a record of station operations. While the FCC no longer mandates a specific format, a proper log is your proof of compliance. Internationally, many countries require logs for the past 12-24 months.
A well-structured Excel template satisfies these requirements by capturing: