Downloadable List of UK Towns, Cities and Counties

November 18th, 2012 - Posted by Steve Marks to Web Development.

Whilst recently working on a site that required a database of locations (all the towns, cities and counties) within the UK, I couldn’t find a list available in a downloadable format.

As a result, for others that find themselves in the same position, I’m making the list that I compiled available for download in CSV format and as an SQL file. I’ve included the links to these below:

Towns and Cities

Download CSV
Download SQL


Download CSV
Download SQL

This entry was posted on Sunday, November 18th, 2012 at 8:57 pm by +Steve Marks and is filed under Web Development. You can follow any responses to this entry through the RSS 2.0 feed.

Fear not, we won't publish this

Comments (15)
  1. Maksym says:

    Thank you so much! You saved us hours of work!

  2. wonderful! i have search it for a long time!

  3. Dane Lesip says:

    I also needed a database with geolocation data and town to county relationship but instead used Contains everything I needed

  4. Brilliant – thanks for this; you’ve just saved me a load of time.
    If you’ve an Amazon wishlist, email it me :)

  5. Stu Plough says:

    I was also working on a marketing project where I needed a list of towns in the UK. This list is great (thank you) but I needed a list which included geolocation and county data. Although not free, I ultimately used

  6. Phil K says:

    Thanks for this just what I needed.

  7. Thanks – its just what I need whilst converting a filemaker db to an access one

  8. Mark Rofe says:

    Thanks for this, saved me a lot of time!

  9. Paul says:

    Thank you for the town list.

    You can have a good day knowing you really helped someone out.

    Thanks again.

  10. Thank you so much for publishing this. You have saved me a great deal of time, and it’s very much appreciated.

    Good karma coming your way ;-)

  11. Palani Balasundaram says:

    Thanks Steve & Biostall. I am working on an analysis. I was able to get the list of cities, but this file is very much helpful.
    Post my analysis i will share my excel file containing the cities list and it can be shared too.


  12. Andrew says:

    Thank you, good soul :-)

  13. Grant says:


    This list doesn’t seem to include London.

    However, very useful, thankyou!

  14. Ken says:

    Just what I’d been looking for. You saved me a lot of work.
    Thank you very much