Logos in our worksheet look great, but if we have to take the time to source them all manually, the return on our investment starts to diminish fast.
Check out the list of companies in the gif above. We need to quickly insert each company’s logo next to its name before our big presentation, but who has time to search for each logo, copy the image result, and paste each individually?? Instead, we can import them all in one batch using the IMAGE function and a free logo API.
The API source format we’ll need is: https://logo.clearbit.com/[company name]/.com and to import each company’s logo using this API, we need to insert the corresponding company name inside the brackets within that URL, and then use the IMAGE function to import the logo from the API server into the cell.
First, we’ll select the cell we want our imported logo to appear in, and enter the IMAGE function into that cell. Now we’ll generate the API URL using the CONCAT function, which will combine each of the URL elements we need into one string. To accomplish this, we’ll enter the CONCAT function, enter the base of the URL in double quotes (“https://logo.clearbit.com/” ), select the company name, and then enter the last piece of the URL in double quotes (“.com”). Now we can enter the API URL for our first company and import its corresponding logo!
Here’s the best part - because we reference company name dynamically inside our API URL, we can just fill our formula down the column to quickly import the rest of our logos!! This is such a time saver!
