top of page

How can I search Companies House data for many companies?

If you have a list of many company names (perhaps creditors or debtors) and you need to check which ones are dissolved or subject to Liquidation/Administration proceedings then you should use Companies House public data (

By downloading and uncompressing the zip files provided you will be able to open the data in Excel. Then you can use a VLOOKUP formula on the company name to obtain the company status for each company in your original list.

Here is a guide to using a VLOOKUP formula:

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page