How to convert Davis WeatherLink .wlk files to CSV or Excel
Short answer: a .wlk file is a binary monthly database, so a spreadsheet cannot open it as it is. Either export from WeatherLink for PC (Browse > Export Records) if the program still opens, or convert the files without it: add them to WLKExport in your browser and download CSV and Excel files for every year at once, or use one of the open-source converters if you are comfortable with a terminal.
Where the .wlk files are
WeatherLink for PC (the Windows software that came with the Davis data logger) keeps one folder per station inside its own program folder. With a default install that is C:\WeatherLink\ followed by a folder named after your station.
- Inside the station folder there is one file per month:
2008-01.wlk,2008-02.wlk, and so on. Year first, then the month. - The same folder holds the station’s settings and other small files. You only need the
.wlkones, but you can add the whole folder: everything else is ignored. - If the old computer is gone, look in your backups for a folder called
WeatherLink, or search the backup disk for*.wlk. - Keep the file names. A
.wlkfile does not store its year or month inside. The name is the only place that says which month it is.
What is inside a .wlk file
Davis describes the format in the Readme that ships with WeatherLink. In short:
- A header that starts with the text
WDAT5and an index with the number of records of each day of the month. - For each day, a daily summary (highs, lows, averages and totals that WeatherLink worked out) followed by the archive records, one per archive interval: every 1, 5, 10, 15, 30, 60 or 120 minutes, whatever the logger was set to.
- Each archive record holds the time (minutes after midnight, at the end of the period), outside temperature with its high and low, inside temperature, barometer, outside and inside humidity, rain, high rain rate, wind speed, high wind speed, both wind directions, and, on stations that have the sensors, solar radiation, UV and evapotranspiration.
- Everything is stored in imperial units as whole numbers: temperature in tenths of a degree Fahrenheit, barometer in thousandths of an inch of mercury, wind in tenths of a mile per hour.
Rain: clicks and collector type
Rain is not stored in inches or millimeters. Each record holds the number of bucket tips (“clicks”) in the period, and in the same number the type of rain collector the station had: 0.01 inch, 0.2 mm, 0.1 inch, 1 mm or 0.1 mm per click. To get a rain amount you multiply the clicks by that size. A converter that assumes 0.01 inch for everyone gives wrong totals for a station with the metric 0.2 mm collector. The high rain rate is stored the same way, in clicks per hour.
Missing readings
When a sensor had no reading, the file holds a marker instead of a value: 32767 or -32768 in the two-byte fields, 255 in the one-byte fields. WeatherLink shows those as dashes. A naive conversion turns them into -3276.8 °F or a UV index of 25.5, which then wreck every average and chart. They must come out as empty cells.
Converting in the browser, step by step
- Open WLKExport. Choose your units: imperial as stored, or metric (°C, hPa, km/h or m/s, mm).
- Drop the station folder on the page, or choose the
.wlkfiles, or add a ZIP that contains them. Nothing is uploaded: the files are read on your computer. - Check the preview: the months and years found, the number of records, the archive interval, any months missing in between, the first rows, and a chart of daily high and low temperature.
- Press Convert and download the ZIP.
What you get: columns and units
records-YYYY.csv, one per year, one row per archive record:
| Column | Imperial | Metric |
|---|---|---|
| Date, Time | YYYY-MM-DD and HH:MM, station local time, end of the archive period | |
| Temp Out, Hi Temp, Low Temp, Temp In | °F | °C |
| Out Hum, In Hum | % | |
| Barometer | inHg | hPa |
| Rain | in | mm |
| Hi Rain Rate | in/h | mm/h |
| Wind Speed, Hi Wind Speed | mph | km/h or m/s |
| Wind Dir, Hi Wind Dir | 16-point compass (N, NNE, NE…); empty when calm | |
| Wind Samples, Archive Interval | count; minutes | |
| Solar Rad, Hi Solar Rad, UV Index, Hi UV Index, ET | W/m², index, in | W/m², index, mm |
The solar, UV and ET columns appear only when the files contain such data. all-records.csv has the same columns for the whole batch and is added when the batch has 1,000,000 records or fewer (an Excel sheet holds 1,048,576 rows).
daily-summary.csv and daily-summary.xlsx, one row per day: high, low and mean outside temperature; high, low and mean humidity; high, low and mean barometer; rain total; high rain rate; mean wind speed; high wind speed and its direction; dominant wind direction; mean inside temperature; records and minutes covered. The values are worked out from the archive records of the day (the records stamped 00:01 to 24:00), with means weighted by the minutes each record covers.
Not exported in this version: extra temperature and humidity sensors, soil and leaf sensors, the forecast code and record notes. Dew point, wind chill, heat index and THSW are values WeatherLink calculates for display; they are not calculated here.
Do it in your browser
Add your .wlk files or the whole station folder. WLKExport shows what is inside, then gives you one CSV per year plus a daily summary as CSV and Excel, in imperial or metric units. Nothing is installed and nothing is uploaded. Free for 2 monthly files per batch, $9 once for every file.
Convert my .wlk filesOther ways to do it
- WeatherLink for PC itself. If the program still installs and opens on a Windows computer, open the station, go to the Browse window, and use Browse > Export Records. It writes the records of the date range you choose to a text file that Excel opens. This is the route that also gives you dew point, wind chill, heat index and extra sensors. It needs the program working, and one export per range.
- Open-source converters on GitHub. Several projects read
.wlkfiles: search for “Davis WLK converter”, “wlkReader” or “WeatherLink Python”. Some write CSV, others exist to import a WeatherLink history into WeeWX or into Cumulus. They are free and you can read the code. Most need a runtime (Java, Python or .NET) or are Windows utilities, and you run them from a terminal. If your goal is to move into WeeWX or Cumulus, these are the direct route. - WeatherLink.com. Data that was uploaded to the WeatherLink cloud is exported from the website, with its own rules and plans. That is a different source: the
.wlkfiles on your disk are not needed for it, and none of the tools above read the cloud.
FAQ
Do I need WeatherLink installed?
Not for WLKExport or the open-source converters: they read the files directly. Only the Export Records route needs the program.
Does it work on a Mac?
WLKExport runs in the browser, so yes. It reads the files written by WeatherLink for Windows.
Are the times converted to another time zone?
No. They are the station’s local time as stored. The record that closes a day is stored as minute 1440 and written as 00:00 of the next day.
Is anything uploaded?
No. The files are read in your browser and the ZIP is built there. This is not a Davis Instruments product.