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

My old WeatherLink won’t run anymore. How do I get my .wlk weather data into Excel?

“I have years of readings from my Davis Vantage Pro2 in a folder of .wlk files, and the WeatherLink software no longer runs on my new computer.” WLKExport reads those files directly. Drop single files or the whole station folder: it converts every month and every year at once to CSV and Excel, in imperial or metric units, right in your browser.

  • Nothing uploaded, nothing installed
  • Works on Windows, Mac and Linux
  • Your .wlk files are only read, never changed

At a glance

What WLKExport does and doesn’t do

  • Works withThe monthly .wlk files of Davis WeatherLink for PC (versions 5 and 6: Vantage Pro, Vantage Pro2, Vantage Vue). Single files, a whole station folder, or a ZIP of them.
  • ProducesCSV of archive records (one file per year), a daily summary as CSV and as Excel (.xlsx), all in one ZIP. Imperial or metric units, written in the column headers.
  • Shows firstMonths and years found, number of records, archive interval, missing months, the first rows and a chart of daily high and low temperature.
  • Runs onAny browser, on Windows, Mac, Linux or Chromebook. Nothing to install: you don’t need WeatherLink.
  • FreeThe full preview of everything you add, and 2 monthly files converted per batch, in full.
  • Full$9 one-time. Every monthly file, any number of batches. No subscription.
  • PrivacyYour files never leave your device and are not modified.
  • Doesn’tRead data from WeatherLink.com, WeatherLink Live or the WeatherLink app (the cloud). It doesn’t read files of other brands and doesn’t write .wlk files. Extra temperature/humidity, soil and leaf sensors are not exported, and dew point, wind chill and heat index are not calculated. Not a Davis Instruments product.
The CSV and XLSX open in
  • Excel
  • Google Sheets
  • LibreOffice Calc
  • Numbers
  • R
  • Python
1 per year

one CSV of records for each year, so every file fits in a spreadsheet

Columns and units
0 bytes

of your weather data sent to any server

How it works
2

monthly files converted free per batch, with the full preview

Try it
$9

once, every file, no subscription

Pricing

The problem

Ten or twenty years of readings, locked in files only one old program opens.

“The WeatherLink software that came with my station doesn’t run on my new computer. All my history is in .wlk files. How do I open them?”

A .wlk file is binary

WeatherLink saves one file per month, 2008-01.wlk, 2008-02.wlk… They are not text. Excel, Numbers and Google Sheets cannot open them.

The program is the only door

WeatherLink for PC can export records, if it still installs and opens on your computer. On a new Windows PC or a Mac that is often the end of the road.

Hundreds of files

Twenty years are 240 monthly files. The other answers are command-line projects on GitHub: fine if you use a terminal, a wall if you don’t.

How it works

Three steps. No WeatherLink, no terminal.

  1. Step 1

    Find your station folder

    WeatherLink keeps it inside its program folder (by default C:\WeatherLink\), with one YYYY-MM.wlk file per month. Copy it from the old computer or a backup. Where to look

  2. Step 2

    Add the files or the folder

    Drop the folder, pick files, or add a ZIP. You see the months and years found, the record count, the archive interval, any missing months and a temperature chart. Nothing is uploaded.

  3. Step 3

    Choose units, download the ZIP

    Imperial or metric. You get one CSV of records per year, plus daily-summary.csv and daily-summary.xlsx. Missing readings are empty cells.

Convert

Add your .wlk files or your station folder

Everything runs on this page. Your weather data never leaves your device.

Drop your .wlk files or the station folder here

Files named like 2008-01.wlk, a folder full of them, or a ZIP. Nothing is uploaded.

Rain is converted from the collector type stored in each record. Readings the station did not have come out as empty cells, not as numbers.

Free: full preview, and 2 monthly files converted per batch. Unlock every file for $9.

Plain files

Your history, in files any program reads.

No special viewer and no account. A header row with the units, one row per record, dates as YYYY-MM-DD. These lines come from a real February 2012 file, converted to metric.

  • records-YYYY.csvEvery archive record of that year, at the interval your station logged (1, 5, 10, 15, 30, 60 or 120 minutes).
  • daily-summary.csv and .xlsxOne row per day: highs, lows, means, rain total, high wind speed. In the workbook, numbers are numbers and dates are real dates.
  • all-records.csvEverything in one file, added when the batch has 1,000,000 records or fewer, so it still opens in a spreadsheet.
