Download and open your LoTW ADIF
Logbook of the World gives your confirmations as an ADIF file called lotwreport.adi. Here is where to get it — then drop it below to see the QSLs in a table, on a map, or as Excel.
Where to download it
Log in at lotw.arrl.org, open Your QSOs and choose Download Report. Set “Show QSLs received since” to an early date to get all of them — or to the day you last downloaded, for only the new ones. Tick “Include QSL detail” to get the other station’s grid, state and county as well, pick your call sign if you have several, and press Download report. The file is lotwreport.adi.
What is in it — and what is not
Only confirmations: QSOs the other station uploaded too and LoTW matched. QSOs nobody has confirmed are not in the report, so it is not a backup of your log. LoTW marks each confirmation in QSL_RCVD and adds its own APP_LoTW_ fields; the page shows them as they are.
Into your own log
To mark these confirmations in your own log rather than just look at them, drop your log and lotwreport.adi together on Add LoTW confirmations to your log.
What is tested — and what is not
The steps are from ARRL’s own LoTW guide to Your QSOs. The page reads LoTW report files as LoTW writes them, APP_LoTW_ fields included. We did not download a report from a LoTW account of our own: if LoTW has changed its menu, the names may differ a little.
Questions
- Do I need TQSL to download the report?
- No. TQSL signs and uploads your QSOs; the report is downloaded from the LoTW website, logged in with your LoTW user name and password.
- Is my LoTW password sent anywhere?
- No. You download the file from LoTW yourself; this page only reads the file in your browser, and never asks for the password.