UK Postcode Geocoder is a Google Sheets addon to convert UK postcodes into geographic information, including latitude/longitude coordinates, country, region and constituency.
You can install the addon to Google Sheets via the Google Chrome store.
Source code on Github.
How do I use it?
Select cells containing postcode data and click “Add-ons > UK Postcode Geocoder > Geocode selection” to convert the data into latitude/longitude.
Results will be displayed in a new sheet.
What do you mean by ‘UK postcodes’?
The application currently will only provide latitude and longitude coordinates for active (i.e. currently in use and no discontinued) UK postcodes according to the ONS’ Postcode Directory for November 2014 via postcodes.io: http://postcodes.io/about
Postcodes can be upper or lower case and contain no spaces or 1 space before the last 3 characters (see examples below). Other formatting is likely to return an error.
- wc1e 6bt
- SW4 0BY
Postcodes or zip codes from other countries will return a ‘not a valid postcode’ error.
Where is your data from?
This application uses UK postcode data under the Open Government Licence for public sector information.
The data is pulled from the postcodes.io API.