records-2012.csv
Date,Time,Temp Out (°C),Hi Temp (°C),Low Temp (°C),Out Hum (%),Barometer (hPa),Rain (mm),…
2012-02-01,00:01,-4.6,-4.6,-4.6,68,1027.6,0,…
2012-02-01,00:02,-4.6,-4.6,-4.6,68,1027.6,0,…
daily-summary.csv
Date,Hi Temp (°C),Low Temp (°C),Mean Temp (°C),Hi Hum (%),Low Hum (%),Mean Hum (%),…
2012-02-01,-1.9,-5.6,-3.9,75,45,62.1,…
2012-02-02,-4.2,-9.2,-6.5,70,43,57.7,…

What you get

A .wlk converter, as a web page.

Until now this job meant the original program or a command-line project. WLKExport does it with a file picker, on Windows, Mac or Linux.

Single files or the whole folder

Pick a few months, drop the station folder with every year in it, or add a ZIP. Files are sorted by the year and month in their names.

CSV and Excel (.xlsx)

Archive records as CSV, one file per year. A daily summary as CSV and as a real .xlsx workbook, with numbers and dates typed as such.

Imperial or metric

°F, inHg, mph and inches as stored, or °C, hPa, km/h or m/s and mm. The unit is in every column header.

Rain from the collector type

Rain is stored as bucket tips plus the collector size. Each record is converted with its own size: 0.01 in, 0.2 mm and the others.

Preview before converting

Months and years found, records, archive interval, missing months, the first rows as they will be written, and a daily high / low chart.

No absurd numbers

A missing reading is an empty cell, never 32767 or -3276.8. Your files are only read: nothing is changed and nothing leaves your computer.

Compared

Three ways to get data out of .wlk files.

The other routes are good and free. WLKExport is for when the original program no longer opens and you don’t want a terminal.

FeatureWLKExportWeatherLink for PC (Browse > Export Records)Open-source converters on GitHub
What it is forTurning a folder of .wlk files into CSV and ExcelExporting the records you are browsing to a text fileConverting to CSV, or importing into WeeWX or Cumulus
CostFree for 2 monthly files per batch, $9 once for allIncluded with the software you already ownFree
What you needA browserWeatherLink installed and working, on WindowsVaries: a runtime such as Java, Python or .NET, or a Windows program
Works on a Mac or LinuxYesNo (Windows software)Some do
All years in one goYes, the whole folderOne export per date range you selectUsually yes
Excel workbook (.xlsx)Yes, for the daily summary; records as CSVNo: a text file you open in ExcelUsually CSV only
Metric or imperialYour choice at exportThe units set in the programVaries
Calculated values (dew point, wind chill, heat index)NoYesSome do
Extra, soil and leaf sensorsNoYesSome do
Files leave your deviceNeverNeverNever

Pricing

Free for 2 monthly files per batch. $9 once for all of them.

Start free

Free

$0

See everything that is in your files and convert 2 monthly files per batch, in full.

Convert my .wlk files
  • Full preview of every file you add
  • 2 monthly files converted per batch, complete
  • CSV, daily summary and .xlsx
  • Imperial or metric, no account

ONE-TIME

WLKExport Full

$9 USD

one-time · every file · any number of batches

Unlock every file, $9
  • Every monthly file converted
  • All your years in one ZIP
  • Run it again whenever you want
  • No subscription
Secure checkout by Stripe. The full version unlocks in the browser you pay from. Questions: support@cedanolabs.org.

FAQ

Questions about converting WeatherLink .wlk files

Want the long version? Read the guide.

Read the guide
How do I convert Davis WeatherLink .wlk files to CSV or Excel?

Add the .wlk files (or the whole folder of your station) to WLKExport. It reads every monthly file in your browser, shows which months and years it found, and gives you a ZIP with one CSV of archive records per year, a daily summary as CSV and as an Excel workbook (.xlsx). You do not need WeatherLink installed, and nothing is uploaded.

Where are my .wlk files?

WeatherLink for PC keeps one folder per station inside its program folder, by default C:\WeatherLink\ followed by a folder with the name of your station. Inside it there is one file per month, named by year and month: 2008-01.wlk, 2008-02.wlk and so on. Copy that station folder from the old computer (or from a backup) and add it here. The files must keep their names, because a .wlk file does not store its own year and month.

My old WeatherLink no longer runs on my new computer, or I have a Mac. Do I need it?

No. WLKExport reads the .wlk files directly. It is a web page, so it works in a current browser on Windows, Mac, Linux or a Chromebook, with nothing to install. All you need are the files.

Which columns do I get?

One row per archive record: date, time, outside temperature and its high and low in the period, outside humidity, barometer, rain in the period, high rain rate, wind speed, wind direction, high wind speed and its direction, inside temperature, inside humidity, the number of wind samples received and the archive interval. If your station logged them, solar radiation, high solar radiation, UV index, high UV and evapotranspiration are added. The units are written in each column header.

