Navigation

 

     Contact Details

     Peter Miles
     Northam, Western Australia
     QRZ Page: VK6YSF

 

     Email

     

 

       Social Media

             

 

 

WSPRnet CHARTING OVERVIEW

Step by step guide for exporting WSPRnet data to Microsoft Excel for charting. 


HOME  > OPERATIONAL >REFERENCES >

 

Graphing history of WSPR pings from the WSPRnet database. Below are three effective techniques for exporting WSPRnet data to Microsoft Excel for charting, sorting and or archiving WSPR data.

 

1

My original method of coping and pasting to a text editor and then opening the the text file with Microsoft Excel import Wizard.

WSPR CHARTS V1

2

A more direct method of coping the data and using Microsoft Excel / Past Special to complete the import. Note: Preferred method.

WSPR CHARTS V2

3

Direct Web data import from Microsoft Excel. Very useful method. Including the ability to save the query so that the entire process can be saved as *.igy file

WSPR CHARTS V3

 

 

Example of WSPR data has been graphed using Microsoft Excel to compare two antennas. Horizontal axis = UTC Time, Vertical axis = dB below the noise floor. 

 

  

TOP OF PAGE

Page last revised 05 May, 2025

 

 

   Space Weather

 

   https://www.swpc.noaa.gov/

    

   Notice Board

VK6YSF JS8Call, FSQ and Olivia 8/250 operations.

Current activity is generally, however not restricted to operations with JS8Call, FSQ and Olivia 8/250 on the 20m and 40m band.

Proposed band and mode activity is often communicated on HamSpots: https://hamspots.net/js8/ or my profile on 

X: https://x.com/vk6ysf97230 .

Feel free to contact me to discuss or arrange a schedule for a contact.

 

VK6MJM LF (136 kHz) and MF (474 kHz) Beacon

VK6MJM is a  LF/MF station located in Manjimup, Western Australia.

Mode: Mode: FST4W 300 (Similar to WSPR)

Station details were presented by Peter Hall (VK6HP) at PerthTech 2024.Presentation PDF: Peter Hall VK6HP at PerthTech

QRZ Page: VK6MJM on QRZ.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

All content may be used for unlimited distribution with full credits.

Amateur Radio Station VK6YSF - Promoting amateur radio communication and experimentation.