View source for How to import KNMI weather data into Microsoft Excel

For importing [[KNMI_Weather_data|KNMI Weather data]] into Microsoft Excel for further processing in the Tygron Platform you need to import a text file into an Excel spreadsheet. Based on what version of Office you have installed you need to choose which one of the steps below you need to preform.<br>

==Activate the text import wizard in Office 2019==
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.

[[File:SelectLegacyTextImportWizard1.jpg|300px|right|Select Data > Get Data > Legacy Wizards > From Text (Legacy)]]

{{Editor steps|title=activate the legacy Text Import Wizard in Excel|Select '''File''' > '''Options'''|Select '''Data''' from the ''Excel options''|Under ''Show legacy data import wizards'', select '''From Text (Legacy)'''|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.<br>

<br clear=all>

==Text Import Wizard==
{{Editor steps|title=import the text file in Excel|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.|On this panel, select the '''comma''' as separator.|Select '''Finish''' to proceed}}

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.

<gallery>
File:ImportTextWizardStep1of3-1.jpg|Step 1
File:ImportTextWizardStep2of3-1.jpg|Step 2
File:ImportTextWizardStep3of3-1.jpg|Step 3
File:ImportSuccess1.jpg|Step 4
</gallery>

==Activate the text import wizard in older Office versions==
Select '''Data''' > '''Get External Data''' > '''From Text'''. In the '''import File''' dialog, select the KNMI file you need.
:''Reference to Microsoft support about text import in other Office versions: [https://support.office.com/en-us/article/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857 Text Import Wizard]

{{article end
|seealso=
* [[KNMI Weather data]]
}}[[Category:How-to's]]