Do you need to look up UK company details and all you have is the company name?
Fast Data Science has developed a Google Sheets™ add-on (plugin) which finds UK company names in a string and puts company details from Companies House (the UK company registry) in the next columns.
Links from the video
To use the add-on, simply select the range of cells that contain the text you want to search, and then click on the add-on icon in the toolbar. The add-on will then scan the selected cells and put the Companies House IDs of any company names it finds in the next columns.
UK Company Details Google Sheets™ Plugin
The add-on is very lightweight and easy to use, and it can be a great way to save time in your business when you need to identify company names in a large amount of text.
UK Company Details only finds UK companies. Companies in other juristictions are not supported.
There is not a fixed limit in the UK Company Details Google Sheets™ plugin, but the tool may time out if you try to process more than 100 companies in a go.
If you need to get data on thousands of companies at the same time, the best approach is to batch them in groups of 100. If you need all UK companies then you can also download a single file from Companies House which has all data. Feel free to also talk to us about your requirements. If there is enough demand for this plugin then we can develop it further.
We have made a similar Google Sheets™ plugin for finding pharmaceutical drug names and information, the Drug name recogniser Google Sheets™ plugin for pharmaceutical drug names. This retrieves drug data from a number of sources.
What we can do for you
