Making sense of WSPR CSV files

For various reasons I’ve been searching through downloaded WSPR spot databases by hand today. The downloads are provided in a simple CSV format that’s very easy to work with. The only difficulty is the Unix timestamp in the second field; while this is very convenient when processing the file, it isn’t exactly easy to read.

To save myself working it out again next time, the following bit of gawk(1) magic converts the output to something readable: