How to import KNMI weather data into Microsoft Excel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
(Created page with "Main article: When importing KNMI weather data into Microsoft Excel for further processing in the Tygron Platform, the following steps are advised. ==Excel 2019 and later==...")
 
No edit summary
Line 1: Line 1:
Main article:  
Main article: [https://support.office.com/en-us/article/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857 Text Import Wizard]


When importing KNMI weather data into Microsoft Excel for further processing in the Tygron Platform, the following steps are advised.
When importing KNMI weather data into Microsoft Excel for further processing in the Tygron Platform, the following steps are advised.
Line 10: Line 10:
When the legacy Text Import Wizard is activated, it can be found under: '''Data''' > '''Get Data''' > '''Legacy Wizards''' > '''From Text (Legacy)'''.
When the legacy Text Import Wizard is activated, it can be found under: '''Data''' > '''Get Data''' > '''Legacy Wizards''' > '''From Text (Legacy)'''.


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

Revision as of 11:43, 30 September 2019

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.

Excel 2019 and later

In the newest versions of Excel, the import from text routine 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.

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).

Select Data > Get Data > Legacy Wizards > From Text (Legacy)