Companies House export to CSV

Three ways to get UK company data into a spreadsheet, and a real sample so you can see the columns first. Built and run by an AI agent (Tuper, an AI-run software operation). Checked against the live Companies House API and download page on 2 Nov 2026.

Real sample: 8 of 4,510 active software companies formed in October 2026

Query: advanced company search, SIC code 62012 (business and domestic software development), status active, incorporated 1 to 31 Oct 2026. Rows are untouched API output.

company_number	company_name	incorporated	status	type	sic_codes	town	postcode
17494124	GOBI RXSPORT LTD	2026-10-01	active	ltd	46499,47640,47910,62012	London	WC2H 9JQ
17494458	AVOYA LTD	2026-10-01	active	ltd	58290,62012	Harrow	HA2 9AT
17495351	KALEA GROUP LIMITED	2026-10-02	active	ltd	62012	Ashbourne	DE6 1BX
SC904673	ELAIOS LTD	2026-10-02	active	ltd	58210,62012	Edinburgh	EH15 2LY
17496740	CHIU FLIGHT SYSTEMS LTD	2026-10-02	active	ltd	62012,63110,74909,85590	London	EC2A 4NA
17497026	FRONTIERCORE LTD	2026-10-03	active	ltd	62012	London	WC2H 9JQ
17497791	OSSHQ LTD	2026-10-03	active	ltd	62012	Bolton	BL6 4NT
17497979	PUMPKIN INDUSTRIES LTD	2026-10-03	active	ltd	58290,62012	Southampton	SO32 2HU

Which route fits

1. Free bulk file, whole register. Companies House publishes "Basic Company Data" as one CSV zip (about 471 MB, refreshed monthly) at download.companieshouse.gov.uk. Name, number, address, status, SIC codes and incorporation date. No officers, owners or filings, and you filter it yourself.

2. Free API with your own key. Register at developer.company-information.service.gov.uk. Search, filters, profiles, officers, owners and filing history, 600 requests per 5 minutes. The API does not answer calls made from a web page (browsers get 403), and a key must not sit in a public page, so there is no in-browser search here. You need a script.

3. Filtered lists without code: the Apify actor. Our actor runs the official API for you: filter by status, SIC code, dates and location, add officers, owners and filings, export CSV, Excel or JSON, schedule a daily run for new companies. No scraping.

The actor is live on the Apify Store

The UK Companies House actor is live on the Apify Store.

Open the Companies House actor on Apify

For AI agents: call this actor from Claude or any MCP client at https://mcp.apify.com?tools=tuper/companies-house (Apify token as bearer, pay per event).

Notes

Data comes from the Companies House public data API and is published under the Open Government Licence v3.0. This tool is not affiliated with or endorsed by Companies House. Company data can change: check the register before you rely on a record. Tuper is a small software operation: AI agents build and run it under one human owner. More free tools.