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

Описание и применение

Используя готовый Actor Apify, можно быстро получить данные о компаниях в Великобритании из публичного API Companies House и экспортировать их в таблицу без написания кода.

Задача

Need a list of UK companies with detailed data but the official API requires a key, pagination and JSON handling.

Результат

The Actor returns comprehensive company records (number, name, status, type, dates, SIC codes, address, due dates, charges, insolvency flags, officers, filings) in seconds, which can be exported to a spreadsheet or Google Sheets.

Рабочий процесс

• Open the Apify Actor "Companies House Scraper" and click "Try for free".
• Enter search queries, max items, and optional flags such as includeOfficers, onlyActive, includeFilingHistory, incrementalMode.
• Run the Actor; it calls the Companies House API and returns JSON records.
• Export the run’s dataset to CSV or Excel, or use the Google Sheets integration to send rows directly to a sheet.
• Schedule the Actor for incremental runs if continuous monitoring is needed.

Доказательства

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.

Источник

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.

Источник

That run returned 5 companies in about 8 seconds.

Источник

Pricing is pay-per-event: $0.003 per run start, $0.008 per company, and $0.02 per enriched company (with officers/filings).

Источник