I recently was involved in uploading my logs to the ARRL's Logbook of the World and found that I had a few contest logs that were done on paper which I needed to "easily" put into the computer. In searching the Internet for a suitable program, I found nothing that would do it as quickly as I wanted. I felt all I should have to input was the Date, Time, Band, Mode and Callsign. So, I wrote an Excel spreadsheet to do this.
While I was writing it I emailed the LoTW desk at ARRL with a question about the minimum requirements for an LoTW log upload and they responded by sending me a link to another spreadsheet written by W8TM (I didn't know him before this but that's a really similar call to mine, hi!) Paul, W8TM, had written a similar spreadsheet to what I was doing but his required you to enter the exact frequency, type in the full name of the mode and type the Date, Time and Mode for each QSO. I was trying to keep it simple and quicker so my version lets the computer do a lot of the work for you. But, I did "borrow" (with his permission) the part of Paul's spreadsheet that would take the log info and create an ADIF file and added it to mine.
For those who want to enter the exact frequency or who are not very concerned with speed, here is a link to Paul's spreadsheet which works just fine. Click on the "Excel - ADIF Conversion Spreadsheet" link:
Be sure to follow the instructions
Once you have keyed in the data, the spreadsheet will create an
ADIF file from that data. You can then either import it into a
full-featured logging program or directly upload it to LoTW.
Here is the ZIP archive that contains the Spreadsheet and the M/S Word Instructions. Just click on this link to download the ZIP'ed files:
Once you have downloaded this file, unzip it and you will have an Excel spreadsheet file called "BasicLog v1.0" and a Microsoft Word document which contains the full instructions. Be sure to follow the instructions for saving the data EXACTLY or you may have difficulty. It is very easy to use once you have done it.
NEVER work with the original
file you downloaded. Always do a "Save As" of the file before you enter
any data. That way you are always working with a copy of the program and
the next time you want to enter data you will be able to start with a fresh
file. If you fail to do this you will have to either unzip the downloaded
file again or come back to this page and download a new copy of the ZIP file.
You CAN NOT just erase the data and start over.
If you have any problems, questions or comments, please contact me. I would be pleased to hear from you if this program works well for you. Here is my contact info:
This page has been accessed times.
This page last updated 16 Dec 2005.