Skip to main content
To insert a company logo in an Excel cell, use the IMAGE function with a Brandfetch logo URL that contains the company’s domain, and the logo loads inside the cell and moves, sorts, and filters with its row like any other value. Because the URL is built from the domain, one formula filled down a column shows a logo for every company in your list, which makes it a quick way to add logos to a customer list, a portfolio tracker, or a competitor table without finding and pasting each image.
IMAGE is available in Excel for Microsoft 365 on Windows, Mac, the web, and mobile, and in Excel 2024, but not in older versions such as Excel 2019 or 2021. In those versions, use the macro further down.

Insert a company logo in a cell

Get a client ID for free in the developer dashboard, then type this formula into a cell, replacing nike.com with the company’s domain:
The URL asks for icon.png because Excel for the web and Excel for Android don’t display WebP images, which is the format Brandfetch serves by default, while PNG works in every version of Excel and keeps the logo’s transparent background.

Insert logos for a whole column

Most sheets already have the domains in a column, so build the URL from the cell instead of typing each domain, and fill the formula down:
Inside an Excel Table, use a structured reference to the domain column, and the formula fills the whole column by itself, including rows you add later:
Outside a Table, drag the fill handle down the column, or select the range and press Ctrl+D. IMAGE takes an optional alt text as its second argument, followed by sizing, height, and width. The default sizing of 0 fits the image inside the cell and keeps its proportions, 1 stretches it to fill the cell, 2 keeps the image’s original size, and 3 uses the height and width you give in pixels. The most predictable result comes from requesting the size you need in the URL with the Logo API’s w and h segments and leaving sizing at 0, then making the row tall enough to show it:

Choose the logo type and theme

Any Logo API parameter works inside the formula. End the path with /logo for the full horizontal logo with the company name instead of the square icon, add theme/dark or theme/light to match your sheet’s colors, and add fallback/lettermark so a company without a logo gets a lettermark instead of an empty cell:

Insert a picture in a cell without a formula

For a single image, such as your own company’s logo saved on your computer, Microsoft 365 can place a picture inside a cell without a formula. Select the cell, go to Insert > Pictures > Place in Cell, and pick the file, and the picture then sits in the cell and sorts and filters with its row, the same way an IMAGE result does. A picture that already floats over the sheet can be moved into its cell by right-clicking it and choosing Place in Cell.

Replace a Clearbit logo formula

Many spreadsheets were built with =IMAGE("https://logo.clearbit.com/"&A2), which stopped working when Clearbit’s Logo API shut down in December 2025, so those cells now show an error or nothing at all. Brandfetch takes the same domain in the same place, so the fix is to replace the start of the URL and add your client ID at the end: Clearbit
Brandfetch
To change every formula at once, use Find and Replace (Ctrl+H) with Look in set to Formulas. Replace https://logo.clearbit.com/"&A2) with https://cdn.brandfetch.io/"&A2&"/icon.png?c=BRANDFETCH_CLIENT_ID"), adjusting the cell reference if your domains are in another column.

Insert logos as static pictures

IMAGE results stay live, which means they load over the network each time the workbook opens and don’t show offline. To save logos into the file as regular pictures, use this macro, which reads domains from column A and places a logo in column B for each row, sized to the row’s height.
The macro needs a current Microsoft 365 desktop build, because older versions of Excel can’t fetch a URL in AddPicture and raise error 1004 (“The specified file was not found”).
Insert Logos From Column
Open the VBA editor with Alt+F11 (Windows) or Fn+Option+F11 (Mac), paste the macro into a new module (Insert > Module), then run it with F5. Save the workbook as Excel Macro-Enabled Workbook (.xlsm) to keep the macro for next time.

Add brand colors and company data

IMAGE only shows images, so a brand’s colors, fonts, and company information come from the Brand API instead, which returns JSON and needs an Authorization header that Power Query can send for you. You need a Brand API key from the API keys page, which is a secret key separate from the client ID in the logo URLs.
1

Connect to the Brand API

Go to Data > Get Data > From Other Sources > From Web and switch to Advanced. Enter https://api.brandfetch.io/v2/brands/domain/nike.com as the URL, and under HTTP request header parameters add Authorization with the value Bearer YOUR_BRAND_API_KEY.If Excel asks how to connect to the source, pick Anonymous, since the header already handles authentication.
2

Pick out the fields you need

The Power Query editor opens the response as a record. Drill into the parts you want, for example click the List next to colors, choose To Table, then expand the records into hex and type columns.
3

Load it into the sheet

Click Close & Load to land the result as a worksheet table. Data > Refresh All re-fetches it whenever you need current data; each refresh counts against your Brand API plan’s quota.
The API key is saved inside the query, where anyone who gets the workbook can read it in the Power Query editor, so share a PDF or a values-only copy rather than the workbook itself.

FAQ

Type =IMAGE("https://cdn.brandfetch.io/nike.com/icon.png?c=BRANDFETCH_CLIENT_ID") into a cell, replacing nike.com with the company’s domain and the last part with your free client ID, and the logo appears inside the cell. To show logos for a list of companies, build the URL from the cell that holds each domain and fill the formula down the column.
In Microsoft 365, either use the IMAGE function with the image’s URL, or select the cell and go to Insert > Pictures > Place in Cell to place a file from your computer. Both keep the picture inside the cell, so it moves, sorts, and filters with its row.
#VALUE! usually means the image format isn’t supported where you’re viewing the sheet, which is the case for WebP in Excel for the web and Android, so add /icon.png to the URL. For a domain Brandfetch doesn’t know, the default placeholder is still served as WebP whatever the extension, so add /fallback/lettermark before /icon.png to get a PNG lettermark instead. #CONNECT! means Excel couldn’t reach the URL, so check your connection and that the domain in the cell has no spaces. #BLOCKED! means Excel’s security settings block linked images, which in a company is usually a policy your IT admin controls.
Clearbit’s Logo API shut down in December 2025, so every logo.clearbit.com formula now fails. Replace the start of the URL with https://cdn.brandfetch.io/, add /icon.png?c=BRANDFETCH_CLIENT_ID after the domain, and use Find and Replace to change every formula at once, as shown in Replace a Clearbit logo formula.
No, IMAGE needs Excel for Microsoft 365 or Excel 2024. In Excel 2019 or 2021, insert logos as pictures with the macro above, or download each logo and use Insert > Pictures.
Google Sheets has the same IMAGE function, so the same Brandfetch URL works there, and ARRAYFORMULA can fill a whole column from one cell. See Google Sheets for the formulas.