Skip to main content
Show company logos in Excel with the IMAGE function and a Logo.dev CDN URL. Excel 2019 and earlier have no IMAGE function, so on those versions you insert each logo as a picture.

Get your API keys

Your dashboard has a publishable key for the Logo.dev CDN and a secret key for the Logo.dev API. Every plan includes both.

​
Add a logo with the IMAGE function

Put a CDN URL in IMAGE, and replace LOGO_DEV_PUBLISHABLE_KEY with your publishable key:
If column A holds brand names instead of domains, encode the cell so spaces and special characters survive. See name lookup. ENCODEURL() works only in Excel for Windows. Excel for the web and Excel for Mac do not have it, so use the SUBSTITUTE() formula there. It encodes spaces and the characters that change a URL: #, &, /, \, ?, and +. It encodes % first, so that it does not encode the % signs from the other substitutions again. For example, #1 Cochran becomes %231%20Cochran, and AT&T becomes AT%26T. To fill a column, drag the formula down. To change the size, format, or theme, add CDN parameters to the URL.

​
Replace Clearbit logo formulas

If your spreadsheet used the Clearbit Logo API (logo.clearbit.com), which has shut down, change the base URL to img.logo.dev and add your token:
To change every formula at once, use Find and replace to change logo.clearbit.com to img.logo.dev. Then add ?token=LOGO_DEV_PUBLISHABLE_KEY after the domain. The Clearbit migration guide covers the rest.

​
Insert a logo as a picture

Use this method in Excel 2019 and earlier, or for a logo that floats over the grid. Excel saves a copy of the image in the workbook, and that copy does not update when the brand changes its logo. If you need logo files to keep, get them from the Logo.dev API.
1

Open the picture dialog

On Windows, click Insert > Pictures. In newer versions, then click This Device.
2

Paste the CDN URL

In the File name box, paste the URL instead of choosing a local file:
3

Insert the logo

Click Insert. Excel downloads the logo and places it on the sheet.
A header or footer logo shows on every printed page and PDF export.
1

Open the header

Click Insert > Header & Footer, then click the left, center, or right section of the header.
2

Insert the picture

On the Header & Footer tab, click Picture. Paste the CDN URL in the file dialog, as in Insert a logo as a picture.

​
Keep logos with their rows

A picture does not move with its row by default. To keep each logo next to its data when you sort or filter:
1

Open the picture properties

Right-click the logo, then click Size and Properties.
2

Lock it to the cell

Under Properties, click Move and size with cells.

​
Add logos in bulk with a macro

This VBA macro writes an IMAGE formula next to each selected domain. It needs an Excel version with the IMAGE function.
Select the cells that hold domains, then run the macro.