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.
|