Table of contents
Linked data types
Linked data types

View and insert data from a data type

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Data types hold lots of information that you can view or add to your workbook at any time. After you convert to a data type, you can open cards that preview the info you can add to your workbook.

Try it!

  1. Select the data type icon in the cell to open the data card.

    Important: We recommend making sure your data types are in a table so Excel can help fill columns of data for you.

  2. Scroll through the card to view the fields and values you can work with.

  3. Hover over any value that you want to insert and select the  Add Column button  Insert Data button. Excel will automatically insert data for the same field for other data types in the column of a table. 

    Tip: If you select a cell in the table with data types, the  Add Column button  Add Column button appears and you can quickly select fields to add data without opening a card.

  4. If you ever need to get the most up-to-date data for your data types, go to Data > Refresh All.

Want more?

Linked data types FAQ and tips

How to write formulas that reference data types

What linked data types are available in Excel?

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!