Ham Radio Log Sheet Excel Template Exclusive Fixed May 2026
Upgrade Your Shack: The Ultimate Ham Radio Log Sheet Excel Template
Key fields to include
- Date — YYYY-MM-DD (use ISO format for sorting)
- UTC Time — 24-hour UTC for official records
- Local Time — optional, calculated from UTC
- Callsign — contacted station
- Band — e.g., 40m, 20m
- Mode — e.g., SSB, CW, FT8
- Frequency (kHz/MHz) — optional if band is used
- RST Sent — signal report you sent
- RST Rcvd — signal report you received
- Name — operator name (optional)
- QTH — location of other station (city/region)
- Country/ITU/Continent — for awards like DXCC or Worked All Continents
- State/Province — for awards like Worked All States
- Grid Square (Maidenhead) — for VHF/UHF and contesting
- Submission/Exchange — contest exchange (serial, section, etc.)
- Notes — comments (propagation, antenna, power)
- Log ID / QSO Number — unique sequential ID (auto)
- Confirmed (eQSL/LoTW/Direct) — checkbox or status
- Uploaded to LoTW/eQSL — date/status
Signal Reports: RST (Readability, Strength, Tone) sent and received. ham radio log sheet excel template exclusive
| Column Header | Why You Need It | Exclusive Feature | | :--- | :--- | :--- | | Date (Local) | Legal documentation of the QSO. | Auto-formatted to MM/DD/YYYY or DD/MM/YYYY. | | Time (UTC) | The universal standard. Logging local time is a cardinal sin. | Conditional formatting turns the cell red if you forget to convert. | | Frequency (MHz) | Required for band planning. | Dropdown list of all amateur bands (1.8, 3.5, 7, 14, 21, 28, 50, 144, 432). | | Mode | SSB, CW, FT8, AM. Critical for awards. | Color-coded cells: Blue for Digital, Green for Voice, Yellow for CW. | | Callsign | The most important field. | Text automatically converts to uppercase. No "k4abc" errors. | | RST Sent | Signal report you gave. | Dropdown menu from 559 to 599 (or 59 for phone). | | RST Received | Signal report you got. | Dropdown menu. | | Name/OP | Personalizes the contact. | Helps you remember "That guy from Ohio." | | QTH (Location) | City, State, or Country. | Separate columns for State (for WAS award) and Country (for DXCC). | | Power (Watts) | QRP stations need this for bragging rights. | Auto-calculates the difference between your power and 100w (dB loss/gain). | | QSL Status | Have you sent a card? Received one? | Dropdown: Sent, Received, Bureau, eQSL, LoTW, Confirmed. | | Remarks | QRM, QRN, funny conversation, equipment used. | 3-line tall text box. No squinting. | Upgrade Your Shack: The Ultimate Ham Radio Log
- Go to
File > Print. - Select "Landscape" orientation.
- Select "Fit Sheet on One Page."
- Print 10 double-sided copies. Clip them to a clipboard with a pencil.
