ADIF to CSV — a ham radio log as a spreadsheet file
Convert an ADIF log (.adi, .adif, .adx) to CSV: one row per QSO, one column for every field in the log. Opens in Excel, Google Sheets and Numbers. In your browser, nothing uploaded.
About this conversion
A CSV is the simplest way to take a log into a spreadsheet or a script. Each QSO becomes one row and each ADIF field one column, named as in ADIF (QSO_DATE, TIME_ON, CALL, BAND, FREQ, MODE and so on), so nothing in the log is left out. The file is UTF-8 with a byte-order mark, so Excel shows accented names correctly. Filter the log first — a band, a year, a country — and tick “only the QSOs shown” to export just those.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same log, other ways
The log stays open after it is read, so the format is picked at the end: the same file can leave here as ADX (.adx), Excel (.xlsx), JSON, Cabrillo (.log), POTA (.adi) or SOTA CSV (V2). Before that you can filter it by band, mode, year, country or QSL status and save only those QSOs.
Questions
- Which columns does it have?
- One for every field that appears in at least one QSO: the usual ones first (date, time, call, band, frequency, mode, reports, name, QTH, country, grid, QSL), then the rest in the order they appear in the log.
- Can a spreadsheet open it with the dates as dates?
- Dates stay in ADIF form (20240115) so the file can go back into a logger unchanged; a spreadsheet can format the column as a date if you want.