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 (download.companieshouse.gov.uk/en_output.html).
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: http://www.howtogeek.com/howto/13780/using-vlookup-in-excel
Recent PostsSee All
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