|
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 |
|
stock, equity, mutual fund, ETF, index, currency pair, commodity, treasury benchmark About our finance data sources Powered by Bing MSFT, Microsoft |
|
|
exchange rates Powered by Bing USD/EUR, INR:AUD Tip: Make sure to insert two currencies separated by a "/" or a ":". |
|
|
country/region, city, state, administrative division, county, township, municipality, district, shire, province, territory, zip code Powered by Bing Seattle, United States |
|
|
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
