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 Google Sheets file.
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:
|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.
You can also leave a comment on the Google sheet itself. This would be particularly useful if you spot a missing sort code, or an error with the sort codes presented.