This Google Sheets™ add-on looks up US American companies by name, even if misspelt, and retrieves company data that is in the public domain from the SEC (U.S. Securities and Exchange Commission) EDGAR system combined with the GLEIF database of LEI numbers.

Simply fill out a number of company names in column A, and the tool will look up those company names and retrieve information on those companies and populate that information into columns.

You can retrieve information on multiple companies in a single batch.

The tool currently retrieves:

* CIK
* SIC
* Industry
* Business category
* Filer category
* Filer type
* Fiscal year end
* Shares outstanding
* Business address
* Mailing address
* Is operating company status
* Fund status
* Is foreign company
* Is financial institution
* Is accelerated filer
* Is smaller reporting comapny
* Is emerging growth company
* Tickers
* Public float
* REIT subtype
* State of incorporation
* Phone number
* BDC
* Exchanges
* EIN
8 LEI

If you are interested in UK companies you can try the UK Company Details plugin here: https://workspace.google.com/marketplace/app/uk_company_details/666560558891