IMAGE function with a Brandfetch logo URL that contains the company’s domain, and the logo loads inside the cell and sorts and filters with its row like any other value. Because the URL is built from the domain, one formula can fill a whole column with logos, 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, and it works in any Google account with no add-on to install.
Insert a company logo in a cell
Get a client ID for free in the developer dashboard, then type this formula into a cell, replacingnike.com with the company’s domain:
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:ARRAYFORMULA in the first row, and every domain you add below gets its logo without copying anything:
Insert logos from a stock ticker
Portfolio trackers and watchlists usually list tickers rather than domains, and the Logo API takes those too. Putticker/ in front of the symbol, or isin/ in front of an ISIN, and the formula works the same way:
GOOGLEFINANCE, so a row can show the company’s logo next to its live price. Crypto symbols such as BTC work with crypto/, and the identifier reference lists every format.
Size the logo
IMAGE takes an optional mode as its second argument. The default mode 1 fits the image inside the cell and keeps its proportions, 2 stretches it to fill the cell, 3 shows it at its original size, and 4 uses a 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 using mode 3, then making the row tall enough to show it:
Choose the logo type and theme
Any Logo API parameter works inside the formula. The URL returns the square icon by default, so end the path with/logo for the full horizontal logo with the company name, 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, Google Sheets can place a picture inside a cell without a formula. Select the cell, go to Insert > Image > Insert image in cell, and upload the file, and the picture then sits in the cell and sorts and filters with its row, the same way anIMAGE result does. Insert image over cells places it as a floating picture instead, which suits a header logo that shouldn’t move with the data.
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 are now empty. 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
https://logo.clearbit.com/"&A2) with https://cdn.brandfetch.io/"&A2&"?c=BRANDFETCH_CLIENT_ID"), adjusting the cell reference if your domains are in another column.
Add brand colors and company data
IMAGE can only embed images. The rest of a brand’s identity, its color palette, fonts, and company info, comes from the Brand API, which returns JSON and needs an Authorization header that no spreadsheet formula can send, so a small Apps Script custom function fills the gap.
You’ll need a Brand API key from the API keys page, which is a secret key and separate from the client ID used above. Open Extensions > Apps Script, paste the function below, and save:
Code.gs
IMAGE logo column:
FAQ
How do I add company logos in Google Sheets?
How do I add company logos in Google Sheets?
Type
=IMAGE("https://cdn.brandfetch.io/nike.com?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. For a list of companies, build the URL from the cell that holds each domain, or use ARRAYFORMULA to fill the whole column from one formula.How do I insert an image into a cell in Google Sheets?
How do I insert an image into a cell in Google Sheets?
Either use the
IMAGE function with the image’s URL, or select the cell and go to Insert > Image > Insert image in cell to upload a file. Both keep the picture inside the cell, so it sorts and filters with its row.Can I show a company logo from a stock ticker?
Can I show a company logo from a stock ticker?
Yes. Use
https://cdn.brandfetch.io/ticker/NKE?c=BRANDFETCH_CLIENT_ID in the IMAGE formula, replacing NKE with the ticker or a cell reference, as shown in Insert logos from a stock ticker. ISINs work the same way with isin/.Why is my IMAGE formula showing an empty cell?
Why is my IMAGE formula showing an empty cell?
Sheets leaves the cell empty when it can’t load the image, which usually means the domain in the referenced cell has a typo or extra spaces, the client ID is missing from the URL, or the formula still points at
logo.clearbit.com, which no longer works. Adding fallback/lettermark to the URL shows a lettermark for companies that have no logo.My Clearbit logos stopped working in Google Sheets. How do I fix them?
My Clearbit logos stopped working in Google Sheets. How do I fix them?
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 ?c=BRANDFETCH_CLIENT_ID after the domain, and use Find and replace with Also search within formulas to change every formula at once, as shown in Replace a Clearbit logo formula.Do I need an add-on to show logos in Google Sheets?
Do I need an add-on to show logos in Google Sheets?
No.
IMAGE is built into Google Sheets and loads the Brandfetch URL directly. You only need Apps Script for brand colors, fonts, and company data, as shown in Add brand colors and company data.How do I add company logos in Excel?
How do I add company logos in Excel?
Excel for Microsoft 365 has the same
IMAGE function, with a few differences in sizing and image formats. See Microsoft Excel for the formulas.