Ham radio logbook Excel template
Keep your log in Excel and get a real ADIF file when you need one: download the template, fill in one QSO per row, and drop the saved workbook below.
Download the Excel template .xlsx, no macros
What is in the template
A Log sheet with the columns Date (UTC), Time (UTC), Call, Band, Freq (MHz), Mode, RST sent, RST rcvd, Name, QTH, Grid, Comment, My call and My grid, and the first row frozen. Band and Mode offer a list but take anything you type. Date and time are text columns, so Excel does not turn 09/11 into a date of its own choosing. A second sheet says how to fill it in.
From Excel to ADIF
Save the workbook and drop it here: every row with a call becomes a QSO — dates like 2026-11-09 or 09.11.2026, times like 1430 or 14:30. Save as ADIF gives the file for TQSL and LoTW, QRZ, Club Log or any logger; Check ADIF then writes FT4 and other submodes the ADIF way.
Your own columns
Add a column named after any ADIF field — STATE, TX_PWR, SOTA_REF, POTA_REF — and it goes into that field. Other columns are kept as APP_CSV_ fields rather than dropped.
What is tested — and what is not
Tested: the template opens in an independent reader (openpyxl) with its columns, lists and frozen row; filled in and saved by it, it converts here with every field in place, also when dates and times are stored as Excel dates. Not tested yet: filling it in and saving it in Microsoft Excel itself, or in LibreOffice — both rewrite a file when they save.
Questions
- Does it work in Google Sheets or LibreOffice?
- It is a plain .xlsx with no macros, so they open it. Saving from them is not tested yet; the page shows every QSO it read before you save, so you can see whether anything is missing.
- Can I add QSOs over years?
- Yes — keep adding rows. The lists and text columns are set up for the first 5,000 rows; below that you can still type, without the list.