This template uses standard ADIF-friendly column headers, making it easy to import into other software later if you decide to upgrade. It is compatible with Microsoft Excel, Google Sheets, and LibreOffice Calc.
. This keeps headers visible as you scroll down through hundreds of contacts. Drop-Down Menus Data Validation
A good log sheet balances detail with efficiency. You don't want to type so much that you miss the conversation, but you need enough data for later reference.
Open Excel or Google Sheets. Click on cell A1.
Record both the report you gave and the one you received (e.g., 59 or 599).
| Column | Field Name | Description | Example | | :--- | :--- | :--- | :--- | | A | | 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 |

