Power Query

This tutorial describes, how to get GPS coordinates for places (addresses, cities, countries…) in Power Query.

Get the API key

You need a key from Google (or similar provider). Let´s see this:

It´s free in reasonable numbers of addresses.

You need table with info about place. Then add this custom column with syntax like this:

Json.Document(Web.Contents(“https://maps.googleapis.com/maps/api/geocode/json?key=YOUR_KEY_IS_HERE&address=” & [Place]))

Then drill it to lowest level:

If you go to the end, and possibly remove unnecessities, you have a result like this:

This tutorial describes, how to get GPS coordinates for places (addresses, cities, countries...) in Power Query.

You need a key from Google (or similar provider). Let´s see this:

It´s free in reasonable numbers of addresses.

You need table with info about place. Then add this custom column with syntax like this:

Json.Document(Web.Contents("https://maps.googleapis.com/maps/api/geocode/json?key=YOUR_KEY_IS_HERE&address=" & [Place]))

Then drill it to lowest level:

If you go to the end, and possibly remove unnecessities, you have a result like this: