Ham Radio Log Sheet Excel Template Jun 2026

Recorded in YYYY-MM-DD format to prevent international confusion.

Select the column under "Date" and format the cells as YYYY-MM-DD to avoid regional date format confusion.

If you aren't ready to commit to full-featured logging software but want the benefits of digital organization, an is the perfect middle ground. ham radio log sheet excel template

The exact frequency (e.g., 14.250 or 146.520 ).

=IF(D2>=28,"10m",IF(D2>=21,"15m",IF(D2>=14,"20m",IF(D2>=7,"40m",IF(D2>=3.5,"80m","Other"))))) The exact frequency (e

Create a second tab in your spreadsheet called "Dashboard." Use the =COUNTA() and =COUNTIF() formulas to display live statistics, such as your total number of QSOs, how many countries you have worked, or your most active band. How to Export Excel Logs to ADIF Format

Select row 2. Go to View > Freeze Panes > Freeze Top Row. Now, as you scroll down, you will always see the column labels. Go to View > Freeze Panes > Freeze Top Row

For the amateur radio operator, the station log (often called a logbook ) is the diary of your on-air activity. It is a fundamental tool for confirming contacts (QSOs) via QSL cards, applying for operating awards like DXCC or Worked All States, and troubleshooting your station's equipment and antenna performance.