Download UK Postcodes with Latitude and Longitude

Download a list of UK out code postcodes with their latitude and longitude coordinates.

Introduction

Example Postcode List

The UK postal system uses postcodes to help with automating the sorting and delivery of mail. This is made up of a 2-part code, an out code and an in code. As the out code is the most significant part of the system, it can be used to obtain a rough area level break up of the UK. There are approximately 2971 out codes and approximately 1762460 full postcodes (out code + in code).

Purpose

The uses of these out codes and lat/long values include mapping applications such as:

List Status

Current List : 2973 Outcode Postcodes

Total Possible : 2971 Outcode Postcodes

Number of missing outcode postcodes : 0

Current List : 1703526 Postcodes

Non Geographic Postcodes

AB99, BT58, CA99, CM92, CM98, CR44, CR90, GIR, IM99, IV99, JE5, M61, ME99, N1C, N81, NR99, NW26, PA80, PE99, RH77, SL60, SO97, SW95, SY99, WD99, WF90

Downloads

Outcode Area

Full UK Postcode Latitude Longitude Download

Contains Ordnance Survey data © Crown copyright and database right 2013

Contains Royal Mail data © Royal Mail copyright and database right 2013

Contains National Statistics data © Crown copyright and database right 2013

Relevant Links

Version History

Previous Comments For This Page

Julie Montoya - T-SQL is the most common! MySQL is not as popular/common.
By TheMan on 11/08/2014

Wouldn't it have been more sensible to use MySQL, which is what just about everybody else on the entire Internet uses? Or at least supply a sed script to convert it to MySQL .....
By Julie Montoya on 17/07/2014

Its Transact-SQL
By Free Map Tools on 15/07/2014

What weirdy SQL dialect is that supposed to be? It made MySQL barf .....
By Julie Montoya on 15/07/2014

Good Job Mate!
By Dileep on 09/07/2014

Fantastically useful resource - thanks very much!
On 18/06/2014

projection ... TBH, we are not sure. It looks like Spherical Mercator but we are not 100%
By Free Map Tools on 30/05/2014

What is the projection used on this? I would like to bring it into a spatial databse but need to be able to get the correct projection to acturatly use this data
On 29/05/2014

Very good site for map
By Guddu yadav on 01/05/2014

Hi Andy, I can see the EC1, EC2 .... postcodes inside the CSV and SQL files.
By Free Map Tools on 21/04/2014

Hi, can't see any EC1, 2, 3, 4 postcodes?
By andy on 17/04/2014

Hi Tony, As far as we are aware, they are all active ... no doubt there are a handful of errors inside, but the majority are active. Out of interest, where are you seeing the [terminated date] mentioned?
By Free Map Tools on 20/03/2014

This is so useful, however the size of the csv file is so large that I can't open it in either Excel or Notepad . Since it looks like > 1/3 of the postcode records have been terminated (if I interpreted the fact that there is a terminated date correctly), would it be possible to have a version of the download that just included active postcodes? That would save download/import times for many people I would imagine.
By Tony Payne on 20/03/2014

Just loading in the data now, I think this will be really useful. For others that are trying to use this on an MS SQL server and finding that it won't load because of the size you might find this helps: sqlcmd -S (server name) -i C:\(file name).sql -o Taken from this thread: http://stackoverflow.com/questions/431913/how-do-you-run-a-300mb-ms-sql-sql-file
On 17/02/2014

Thanks for reporting, these have been removed.
By Free Map Tools on 20/01/2014

Very useful, but it has an odd entry: 1699835,47,37.784963000000000,-122.418871000000000 What is that?
On 19/01/2014

Hi, There are more than 1.7M lines (postcodes) in the full CSV file and that number looks like the Excel limit so yes, I would assume Excel is unable to open the file in full and is cutting off rows.
By Free Map Tools on 07/01/2014

The CSV list I downloaded only goes upto 1,048,576 and misses all the C-G post codes. Is this because of excel having limited space?
By BennyHill on 07/01/2014

for christmas i want aiphone 5
On 06/12/2013

great job many many many thanks ;)
On 15/11/2013

Showing the most recent 20 out of 119 comments. Click to see all the comments.

Add your own comment below and let others know what you think:

Comments :

Your Name (optional) :

 Save