Data Import & Export

How to Fix Excel Stocks Data Type Not Searching by ISIN Code

Adam Davis Sep 29, 2026 869 views

Question details

Users are unable to use International Securities Identification Numbers (ISIN) to search for securities when using the Stocks data type in Excel.

How to Find Financial Data When Excel Stocks Cannot Search by ISIN Code

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to retrieve financial data for specific funds or companies using the built-in Stocks data type.
Observed behavior: Excel fails to return search results when an ISIN code is entered, as the feature does not natively index or expose ISINs for search queries.

Before you start

Ensure you have a stable internet connection and are signed into your Microsoft 365 account, as the Stocks data type requires online access to fetch financial data.

Solution 1Recommended

Search by Ticker Symbol or Company Name

Since Excel's data provider does not index ISIN codes for direct searches, using a ticker symbol or company name is the most reliable alternative to find the correct security.

The underlying data source for Excel's Stocks data type relies heavily on standard ticker symbols and official company names rather than international identification codes.

Identify the Ticker Symbol

Find the official exchange ticker symbol or the exact company name for the security you are trying to track.

Enter Data into Excel

Type the ticker symbol (e.g., MSFT) or the company name into a blank cell in your spreadsheet.

Apply Stocks Data Type

Select the cell, navigate to the 'Data' tab on the top ribbon, and click on 'Stocks' in the Data Types group.

Verify the Security

If a question mark icon appears next to the cell, click the icon to open the Data Selector pane on the right side of the screen and manually select the correct fund or company.

Tip for better accuracy: Including the stock exchange prefix before the ticker symbol (for example, XNAS:MSFT for Nasdaq) can help Excel find the exact security much faster.

Solution 2

Use Fund Name Variations in the Data Selector

If a specific mutual fund or ETF isn't appearing with a standard search, using partial names or abbreviations in the Data Selector pane can help locate it.

Free Microsoft Office alternative

Manage Your Financial Spreadsheets with WPS Office

While advanced online data types depend on specific Microsoft data providers, WPS Office offers a completely free, highly compatible, and lightweight alternative for all your financial tracking, data analysis, and standard spreadsheet needs without expensive subscriptions.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring seamless document migration.Lightweight software that opens large financial datasets quickly and runs smoothly on older devices.Advanced built-in financial formulas, pivot tables, and charting tools for deep data analysis.Completely free core spreadsheet features with an intuitive, familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the Excel Stocks data type recognize ISIN codes?

Excel's underlying financial data provider (Refinitiv/Bing) relies primarily on ticker symbols, company names, and fund names. ISIN codes are generally not exposed as searchable fields in their consumer-facing database.

What should I do if a mutual fund cannot be found at all?

If trying various names and ticker symbols fails in the Data Selector pane, the specific security might not be included in Excel's data source. You may need to manually import the data from a financial website or use a third-party finance add-in.

Can I search by CUSIP or SEDOL instead of ISIN?

No. Similar to ISIN codes, Excel's Stocks data type generally does not support direct searches by CUSIP, SEDOL, or other localized identification numbers. It is highly recommended to stick to ticker symbols and official company names for accurate results.

Excel & Data Problems