Every month or so the Charity Commission publishes a database with information on every registered charity in England. However, it is released as a series of BCP files, which are helpful if you’re using a Microsoft database, but require some work if you’re trying to access this information using other programs, such as Postgres or MYSQL. The NCVO published a guide to converting this data into CSV files, but their conversion method leaves a bit to be desired, as it does not find and correct all escape characters in the BCP files, which can cause problems for some databases, including Postgres. So I’ve decided to distribute the CSV files myself, and I’ll be keeping this page as up to date as possible, given the occasionally erratic release schedule and my own sometimes limited time.

Note that extract-proper-object, marked with an asterix, has been concatenated from extract-object, with the complete text of a charity’s object in a single row in a table.

For details on the data itself, please see this table from the Charity Commission. Do get in touch if you have any questions, comments or concerns about this data. This data is made available under the terms of the Open Government Licence 3.0.

Download all 15 tables as a single ZIP file

Download individual CSV files from the July 2017 data release:

extract-acct-submit

extract-aoo-ref

extract-ar-submit

extract-charity

extract-charity-aoo

extract-class

extract-class-ref

extract-financial

extract-main-charity

extract-name

extract-partb

extract-proper-object*

extract-registration

extract-remove-ref

extract-trustee