Stock Logos in Google Sheets & Excel

    One IMAGE() formula turns a column of tickers, ISINs, or WKNs into real company logos -- no plugin, no add-on, no manual downloading.

    Same REST API either way: the formula that works in a spreadsheet today is the same endpoint a production app calls tomorrow.

    What the Formula Returns

    Column A holds the ticker. Column B is the IMAGE() formula. This is the real output.

    #A: TickerB: =IMAGE(...)C: Company
    2AAPLApple Inc. logoApple Inc.
    3MSFTMicrosoft Corporation logoMicrosoft Corporation
    4AMZNAmazon.com, Inc. logoAmazon.com, Inc.

    Google Sheets

    1. Put a ticker, ISIN, or WKN in column A (e.g. AAPL in A2).
    2. In column B, enter the formula below and press Enter.
    3. Drag the fill handle down to apply it to every row.
    =IMAGE("https://api.logostream.dev/stocks/symbol/"&A2&"?key=YOUR_API_KEY&variant=icon&format=png")

    Google Sheets' IMAGE() function fetches the URL and renders it directly in the cell -- the row height auto-adjusts to fit the logo.

    Excel

    Excel's own IMAGE() function (Microsoft 365 subscribers) works the same way:

    =IMAGE("https://api.logostream.dev/stocks/symbol/"&A2&"?key=YOUR_API_KEY&variant=icon&format=png","Logo")

    On an older Excel build without IMAGE(), the same URL works as a linked picture via Insert > Pictures > From a File, pasted as a web address.

    Ticker, ISIN, or WKN -- Your Choice

    Swap the identifier segment in the URL to match whatever column your spreadsheet already uses.

    By ticker

    /stocks/symbol/AAPL

    By ISIN

    /stocks/isin/US0378331005

    By WKN

    /stocks/wkn/865985

    Beyond Stocks: Banks & Crypto

    The same formula pattern works for bank and crypto identifiers, since they're the same authenticated API -- not a separate, spreadsheet-only product tier.

    Bank by BIC

    =IMAGE("https://api.logostream.dev/banks/bic/DEUTDEFFXXX?key=YOUR_API_KEY&format=png")

    Crypto by symbol

    =IMAGE("https://api.logostream.dev/cryptos/bitcoin?key=YOUR_API_KEY&format=png")

    Some competing spreadsheet-logo endpoints are free but scoped to stocks only and explicitly barred from use outside a spreadsheet -- a separate, paid API is required to use the same lookup in a real application. logostream.dev is one API for both, so a formula built today for a spreadsheet prototype becomes production code without a rewrite.

    FAQ: Logos in Spreadsheets

    Yes. Every request to api.logostream.dev, including one made from inside a spreadsheet formula, requires a key query parameter with a valid API key. This differs from some competitors' spreadsheet-only endpoints, which skip authentication entirely but restrict usage to spreadsheet applications and block the same identifier lookup from being used in a real web or mobile app. logostream.dev uses one authenticated endpoint for both -- request a key by contacting sales@logostream.dev, then reuse the exact same formula pattern (and the exact same key) if that spreadsheet prototype later becomes a production dashboard.

    Both Google Sheets' IMAGE() function and Excel's IMAGE() function (Microsoft 365) render common raster formats -- PNG, JPEG, GIF -- but neither renders SVG directly inside a cell. logostream.dev serves 100% SVG by default across its API, which is the right choice for a web app where the logo needs to scale cleanly, but a spreadsheet formula needs the raster fallback instead. Adding &format=png to the request URL returns a rendered PNG version of the same logo, sized appropriately for a cell, without changing anything else about the lookup.

    Yes. The identifier type is just a path segment in the request URL -- swap /stocks/symbol/ for /stocks/isin/ or /stocks/wkn/ and reference the column holding that identifier instead of the ticker column. This matters most for spreadsheets built around European portfolio or fund data, where ISIN or WKN is often the primary key already in use, rather than a US-style ticker symbol that would need a separate lookup or mapping column before a formula could even run.

    Get Your API Key

    One key, every identifier type, every asset class -- spreadsheet or production app.

    Request API KeyView Documentation