

Time fields are expected to be HHMM and will be normalized such that low-order hours will have leading zeros. The MODE and CALL fields are converted to upper case. For all fields, leading and trailing spaces are stripped. Additional fields can be added without modifying the program.Ī few conversion are performed along the way. This allows the program to be somewhat adaptable and self-documenting. This header should contain the ADIF field names of the fields. The CSV file will need to have a header row.

The input format is best demonstrated by example ( sample). Will convert the input file “mylog.csv” to “mylog.adif” and store it in the current working directory. So, I produced a simple tool (csv2adif.py) that will convert CSV files to ADIF files. While ADIF files are also plain-text, the format is arcane and inconvenient for manual entry. Converting CSV files to ADIFįortunately, all QSO matching services and logbook programs support a standard format called ADIF. This allows me to view these logs long after Excel is gone and easily repair corruption should it happen. This can be easily read without the program and will likely still be usable 50 years in the future. As an added bonus, it can be stored in a simple text file format (comma separated values or CSV). I can skip from field to field with tab and QSO to QSO using enter. I can easily drag ranges to fill in repeating information.

Microsoft Excel is just that – an editable grid. Honestly, it’s a pain to keep wiping out the current time, clearing out the seconds field (I don’t write them down in that level of detail), and repeating the mode, date, and power.

