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

说明与用途

使用 Apify 的预制 Actor，您可以快速从 Companies House 公共 API 拉取英国公司数据，并将其导出到电子表格，无需编写代码。

问题

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).

来源