7 January 2013

First client

31 December 2019

Last software update

< 2 hours

Support response

StatementReader is used by forensic accountants, bookkeepers, insolvency investigators, solicitors, auditors and business review professionals to stop wasting time and talent converting bank statements into Excel

This website uses cookies to enhance the user experience.  Click here for our cookie statement and here for our privacy policy.

All Rights Reserved 2012-2020 Suave Software Limited. London, England, United Kingdom. Email Us

  • LinkedIn Social Icon
  • Twitter Social Icon

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

#Formula #Excel #All