The charity register should not need an FOI request and a database
You need charities by activity, income or area in a spreadsheet. The register export stops at 10,000 rows, while the complete download arrives as linked tables intended for database work.
Preview charities by activity, income and area See the Charity Commission dataset
What is happening
Freedom of information requests on the public record ask for a CSV or Excel file of registered charities. Sector tooling and guides exist specifically to convert and join the official extract.
The official routes are legitimate, but neither route is the missing middle: a complete filtered slice as one flat file. The difficulty is in the shape of the product, not in your spreadsheet skills.
What it disrupts
- A list by income, activity or postcode becomes a conversion, import and table-joining project.
- The 10,000-row web export can stop before a broad query is complete.
- Teams either narrow the question to fit the interface or rely on a third-party aggregator before analysis can begin.
Why it happens
- The public register is designed for lookup and capped exports.
- The complete extract preserves relational tables rather than flattening the fields a spreadsheet user commonly needs.
- England and Wales, Scotland and Northern Ireland maintain separate charity registers, so an honest national scope must be explicit.
Checks to make now
- Confirm that the Charity Commission for England and Wales is the register you need.
- Choose registered status, charity type, activity wording, postcode area and income range before exporting.
- Treat the latest reported finances as filed register data, not real-time accounts.
Where DataScoop fits
DataScoop ingests and flattens the official England and Wales extract. The current catalogue contains 398,054 records and was last imported on 2026-08-25.
Filter by registration status, charity type, activity text, postcode area, income range, registration date or reporting status. Preview 25 rows free and download the full matching CSV for £4.99.
Where it fits, and where it does not
Good fit
- Researchers, suppliers, funders and analysts who need organisation-level register facts in one table.
- Repeat queries through CSV, REST API or MCP where the official filing dates and scope are acceptable.
Not the right fit
- A single list of every charity across all four UK nations; DataScoop currently carries England and Wales only.
- Trustee, fundraiser or personal contact lists, or real-time financial performance.
Proof and boundaries
This is the Charity Commission register for England and Wales, not a UK-wide charity register. OSCR and CCNI are not currently ingested.
Trustee names and the register's contact email and phone fields are deliberately not ingested. The output contains organisational register data.
Financial values carry the filing lag of the official register. Dates remain visible so users can judge their suitability.
There is no customer outcome claim yet. The mechanism is inspectable through the free preview, filter schema, import date and official attribution.
Questions people ask
Is this every charity in the UK?
No. It covers the Charity Commission register for England and Wales. Scotland and Northern Ireland maintain separate registers that DataScoop does not currently carry.
Can I get trustee or fundraising-manager contacts?
No. DataScoop serves organisational fields such as charity name, number, type, status, income, expenditure, activities, postcode and website. It does not ingest trustee names or personal contact lists.
How fresh are the financial figures?
They are as current as the latest accounts filed on the register, which can lag the present by many months. The relevant dates remain in the output.
Can I repeat the same query later?
Yes through the API or MCP, or by returning to the explorer and applying the same filters. Saved filters and scheduled monitoring are not currently built.
Get the register slice you actually need
Set the activity, area and income filters, then inspect 25 rows free before downloading the full file.
Preview charities by activity, income and area