ADIF to KML converter

I, Andrew ZL3DW, built an application which converts ADIF to Excel and then Excel to KML file.

This plots your worked callsigns (if the Maidenhead grid or field is known) on to Google Earth. In Google Earth, you get a yellow pin showing the callsign. If you click on the pin you get QSO details and zoom into the grid square.

License: GNU GPL
The code is free. If you want to use the code in your project it should be free as well.

What the Program Does
What it does is take a ham radio log in standard ADIF (Amateur Data Interchange Format) that most electronic logs support and turns it into a Microsoft Excel File. Then it turns the Excel file into a Google Earth .kml file. When you load the KML by double clicking the file, it will automatically start Google Earth.

The KML file will display all log entries that include a Maidenhead Grid reference as a yellow pin on the Earth. Each yellow pin displays the callsign of the station and is centred in the centre of the grid square. If you click the yellow pin, you get a text box showing the QSO details. A double click zooms in so that the grid square fills the screen view. If you are very lucky you might even spot the station's Yagi antenna!

The Excel file can also be used for analysing your log using Excel's math and chart functions. For example a plot of the beam heading for each QSO. The program calculates the latitude and longitude of each station that has a Maidenhead grid square listed in the log entry.

Harald DL1HW wrote the original ADIF to Excel code but I added a lot for this project. He was very pleased with my additions and listed the resulting program on his club website. He is happy for me to list it on my club website as well.

If you list the software my only request is that you include a note on the download page crediting myself (Andrew Barron ZL3DW) and Harald DL1HW for the work. Please also state "License: GNU GPL The code is free. If you want to use the code in your project it should be free as well".

Download here or click on the key visual above.

Version history:
20100307 V1.0

See also:

NZART website