For a long time I would like to use the data from the database on WSPRnet.org in my logbook to count DXCC and to do other things with it. Unfortenately the .csv database files that can be downloaded are too large to compile and I do not have the knowledge to do such a thing for example with SQL. Via Paul PC4T we know now that it is easy to copy the text with “special paste” in excel and make nice diagrams with it. So I searched on the internet for a excel sheet that could convert text to ADIF for import in you favourite logger in my case HRD. Now, you can find a lot about the subject and it seems to be easy to make a excel sheet with the help of this website: http://www.g6csy.net/ham/adif.html. If you can get the formulas working this is the way to go. Unfortenately it doesn’t work on my computer whatever I tried, the result was a crash of excel. After hours of trying I decided to find something else and came across the website of DL1HW were you can find adif2xls2adif.xls. This became my base for conversion to ADIF te way I like it. What software do you need:
- Windows notepad (or another text editor)
- adif2xlsadif.xls and of course Excel
- Log Converter
- Any logger that can import ADIF format
Log Converter is a program that is part of contest log checker, it is commercial but you can use it for free till 100 entries. More then enough for me as you don’t get that much unique spots when transmitting with max. 1W. Now, you can’t use the plain text as copied from the database it should be edit a little before pasting it in excel. But if you’ve done that a couple of times it will go faster. Here a step-by-step description:
– Copy the data from the WSPR database to notepad
– Insert a TAB between the date and time
– Go to replace (CTRL+H)
– In the pop up replace: replace the date for the format YYYYMMDD, replace your own call (in case PE4BAS) for the mode (WSPR or JT65), replace the “:” between the time for nothing, replace your own locator (in my case JO33jk) for the band (for example 10M). Close the replace pop up.
– Copy the text with CTRL+A and CTRL+C
– Open adif2xls2adif.xls and remove all data on tab 2 except the line with column names.
– Change the column names and in this order: QSO_DATE, TIME_ON, MODE, RST_RCVD, BAND, CALL, GRIDSQUARE.
– Paste with “special paste” the text beneath it and copy the right data in the right columns. Unused data can be removed
– Go to tab 1 and enter the preferred ADIF sequence at the second line to the same order as on tab 2. choose #2 to activate it.
– Select the data on tab 2 and choose the red arrow “to ADIF” on tab 1 to convert, you’re now able to choose a name and path.
– Open Log Converter and open the just made ADIF file.
– Check for errors like early time spots, 930 should be 0930. You can change that in Log Converter.
– Save the ADIF file.
– Open a logger of choice like for example HRD and import the ADIF.
If adif2xls2adif is now saved it will remember the settings and that saves some steps next time.
As the xls file is cardware don’t forget to thank DL1HW for it with a card via post or bureau. My card for him is on it’s way via the bureau!
I hope this is helpfull for some of you…