ADIF FilesĪDIF is the most flexible and portable file format for ham radio logging. Excel (or another spreadsheet) will handle this format but make sure you output a clean CSV file. Its native file format is plain text so it won’t inadvertently add in additional formatting or characters. For this, I use a simple text editor such as Windows Notepad. For example, if Joyce/K0JJW and I worked the same set of chasers from a summit, I can create a new log file by doing a find/replace of my callsign with her callsign. Sometimes it is very helpful to just be able to edit a CSV file directly.

An example of a CSV file from a SOTA activation. Note that the first line contains the header information that defines the variables in the subsequent lines. Below is a CSV file generated for a SOTA activation. These files are a bit cryptic but can be read by humans with just a little effort.

HAMRS exports files in ADIF format.Ī CSV file just has the variables of interest separated by commas, usually one QSO on each line. I have not encountered any serious issues and I really like the implementation. There are some bugs here and there but Jarrett continues to release bug fixes and new features at a steady rate. The user interface is tuned for portable operating with just enough features and not a lot of fluff. I’ve been using it on Windows, an iPad, and my iPhone. It runs on multiple platforms, including Windows, Linux, Mac, iOS and Android. The HAMRS logger is a relatively new logging program by Jarrett/KB0ICT.

The SOTA CSV Log Editorįor POTA activations, we tend to have a larger number of QSOs so I try to log them in real-time on a computing device. This Windows program uses CSV for the log files but it can also export the log in ADIF (Amateur Data Interchange Format). This program is reliable and easy to use. Later, I use the SOTA CSV Log Editor by G0LGS to enter the information into a CSV (Comma Separated Variable) file. If the number of QSOs is small, the paper method is easy and reliable. SOTA and POTA Logging Toolsįor SOTA, Joyce/K0JJW and I normally just use a paper log. Here are a few tools and tips to assist with your portable logging. Some of this comes from the idiosyncrasies of the logging software but often the errors are introduced by the operator. Even more common, I need to double-check and fix errors in my SOTA and POTA logs. The logging requirements for the two programs are different so I often need to adjust the log file before submitting it. Lately, the majority of my radio activity has been SOTA and POTA activations, sometimes simultaneously.

Adif to csv conversion