How to import KNMI weather data into Microsoft Excel

From Tygron Support wiki
Revision as of 10:54, 16 December 2019 by Hansje@tygron.com (talk | contribs)
Jump to navigation Jump to search
Main article: Text Import Wizard

When importing KNMI weather data into Microsoft Excel for further processing in the Tygron Platform, the following steps are advised.

Office 2019 and later

In the newest versions of Excel, the import from text/csv route is simplified and will probably not properly interpret the data as numbers. It is better to use the legacy method, for which the legacy Text Import Wizard needs to be activated first.

Select Data > Get Data > Legacy Wizards > From Text (Legacy)
How to activate the legacy Text Import Wizard in Excel:
  1. Select File > Options
  2. Select Data on the panel Options for Excel
  3. Under Show legacy data import wizards, select From Text (Legacy)
  4. Select OK

When the legacy Text Import Wizard is activated, it can be found under: Data > Get Data > Legacy Wizards > From Text (Legacy). When prompted, in the import File dialog, select the KNMI file you need.

Older Office versions

Select Data > Get External Data > From Text. In the import File dialog, select the KNMI file you need.

Text Import Wizard

Step 1 of 3

As the data in the KNMI files is separated by commas, select Delimited. It can also be convenient to enter '32' as the line number to Start import at row, to skip the header texts from the file and start at the top of the table of actual values. If the date range is also known, that line number can be used too. No other settings are required in this step.

Step 2 of 3

On this panel, select the comma as separator. Nothing else needs to be changed here.

Step 3 of 3

On the last panel also no changes are needed. Select Finish to proceed.

Import Data panel

ImportSuccess1.jpg

The final step before the end result is displayed is the Import Data panel. On the last panel there are options to select on which (starting) cell the data must be imported, or if a new work book must be used. This is all optional and no changes are required here either.

When the import is done, the KNMI data should appear on the workbook. A good indication that the conversion from text to numbers was succesfull, is that all cells with a number in them are alligned on the right side of their cells (text always alligns to the left by default).