All the UK and Ireland Bank Sort Codes

As well as debating politics, human rights and free speech, this blog is also interested in spreadsheets. Regular readers may recall my triumphant post about UK Postcode Areas, or the deeply honest and uncompromising account of the Excel spreadsheet function VLOOKUP.

As part of my job I’ve recently had cause to look up the bank name and address for a given set of sort codes. To begin with, I simply Googled each sort code and then copied-and-pasted whatever information was revealed.

This is extremely tiresome, so I’ve made myself a spreadsheet. I scraped the web for the information, and have put it in a handy CSV file: sortcodes-uk-and-ireland.csv [1.2 MB].

The data includes sort code, bank name and branch. In many cases I did acquire the address information too, but I have chosen not to include it in the CSV file because it is so inconsistent: some banks do not supply physical address details, but a central customer service centre instead.

The data looks like this:

Sortcode Sortcode Sortcode Bank Name Branch
01-00-04 01 00 04 010004 NATIONAL WESTMINSTER BANK PLC ACCRINGTON
11-82-69 11 82 69 118269 HALIFAX ROCHDALE (HPS)
77-65-17 77 65 17 776517 LLOYDS TSB BANK PLC SWANSEA MUMBLES (T)
82-80-06 82 80 06 828006 BANK OF CHINA GLASGOW SAUCHIEHALL STREET

There are 18,097 separate sort codes (out of a possible one million-less one combinations).

I hope you find this list useful for your projects. If you do use this data, why not leave a comment below to tell us what you did with it.

Leave a Reply

Your email address will not be published. Required fields are marked *