What ADIF is
The Amateur Data Interchange Format (ADIF) is the standard file format for amateur radio logs. Almost every logging program can export it, including Log4OM, N1MM Logger+, WSJT-X, HRD and online logbooks such as QRZ.com and Clublog. An ADIF file is plain text, with each contact made of fields like <CALL:5>W1ABC and ending with <EOR>.
What you can do here
- Convert ADIF to CSV to open your log in Excel, Google Sheets or LibreOffice for your own analysis.
- Convert CSV to ADIF to import a paper log you've typed into a spreadsheet. Use ADIF field names as the column headings, such as CALL, QSO_DATE (YYYYMMDD), TIME_ON (HHMM), BAND, MODE, FREQ, RST_SENT and RST_RCVD.
- Find duplicates before uploading to LoTW or a contest robot, or after merging logs.
- Count countries, bands and modes to see how you're doing towards DXCC and other awards.
- Filter and export part of a log, such as one band or one day's activation.
Your log stays private
The file is read by your browser and never uploaded. Country names come from the same prefix data as the callsign prefix lookup, and if your log already has a COUNTRY field, that's used instead.
Questions
How do I convert ADIF to Excel?
Open your .adi file here and press Download as CSV. Excel opens CSV files directly.
How do I turn a spreadsheet log into ADIF?
Save it as CSV with ADIF field names as the column headings, such as CALL, QSO_DATE, TIME_ON, BAND and MODE, then open it here and press Download as ADIF.
Is my log uploaded?
No. It's read and processed entirely in your browser.
Why are some countries wrong?
Prefix lookups can't know about every special callsign. If your logging program adds a COUNTRY field to the ADIF, that's used instead.