- This line was added.
- This line was removed.
- Formatting was changed.
Table of contents:
|Table of Contents|
About Import to Excel
You are able to import the JSON response of an API query directly into newer versions of Excel by following the guide below.
From Excel data can easily be saved in .csv format.
If you want to convert JSON directly into a .csv file several "JSON to CSV converters" can be found online.
How to query the DMI Open Data API directly from Excel
|1||Open Excel and click the Data tab|
|2||Click New Query > From Other Sources > From Web|
Enter your DMI open data query in the URL text field and press OK
(Remember to include your api-key in the query)
|4||Click Into Table (on the convert tab)|
Right click the value of "features" (List)
Click Drill Down
|6||Click To Table|
|8||Click the button with left and right arrows|
Uncheck "use original column name as prefix"
|10||Click the button with left and right arrows at the top of the "geometry" column.|
Click the button with left and right arrows at the top of the "coordinates" column.
Click Extract Values
(you can also choose "Expand to New Rows". This will give you two identical rows for each observation. One row for latitude coordinates and one for longitude).
Select a delimiter from list for concatenating the coordinates
(In this example we chose tabulator semicolon as the delimiter)
Image RemovedImage Added
Click the button with left and right arrows at the top of the "properties" column
Press OK in the the window that appears
|1314||Click Close and Load to finalise the import process.|