Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

After June 11, 2023, data types by Wolfram will no longer be supported and can't be refreshed. However, Bing, Power Query, and Organization data types will still be supported.

Linked data types connect to reputable sources of data, such as Bing, Power BI and more, so you can access information about a variety of subjects without ever leaving Excel. This page will be updated with what's currently available.

Note: Linked data types are only available to Worldwide Multi-Tenant clients (Microsoft 365 accounts,) but data types from different sources may have different requirements. To check the source, select the data type icon in the cell of a converted data type > in the card, scroll to the bottom for the source name. For detailed requirements, see How to access data types in the FAQ.

List of linked data types in Excel

To open the data types gallery, go to the Data tab in Excel > Data Types group > expand the dropdown. 

Note: Most data types require a Microsoft 365 subscription to use, but data types from different sources may have different requirements to use them. To check the requirements, see How to access data types in the FAQ. To check the source, select the data type icon in the cell of a converted data type to open the card, then scroll to the bottom for the source name.

Ribbon Button

Includes these data types

Examples to convert

Stocks

stock, equity, mutual fund, ETF, index, currency pair, commodity, treasury benchmark

About our finance data sources

Powered by Bing

MSFT, Microsoft

Currencies

exchange rates

Powered by Bing

USD/EUR, INR:AUD

Tip: Make sure to insert two currencies separated by a "/" or a ":".

Geography

country/region, city, state, administrative division, county, township, municipality, district, shire, province, territory, zip code

Powered by Bing

Seattle, United States

Organization

See Use Excel data types from Power BI for details on availability and how to use this feature.

Powered by Power BI

Employee ID, Customer name

More about linked data types

Linked data types FAQ and tips

Convert linked data types with Excel

How to write formulas that reference data types

Give feedback about data types

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.