Hi everyone,
Need your help, please.
So I´ve got a spreadsheet with several companies’ names and I´ll need to find their companies’ number.
creating an API that automatically searches from my list and then retrieves companies number is the solution?
already tried with python, but seems that the code isn´t correct 
Cheers
Sara
Welcome - thanks for stating your overall goal:
I´ve got a spreadsheet with several companies’ names and I´ll need to find their companies’ number.
If you’re having trouble with code and want to stay in the spreadsheet you could download the bulk Companies House data files and process those to get company names from numbers.
Alternatively, search this forum, you’ll find other people wanting to accomplish the same goal e.g. on this thread:
I believe there are some spreadsheet-based tools / plugins for Companies House. I don’t have details though, sorry - try search.
If neither of those approaches helps, you’ll need to explain the detail. So that would be:
What it is you’re doing e.g. what system / what code you’re using (simplified if possible)
What part of Companies House API you’re accessing
The data you send
The errors / data you get back.
Don’t put any of your API key details / passwords in your post though!
Good luck.
Sara
You might find this link helpful
GitHub - previsedigital/companies_house: Companies’ House API
or
Search · companies house · GitHub
I can’T vouch for any of the material but most of what reaches Github does work!
If you would prefer not reinvent existing wheels you could also reach out to my team at
StatBooks® puts the Companies House Register at your fingertips! We have a Names & Numbers API that auto populates Names from Numbers.