Converting WSPR data to ADIF

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…


 

Bas, PE4BAS, is a regular contributor to AmateurRadio.com and writes from Groningen, Netherlands. Contact him at [email protected].

2 Responses to “Converting WSPR data to ADIF”

  • Glenn DJ0IQ:

    Hi Bas,

    Does WSPR count for DXCC? I assume JT-65 does but WSPR does not exchange reports as it is a beacon mode.

    Thanks for the technical approach for logging.

    – Glenn DJ0IQ and W9IQ

  • Bas PE4BAS:

    Hi Glenn, WSPR does not even count for a QSO. It is just for your own purposes. Some do like that, like me.

    73, Bas PE4BAS

Leave a Comment

Subscribe FREE to AmateurRadio.com's
Amateur Radio Newsletter
News, Opinion, Giveaways & More!

E-mail 
Join over 7,000 subscribers!
We never share your e-mail address.



Also available via RSS feed, Twitter, and Facebook.


Subscribe FREE to AmateurRadio.com's
Amateur Radio Newsletter

 
We never share your e-mail address.

Please support our generous sponsors who make AmateurRadio.com possible:

KB3IFH QSL Cards

Hip Ham Shirts

Georgia Copper

Ham-Cram
Expert Linears

morseDX

Ni4L Antennas

N3ZN Keys

West Mountain
R&L Electronics


Do you like to write?
Interesting project to share?
Helpful tips and ideas for other hams?

Submit an article and we will review it for publication on AmateurRadio.com!

Have a ham radio product or service?
Consider advertising on our site.

Are you a reporter covering ham radio?
Find ham radio experts for your story.

How to Set Up a Ham Radio Blog
Get started in less than 15 minutes!


  • Matt W1MST, Managing Editor




Sign up for our free
Amateur Radio Newsletter

Enter your e-mail address: