how we can get companies house data through API into excel spreadsheet

I am reaching out to you to see how we can get companies house data through API into excel spreadsheet.
What we are looking to do is to download all or specific fields of companies house data into excel through excel get data from web functionality.

Many thanks

Welcome.

It depends what exactly you want to do. Lots of people seem to want “the data” and mean “all the data”. In that case the task could be much simpler - just visit the Companies House Data Products page and you can download the data for all companies in an Excel-readable format.

Caveats - this is updated monthly. It also doesn’t have all the more structured data (e.g. officers, PSCs, charges, insolvency record details) that the API provides.

If you want to use the API then you can’t just get “all the data” (for all companies). The API is rate-limited. Your choices are:

  • If you only need to look up a small subset of companies then just using the API should work for you,
  • If you still want “all the data” then you’ll still need to download and process the Bulk Data - you can then try and keep it up to date using e.g. the Streaming API or accept that it may be “up to date” once a month (when you download the new companies data).

You can search this forum using the magnifying glass icon at top right. If you do that you will find plenty of questions and answers on Excel and Companies House. Here are 3 which might be useful:

Good luck.

Yes, I have already done it, you need to use power query.

It took a while to get it working, but the issues you have is you need to create another power query for example Significant People, etc.

Still working on it, but at this time I can download all the fields in the api to excel, then choose which fields I need.

Good luck, was scratching my head for a long time trying to get it fully working.

Just working on the Dissolve companies API atm.