Guide
Get Companies House data into Excel
Two ways to do it: the free manual method, step by step, and a weekly feed if you need it regularly.
Updated 31 Oct 2026 · Source: Companies House public data API · Pay per result on Apify
Opens the actor on Apify. Pay per result; no Rowsift account needed. Apify's free plan includes monthly credit.
TL;DR
Quickest manual route
Use the free Companies House advanced search: filter by name, SIC code, location or incorporation date, then download the results and open the file in Excel. Free, and fine for a one-off.
If you need this every week
Run the Companies House actor on a weekly schedule and export the rows.
Set up the Companies House feed (opens Apify)Step by step
Open the Companies House actor on Apify.
Enter search terms (e.g. "bakery") or paste a column of company numbers from your spreadsheet.
Doing this every week? Schedule the feed once and it repeats these steps for you.
Schedule it on Apify (opens Apify)Tick officers or filing history if you need them.
Run it, then click Export and choose Excel (.xlsx) or CSV.
Optional: schedule it and download the latest dataset each week.
Real sample output
| Number | Company | Status | Type | Incorporated | SIC codes |
|---|---|---|---|---|---|
| 00445790 | TESCO PLC | active | plc | 27 Nov 1947 | 47110 |
| 09384423 | KFORD TYRES (GORNAL) LTD | active | ltd | 12 Jan 2015 | 45200 |
| 05888957 | TESCO AQUA (FINCO2) LIMITED | dissolved | ltd | 27 Jul 2006 | 70100 |
From a real test run of the actor. Full records have more fields.
Example input
{"searchQueries":["tesco"],"maxItems":5,"includeOfficers":true}Questions about this feed
Do I need an API key?
No. You can use your own free Companies House API key, or the actor's built-in access.
What formats can I export?
JSON, CSV, Excel, XML, RSS or HTML from the Apify dataset, plus the Apify API and integrations with Google Sheets, Zapier, Make and n8n.
How much does it cost?
$8.00 per 1,000 results ($0.008 each) plus $0.003 per run, as listed on the Apify actor page (checked 31 Oct 2026). Apify's free plan includes monthly credit, so a small test run costs nothing.
Where does the data come from?
From the Companies House public data API. The feed only collects publicly available data.
Related guides and feeds
Companies House company data feed
UK company profiles, status, SIC codes, registered office, optional officers and filing…
Software development
1,169 companies · last 7 days · updated 31 Oct 2026
IT consultancy
632 companies · last 7 days · updated 31 Oct 2026
Restaurants
166 companies · last 7 days · updated 31 Oct 2026
Property letting
1,178 companies · last 7 days · updated 31 Oct 2026
Property development
169 companies · last 7 days · updated 31 Oct 2026
Management consultancy
946 companies · last 7 days · updated 31 Oct 2026
Online retail
1,800 companies · last 7 days · updated 31 Oct 2026
Electrical installation
165 companies · last 7 days · updated 31 Oct 2026
Get this every week, without the copy-paste
Schedule the Companies House feed and get fresh rows as CSV, Excel or JSON.
- Same columns every run
- Schedule it on Apify
- Pay per result, no Rowsift account
Opens the actor on Apify. Pay per result; no Rowsift account needed. Apify's free plan includes monthly credit.
Company data from Companies House. Contains public sector information licensed under the Open Government Licence v3.0.