CSV to ADIF — turn a spreadsheet log into an .adi file
Convert a ham radio log kept in a CSV file into ADIF (.adi) for LoTW, eQSL, QRZ, Club Log or any logging program. Columns are recognised by their names. In your browser, nothing uploaded.
About this conversion
Each row becomes a QSO. Columns are recognised by their names — Call, Date, Time (UTC), Band or Freq, Mode, RST sent, RST rcvd, Name, QTH, Grid, Country, State, Power, Park, Summit, Notes and the like, or the ADIF field names themselves (QSO_DATE, TIME_ON, GRIDSQUARE…), so a sheet saved from this page comes back unchanged. Dates such as 2024-01-15, 15.01.2024 or an Excel date become 20240115; times such as 14:30 or 2:30 PM become 1430; a frequency in kHz (14074) becomes MHz. Rows without a callsign, and columns that are not recognised, are left out — the page says which.
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 must the sheet have?
- A callsign column, and at least one of date, band, frequency or mode. Everything else is optional.
- Is the time UTC?
- ADIF expects UTC. The times are taken as they are in the sheet, so a sheet kept in local time should be converted first.