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

API Question
1

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

2

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.