Linked data types

Convert text to a linked data type in Excel (preview)

Convert text to a linked data type in Excel

Your browser does not support video.

Note: The data types you see in the ribbon of this video may vary from what you see in Excel.

Getting reliable data into your Excel workbook about subjects like cities, foods, animals, constellations, and more, has never been easier. With linked data types, you can insert and work with reliable data from trusted online data sources. Microsoft has partnered with Wolfram to provide rich, interesting facts and data on numerous subjects that you can use and refresh—all without leaving Excel.

Note: Linked data types powered by Wolfram are currently only available to those with a Microsoft 365 subscription and the English editing language added to your Office Language Preferences. If you meet these requirements but still don't see the feature, you may need to update Office. See When do I get the newest features? for more details.

Try it!

  1. In an Excel workbook, enter specific terms into separate cells. We recommend grouping subjects together in a single column with a header row.

    Tip: For the Foods data type, you can add modifiers like quantity or serving size to the text that you convert to get more specific results. For example: "3 eggs" or "5 oz linguine".

  2. Select the cells and go to Insert > Table to convert to a table. Check the box for My table has headers if you've added them.

  3. Select the text to convert in the table. Go to Data and in the Data Types group, select Automatic. If you see a Question mark icon in the cell, you'll have to use the Data Selector to specify the data type you want.

    Tip: If you already know what data type group to use, you can select it from the dropdown gallery. Specifying this can help Excel better match your text and retrieve the correct data. Find out what linked data types are available in Excel.

Want more?

Linked data types FAQ and tips

Stocks and geography data types

What linked data types are available in Excel?

Create a data type (Power Query)

Discover more from Wolfram

Give feedback about data types

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

×