How to convert Davis WeatherLink .wlk files to CSV or Excel

Updated November 22, 2026 · By WLKExport

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.

What is inside a .wlk file

Davis describes the format in the Readme that ships with WeatherLink. In short:

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

  1. Open WLKExport. Choose your units: imperial as stored, or metric (°C, hPa, km/h or m/s, mm).
  2. Drop the station folder on the page, or choose the .wlk files, or add a ZIP that contains them. Nothing is uploaded: the files are read on your computer.
  3. 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.
  4. Press Convert and download the ZIP.

What you get: columns and units

records-YYYY.csv, one per year, one row per archive record:

ColumnImperialMetric
Date, TimeYYYY-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%
BarometerinHghPa
Raininmm
Hi Rain Ratein/hmm/h
Wind Speed, Hi Wind Speedmphkm/h or m/s
Wind Dir, Hi Wind Dir16-point compass (N, NNE, NE…); empty when calm
Wind Samples, Archive Intervalcount; minutes
Solar Rad, Hi Solar Rad, UV Index, Hi UV Index, ETW/m², index, inW/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 files

Other ways to do it

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.

Convert my .wlk files