> ## Documentation Index
> Fetch the complete documentation index at: https://www.logo.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Add company logos in Microsoft Excel

> Display company logos in Excel using Logo.dev. The IMAGE function works in Microsoft 365, Excel 2024, and Online; Excel 2019 and earlier insert logos as web pictures.

Logo.dev's image API puts a company logo in any Excel cell. In Excel for Microsoft 365, Excel 2024, and Excel Online, the `IMAGE` function fills customer lists, vendor databases, and reports from one formula. Excel 2019 and earlier don't have the `IMAGE` function, so on those versions you insert logos as web pictures instead.

<Note>
  Get your publishable key from the [Logo.dev
  dashboard](https://www.logo.dev/dashboard/api-keys) to get started.
</Note>

## Basic formula

Use Excel's `IMAGE` function to display logos from company domains:

<CodeGroup>
  ```excel Basic formula theme={null}
  =IMAGE("https://img.logo.dev/microsoft.com?token=LOGO_DEV_PUBLISHABLE_KEY")
  ```

  ```excel With cell reference theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&format=png"))
  ```

  ```excel Advanced with parameters theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&format=png&size=128&greyscale=true"))
  ```

  ```excel By brand name theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/name/", ENCODEURL(A2), "?token=LOGO_DEV_PUBLISHABLE_KEY"))
  ```
</CodeGroup>

Replace `LOGO_DEV_PUBLISHABLE_KEY` with your publishable key from the dashboard.

The basic formula uses a hardcoded domain. The cell reference formula pulls the domain from cell A2 dynamically.

<Note>
  When looking up logos by brand name, use `ENCODEURL()` to properly format
  brand names with spaces or special characters. See the [name lookup
  documentation](/docs/logo-images/name) for details.
</Note>

## Replace Clearbit logo formulas

If your spreadsheet used the Clearbit Logo API (`logo.clearbit.com`), which [shut down on December 8, 2025](/docs/migrations/clearbit), swap the base URL for `img.logo.dev` and add your token:

<CodeGroup>
  ```excel Before (Clearbit) theme={null}
  =IMAGE(CONCAT("https://logo.clearbit.com/", A2))
  ```

  ```excel After (Logo.dev) theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY"))
  ```
</CodeGroup>

Use your spreadsheet's **Find & Replace** (Ctrl+H, or Cmd+Shift+H on Mac) to change `logo.clearbit.com` to `img.logo.dev` across every formula at once, then append `?token=LOGO_DEV_PUBLISHABLE_KEY`. See the full [Clearbit migration guide](/docs/migrations/clearbit) for details.

## Insert logos from web URL

For Excel versions without the IMAGE function, insert logos directly from the web:

<Steps>
  <Step title="Open Insert Pictures dialog">
    Click **Insert** > **Pictures** > **Online Pictures** (or **From Web** in
    newer versions)
  </Step>

  <Step title="Paste Logo.dev URL">
    Paste the Logo.dev URL with your API key:

    ```
    https://img.logo.dev/stripe.com?token=LOGO_DEV_PUBLISHABLE_KEY&format=png&size=256
    ```
  </Step>

  <Step title="Insert the logo">
    Press Enter to insert the logo into your spreadsheet
  </Step>
</Steps>

This method works in Excel 2019 and earlier, including Excel 2016 and 2013.

## Add logos to Excel headers and footers

Add your company logo to headers or footers for branded reports:

<Steps>
  <Step title="Open Header & Footer view">
    Go to **Insert** > **Header & Footer**
  </Step>

  <Step title="Select header section">
    Click the header section where you want the logo (left, center, or right)
  </Step>

  <Step title="Insert picture from web">
    In the **Header & Footer Tools Design** tab, click **Picture** > **Online
    Pictures**
  </Step>

  <Step title="Add Logo.dev URL">
    Paste your Logo.dev URL:

    {""}

    ```
    https://img.logo.dev/yourcompany.com?token=LOGO_DEV_PUBLISHABLE_KEY&format=png&size=128
    ```
  </Step>
</Steps>

## Customize logo appearance

Customize logo size, format, and effects using URL parameters:

<CodeGroup>
  ```excel PNG logo with size theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&format=png&size=256"))
  ```

  ```excel Greyscale logo theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&greyscale=true"))
  ```

  ```excel Dark mode optimized theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&theme=dark"))
  ```

  ```excel Combined parameters theme={null}
  =IMAGE(CONCAT("https://img.logo.dev/", A2, "?token=LOGO_DEV_PUBLISHABLE_KEY&format=png&size=128&greyscale=true"))
  ```
</CodeGroup>

## Excel version compatibility

| Excel Version | IMAGE Function Support    |
| ------------- | ------------------------- |
| Microsoft 365 | ✓ Full support            |
| Excel 2024    | ✓ Full support            |
| Excel Online  | ✓ Full support            |
| Excel 2019    | ✗ Insert as a web picture |
| Excel 2016    | ✗ Insert as a web picture |
| Excel 2013    | ✗ Insert as a web picture |

For older Excel versions, insert logos as pictures using the web URL method.

## Position and lock logos with cells

Keep logos aligned with your data when you sort, filter, and resize:

<Steps>
  <Step title="Select the logo">
    Right-click the logo image in your spreadsheet
  </Step>

  <Step title="Open properties">
    Select **Size & Properties** (or **Format Picture**)
  </Step>

  <Step title="Choose positioning behavior">
    Under the **Properties** tab, choose your preferred option:

    * **Move and size with cells** - Logo resizes when cell dimensions change
    * **Move but don't size with cells** - Logo maintains size but moves with the cell
    * **Don't move or size with cells** - Logo stays fixed in position
  </Step>
</Steps>

This keeps logos aligned with their corresponding rows when sorting or filtering data.

## VBA macro for bulk logos

For advanced users, use this VBA macro to add logos to multiple cells:

```vba theme={null}
Sub AddLogos()
    Dim cell As Range
    Dim apiKey As String

    apiKey = "LOGO_DEV_PUBLISHABLE_KEY"

    For Each cell In Selection
        If cell.Value <> "" Then
            cell.Offset(0, 1).Formula = "=IMAGE(""https://img.logo.dev/" & _
                cell.Value & "?token=" & apiKey & "&format=png"")"
        End If
    Next cell
End Sub
```

Select cells with domains and run the macro to populate adjacent cells with logos. Because it writes `IMAGE` formulas, the macro needs Excel for Microsoft 365, Excel 2024, or Excel Online.

## FAQs

<AccordionGroup>
  <Accordion title="Does the IMAGE function work in all Excel versions?">
    The IMAGE function is available in Excel for Microsoft 365, Excel 2024, and Excel Online. For Excel 2019 and earlier, use the manual picture insertion method via Insert > Pictures > Online Pictures.
  </Accordion>

  {" "}

  <Accordion title="Can I insert logos in Excel headers and footers?">
    Yes. Use Insert > Header & Footer, then click Picture to add logos from a
    Logo.dev URL. Headers and footers will appear on every printed page and PDF
    export.
  </Accordion>

  {" "}

  <Accordion title="How do I keep logos aligned when sorting data?">
    Right-click the logo, select Format Picture > Size & Properties, and choose
    "Move and size with cells" under Properties. This locks the logo to the cell.
  </Accordion>

  {" "}

  <Accordion title="What image format should I use for Excel?">
    PNG format is recommended for best compatibility across all Excel versions.
    SVG is only supported in Excel for Microsoft 365. Use `format=png` in your
    Logo.dev URL.
  </Accordion>

  {" "}

  <Accordion title="Can I add multiple company logos at once?">
    Yes. Use the IMAGE function with cell references and drag the formula down to
    populate multiple rows. Or use the VBA macro provided above to insert logos
    for an entire column of domains. Both need an IMAGE-capable Excel (Microsoft
    365, Excel 2024, or Online); on Excel 2019 and earlier, insert logos as web
    pictures instead.
  </Accordion>

  {" "}

  <Accordion title="How do I look up logos if I only have company names?">
    Use Logo.dev's [Search API](/docs/brand-search/introduction) to find
    companies by name instead of domain. This returns logos based on company name
    matching.
  </Accordion>

  {" "}

  <Accordion title="Will logos appear when I share the Excel file?">
    Yes. Logos inserted via the IMAGE function or as pictures are embedded in the
    Excel file and will appear for anyone who opens it, even without Logo.dev
    access.
  </Accordion>

  {" "}

  <Accordion title="Can I make logos transparent or greyscale?">
    Yes. Add `greyscale=true` to your Logo.dev URL for greyscale logos. For
    transparency, use PNG format which supports transparent backgrounds for logos
    that have them.
  </Accordion>

  {" "}

  <Accordion title="How do I add logos to Excel Online?">
    Excel Online fully supports the IMAGE function. Use the same formulas as
    desktop Excel. Logos will load automatically when you have an internet
    connection.
  </Accordion>

  {" "}

  <Accordion title="What size should I use for logos in Excel?">
    For in-cell logos, use `size=128` or `size=256`. For headers, use `size=128`.
    For small icons, use `size=64`. Adjust based on your cell size and layout
    needs.
  </Accordion>

  {" "}

  <Accordion title="Are there rate limits for Excel integrations?">
    Yes. Each plan has defined usage limits. See [rate
    limits](/docs/platform/rate-limits) for details.
  </Accordion>

  {" "}

  <Accordion title="How do I handle missing logos?">
    Logo.dev returns generated monograms for companies without logos. To show
    nothing instead, use our Search API to verify logo availability before
    inserting.
  </Accordion>
</AccordionGroup>