If you've ever needed a list of UK companies (suppliers to check, leads in a sector, or the directors behind a competitor), you've probably copied rows out of the Companies House website one at a time. The data is public and comes from a good official API, but that API needs a key, pagination and some JSON wrangling.
This guide shows how to get the same data into a spreadsheet without writing any code , using a ready-made Apify Actor that calls the official Companies House Public Data API for you.
Disclosure: I built the Actor used here. Everything it returns comes from Companies House's own API.
What you get
For each company:
company number, name, status (active/dissolved) and type (ltd, plc…)
incorporation and dissolution dates
SIC codes (industry)
registered address and postcode
next accounts and confirmation statement due dates
flags for charges and insolvency history
optionally: current and past officers (directors, secretaries) and the 25 most recent filings
Step 1: Open the Actor
Go to…