Can I get metric units? How is rain converted?

Yes. Choose imperial (°F, inHg, mph, inches, as the file stores them) or metric (°C, hPa, km/h or m/s, mm). Rain is stored as bucket tips (“clicks”) together with the type of rain collector: 0.01 in, 0.2 mm, 0.1 in, 1 mm or 0.1 mm per click. WLKExport reads the collector type from each record and multiplies, so a station with a metric 0.2 mm collector gives exact millimeters.

What happens with readings the station did not have?

They come out as empty cells. The file marks a missing reading with a special number (32767, -32768 or 255, the dashes you see in WeatherLink). WLKExport never writes those as if they were measurements, so a sensor dropout does not become a temperature of -3276.8 in your spreadsheet.

Why one CSV per year? Will it open in Excel?

An Excel sheet holds 1,048,576 rows. A station archiving every minute writes 525,600 records a year, and every 5 minutes about 105,000, so a long history does not fit in one sheet. WLKExport writes one CSV per year, which always fits. When the whole batch has 1,000,000 records or fewer it also adds all-records.csv with everything in one file. The daily summary is always a single file.

What is in the daily summary?

One row per day: high, low and mean outside temperature, high, low and mean humidity, high, low and mean barometer, total rain, high rain rate, mean wind speed, high wind speed and its direction, dominant wind direction, mean inside temperature, and how many records and minutes the day has. It is worked out from the archive records of that day, as daily-summary.csv and daily-summary.xlsx. In our test files the daily high, low and rain equal the daily summary WeatherLink itself stored in the file on every day.

Which time are the records in?

The station’s own local time, exactly as stored. Nothing is shifted and no time zone is applied. Each record is stamped with the end of its archive period, as in WeatherLink. The last record of a day (stored as minute 1440) is written as 00:00 of the next day, and it counts for the day it closes in the daily summary.

Does it read data from WeatherLink.com, WeatherLink Live or the WeatherLink app?

No. It reads the .wlk files that the WeatherLink software for PC saved on your disk. Data that only exists in the WeatherLink cloud has to be exported from there.

Which sensors are not exported?

The extra temperature and humidity sensors, soil temperature and soil moisture, leaf wetness and leaf temperature, the forecast code and the notes attached to records are not exported in this version. Values WeatherLink calculates on screen, such as dew point, wind chill, heat index and THSW, are not calculated either. If you need one of these, email support@cedanolabs.org.

Which stations and WeatherLink versions does it work with?

Files whose first bytes are “WDAT5”: the database format of WeatherLink 5 and 6 for Windows, used with Vantage Pro, Vantage Pro2 and Vantage Vue. It was built from the file description in the WeatherLink Readme and tested with real monthly files from one station (1-minute archive, 0.2 mm rain collector, no solar sensor). The solar, UV and ET columns and the other collector sizes follow the same description but were not checked against a real file. A file in another format is refused with a message, not converted wrongly.

Are my files uploaded or changed?

No. The .wlk files are read by JavaScript on this page, on your device, and the ZIP is built there too. There is no upload step and no account. Your files are only read: WLKExport does not write .wlk files or change yours. The only network requests are for the page itself, cookieless page analytics, and the payment check if you buy the full version, which sends a payment ID and never a file.

Is this a Davis Instruments product?

No. WLKExport is an independent tool by Cedano Labs LLC. It is not made, endorsed or supported by Davis Instruments.

Can I import the result into another weather program?

The output is plain CSV with a header row, which most programs and scripts can read: Excel, Google Sheets, LibreOffice, R, Python, databases. Some weather programs have their own importers with their own column rules, so check theirs. If your goal is only to move the history into WeeWX or Cumulus, the open-source converters on GitHub written for those programs are the direct route.

How many files can it handle?

Files are read one month at a time, so a folder with 20 years of data is fine. The ZIP is built in the browser, without compression, and can hold up to 4 GB. A station archiving every minute produces about 40 MB of CSV per year. If a very long 1-minute history is too heavy for your browser, convert it in two batches of years.

How does the $9 full version work?

Free shows the full preview for everything you add and converts 2 monthly files per batch, complete, so you can check the result with your own data. The full version is a single $9 payment, with no subscription and no account, and converts every file, for any number of batches. It unlocks in the browser you pay from.

Open your weather history in a spreadsheet.

Add your .wlk files or the station folder, check the preview, and download the CSV and Excel files. The preview is free, and so are 2 monthly files per batch.