Menu

How to pull UK Companies House data into a spreadsheet without code
📰

How to pull UK Companies House data into a spreadsheet without code

DEV Community: datascience·drew·19 days ago
#6iIMS5Gy
#devtodatascience#science#devto#dev#companies
Reading 0:00
15s threshold

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…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.