Data Types are a special kind of data in Excel with properties that can be accessed like fields. Example Data Types include Stocks, Geography, and Currency. A "linked" Data Type refers to a data type that is linked to an online data source. Linked data types retrieve data from an external source and can be refreshed to show the latest available information.
Available Data Types
You can find a list of supported data types on the Data tab of the ribbon. The screen below shows the data types available in Excel 365 as of January 2022:
Using Data Types
To use Data Types, first enter values in one or more cells. These should be values Excel can recognize as potential Data Types. Then select one or more cells, and choose an appropriate data type from the options on the Data tab of the Ribbon:
Note: Excel may ask you to confirm specific values that have more than one possibility.
Next, select or type the fields you want to display. This can be done by referencing a cell that contains a Data Type in a formula, as shown below:
Note the "dot" syntax used in the formula that separates the Data Type in cell B4 from the field name:
=B4.Population // fetch population =B4.area // fetch area
Field names that include spaces must be wrapped in square brackets:
You can also use the FIELDVALUE function to retrieve a field value from a Data Type:
=FIELDVALUE(B4,"area") // fetch area
Note the field values available for a given data type vary according to the kind of information it represents. In the example above, we selected the "Geography" Data Type. Another option is to use the "Cities" Data Type. The fields available for each of these Data Types are different.