Using OpenRefine to geocode your data using Google and OpenStreetMap API (opens in new tab)

In this article we will see how to use OpenRefine to enrich our datasets with data from any web service available on line. We will learn how to use Google and OpenStreetMaps web service to geocode the addresses of a dataset.

In the previous article we saw how to take our comma-separated list of google contacts, and play with them using google refine. We learnt how to do things like filtering, faceting, normalizing data, removing duplicate rows and other pretty common tasks. Now we are going to take their addresses and prepare our dataset to show them on a map.