Open a SOTA CSV file — a Summits on the Air log
Drop the .csv and every V2 line opens as a QSO — date, time, call, band, mode, your summit and theirs — in a table you can sort, filter and edit. Save it as ADIF, or as SOTA CSV again, one file per summit and day.
What a SOTA CSV file is
SOTA CSV is the log format of the Summits on the Air database: one QSO per line, no header, ten fields — V2, your callsign, your summit, date, time, band, mode, the other callsign, their summit, a note. The date is day first (dd/mm/yyyy or dd/mm/yy), the time hhmm or hh:mm, the band a name such as 14MHz or 144MHz, the mode CW, SSB, FM, AM, DATA or DV. Your summit alone makes an activation, theirs alone a chase, both a summit-to-summit; a V2SWL line is a listener’s.
Excel turns 0905 into 905 and 01/11/26 into 11 January, and the database then rejects the file. Here the lines are read the way the database reads them — day first, always — and written back the same way. Lines separated by semicolons or tabs, quoted notes with commas, frequencies such as 14.285MHz instead of a band: all read.
What you can do here
Convert SOTA CSV to something else
Questions
- Can I edit a SOTA CSV here?
- Yes. Click a QSO to change any field, or use Edit fields to change many at once — a summit reference, a callsign, a mode. Then save with the SOTA button: one file per summit and UTC day, and one for chases.
- What happens to DATA when I save ADIF?
- ADIF has no mode called DATA — SOTA uses it for every data mode. It is kept as written and the page says so; set the real mode (FT8, PSK31) with Edit fields if LoTW needs it.
- Is the file uploaded anywhere?
- No. It is read by the page itself, in your browser.