With linked data types, you get access to information about a wide range of subjects and areas without ever leaving Excel. Excel gets this information from reputable sources such as Bing, Wolfram Alpha, and more. There are lots of linked data types available today and many more to come. This page will be updated to list the most current availability of linked data types.
Tip: If you want to know the source of the information that your converted data type is pulling from, simply select the data type icon in the cell to open the card, and at the bottom you'll see the source.
Note: Data types from Wolfram Alpha (all below except for Stocks, Geography, and Organization) are gradually being rolled out to subscribers. If you want to use them now, you must be in the Beta channel on the Insiders Program. See When do I get the newest features for Microsoft 365? for more details on how features are rolled out and how to join the Beta channel.
List of linked data types in Excel
Below is a list of all the data types that are available in the data types gallery dropdown. To use them, select the Data tab in Excel, in the Data Types group, expand the gallery to view all the data types available to you. If you don't see data types, see How can I access data types in the FAQ.
|
Ribbon Button |
Includes the following data types Examples |
|
stock, equity, mutual fund, ETF, index, currency pair, commodity, treasury benchmark MSFT, Microsoft |
|
|
country/region, city, state, administrative division, county, township, municipality, district, shire, province, territory, zip code Seattle, United States |
|
|
The availability of Organization data types varies. See Use Excel data types from Power BI for details on availability and how to use this feature. Employee ID, Customer name |
|
|
Location |
administrative division, airport, amusement park, amusement park ride, astronomical observatory, beach, bridge, building, canal, castle, cave, cemetery, city, country, dam, desert, district, court, earth impact, forest, geographic region, glacier, historical site, island, lake, library branch, library system, mine, mountain, museum, neighborhood, nuclear explosion, nuclear reactor, nuclear test site, ocean, oil field, park, particle accelerator, private school, public school, reef, reserve, land, river, school district, shipwreck, stadium, tunnel, undersea feature, university, US congressional district, volcano, waterfall, ZIP code The Louvre, Mariana Trench, Golden Gate Bridge, etc. |
|
Zip Code |
U.S. zip code 98052, 67212 |
|
University |
university University of Pennsylvania, WSU, Louisiana State |
|
Space |
astronomical radio source, comet, constellation, deep space probe, exoplanet, galaxy, manned space mission, meteor shower, minor planet, nebula, planet, planetary moon, pulsar rocket, satellite, solar system feature, star, star cluster, supernova Sirius A, Scorpio, Orion Nebula |
|
Satellite |
satellite Landsat 8, International Space Station, Starlink-21 |
|
Chemistry |
chemical, element, isotope, mineral H-6, lithium, magnesium, CO2, opal |
|
Element |
element Hydrogen, Helium, Li, Be |
|
Food |
food, food type, food type group, nutrient Tip: You can include serving size or quantities when using the food data type. 2 eggs, grains, hamburger |
|
Exercise |
exercise formula Tips:
running for 10 minutes, 140 lbs female swimming for 30 minutes |
|
Movie |
movie La La Land, Toy Story, Casablanca |
|
Automatic |
Characters: Indiana Jones, Veronica Mars Medical: ICD-9 311, Hodgkin's lymphoma Body: cornea, visual pattern recognition Media: Mona Lisa, Metallica Nature: lily, rhino, Siberian Husky Activities: Sun salutation A, Happy baby, Downward facing dog Other: Steven, stratosphere, hockey stick |
More about linked data types
Linked data types FAQ and tips
How to use linked data types with Excel
Learn more about our sources from Wolfram|Alpha
How to write formulas that reference data types
