Clean your customer master data with Excel 2013 and Public data

great tutorial, thx for sharing

Erik Svensen – Blog about Power BI, Power Apps, Power Query

The open data in Denmark has started to evolve – and now a public marketplace of data and apps is available as well via –

One of the apps in the App market is actually very nice and can then be used in Excel to wash/check your master about Danish companies. The app is a mirror of data from The Central Business Register – and can be accessed via, and is not associated with

Using the new Excel functions WEBSERVICE and FILTERXML can then be used to lookup values via the API.

First I found a list of all the companies in Denmark where the name Microsoft was included.

A simple search via the API – for the first VAT number gives me the result but also the syntax to call the API –

The documentation reveals that the result can be returned either as…

Ursprünglichen Post anzeigen 160 weitere Wörter






Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

Du kommentierst mit deinem Abmelden /  Ändern )


Du kommentierst mit deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s

Diese Seite verwendet Akismet, um Spam zu reduzieren. Erfahre, wie deine Kommentardaten verarbeitet werden..

%d Bloggern gefällt das: