API to convert companies house data into excel

I'm looking for a developer who can create an application / integration between Excel, and the data from Companies House. They need to have knowledge of working with API’s but also the target program Excel which we want to import the data into.

The data coming in from Companies House will most likely be in JSON formatting (according to the Companies House developer information).

There is already an export of the most recent companies set up on companies house, however this only provides the address and company name. We need to include the director of this company too.