Skip to main content
Display company logos in Google Sheets using Logo.dev’s API. Automatically enrich spreadsheets with logos for CRM data, company lists, competitor analysis, and investor tracking. Works instantly with the IMAGE formula—no apps or extensions required.
Get your API key from the Logo.dev dashboard to get started.

Basic formula

Use Google Sheets’ IMAGE function to display logos from company domains:
=IMAGE("https://img.logo.dev/apple.com?token=YOUR_API_KEY")
Replace YOUR_API_KEY with your publishable key from the dashboard. The basic formula uses a hardcoded domain, while the cell reference formula pulls domains from cells dynamically. Use ARRAYFORMULA to apply logos to entire columns at once.

Customize logo appearance

Customize logo appearance with URL parameters:
=IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=YOUR_API_KEY&format=png&size=256"))

Control image sizing in cells

Google Sheets’ IMAGE function supports sizing modes:
=IMAGE("https://img.logo.dev/google.com?token=YOUR_API_KEY", 1)

Bulk logo retrieval with ARRAYFORMULA

Apply the logo formula to entire columns using ARRAYFORMULA:
=ARRAYFORMULA(IF(A2:A="",,IMAGE("https://img.logo.dev/"&A2:A&"?token=YOUR_API_KEY&format=png&size=128")))
This formula:
  • Checks if cells in column A are empty
  • If not empty, generates a logo from the domain
  • Applies to all rows automatically as you add data

FAQs

Yes. The IMAGE function and Logo.dev API work in Google Sheets on mobile (iOS and Android). Logos will load automatically when you have an internet connection.
Yes. You can fetch logos programmatically using Google Apps Script with UrlFetchApp to call the Logo.dev API, then insert images into your sheet.
Use ARRAYFORMULA with the IMAGE function to apply logos to entire columns. See the “Bulk logo retrieval” section above for the formula.
Yes. Anyone who opens the shared Google Sheet will see the logos, even if they don’t have a Logo.dev account. The API key in the formula handles authentication.
No. The IMAGE function is specific to Google Sheets. For Google Docs or Slides, you’ll need to download logos first using the Logo.dev URL, then insert them manually.
Logo.dev returns generated monograms for companies without logos. To check if a real logo exists, use the Brand Search API to verify coverage before inserting.
PNG format is recommended for best quality and compatibility. Google Sheets handles PNG well. Use format=png in your Logo.dev URL.
Yes. Google Sheets treats images in cells normally, so you can filter and sort rows that contain logos. Use “Move and size with cells” if inserting images as overlays.
Use Logo.dev’s Brand Search API with the company name as a query parameter. This returns logos based on company name matching instead of domains.
Yes. Each plan has defined usage limits. Free accounts include 1,000 requests per month. Google Sheets may cache images, reducing repeated API calls. See pricing for higher limits.
Yes. Add theme=dark to your Logo.dev URL to get logos optimized for dark backgrounds. This is useful if your sheet has a dark theme.
Google Sheets doesn’t support clickable images directly. However, you can add a separate column with HYPERLINK formulas pointing to company websites.