With linked data types, you can easily pull food nutrition facts and data right into Excel. To do this, you'll first convert text into the Foods data type and then insert the facts you want into your workbook. This article will teach you how.

Note: The Foods data type is only available to Microsoft 365 Personal, Microsoft 365 Family, and EDU subscribers. For more information about requirements see the Linked data types FAQ and tips.

How to convert to and use the Foods data type

  1. In a cell, enter the name of a generic food, food type, food group, or nutrient. For example, you might enter “Blueberries”, “Blueberry Pancakes”, or “2 eggs”. If you're entering multiple, make sure each is in its own cell in a column.

    Tip: You can include serving size or quantities when using the Foods data type. See the section on clarifying portions below.

  2. Select these cells and go to Insert > Table to create a table. Add a header column if desired.

    Note: While creating a table isn't required, we recommend putting your text in a table for the best experience.

  3. With the table selected, go to Data > expand the Data Types dropdown gallery > select  An icon of an apple for the Foods data type.  Foods.

  4. Excel will convert the text to a Foods data type that matches our online sources. You’ll know it’s converted if the Food icon An icon of an apple for the Foods data type.  appears in the cells.

    Note: If you see a question mark   Question mark icon  icon in the cell, this means that Excel needs your help to clarify a match. See the section on using the Data Selector below.

  5. To add data to your table, select one or more converted cells and the Add Column  Add Column button  button will appear. Select that button and select any of the fields to add those facts to the table. For example, selecting "calories, total" will insert a column with the approximate total number of calories for the portion sizes of the foods in the table. 

    Tips: 

    Screenshot of the data card for 20 blueberries.

  6. Once you've got the data you want in your workbook, you can use your favorite Excel features, like formulas, to reference and work with the data. See How to write formulas that reference data types for more information.

Use the Data Selector to specify a Foods data type match.

Use these tips below to help you figure out the correct match for your text. If you need help on how to use the Data Selector, see Use the Data Selector to specify data types

What to do if I get multiple results for the same food

You may see multiple results of the same food with different calorie counts. This means there are options that you can choose from.

In the example to the right, converting “Tomato Soup” will give you multiple options to choose from.

To find the result you need you can:

  • Refine your results by entering a more specific term in the text box of the Data Selector.

    Tip: So instead of "Tomato Soup" you might enter "Tomato Basil Soup" which will give you only one option. Selecting this will also update the text in your table.

  • You can also look at details for each result so you can make an informed choice on which result to select. To learn how, see below.

Screenshot of the Data Selector showing multiple results for "Tomato Soup."

To view details of a food result in the Data Selector:

  1. Select the image of a result to open the detail view.

  2. Scroll down to the related foods section and check if it's similar to what you want.

  3. If it is, Select it to choose this result and convert it. Otherwise, select the back arrow to check the other results.

In this example, this "tomato soup" result shows that its nutritional information actually represents a creamy tomato bisque. 

Screenshot of details of a creamy tomato bisque result in the Data Selector.

Clarifying portions and quantities for food

If you convert general food like “blueberries”, you may wonder what quantity is represented by the calorie count. By selecting the data type icon to open the card, you can check the consumed description field to see what quantity the nutrition facts represent.

You can easily refine foods with modifiers for quantity to get a better representation of what you ate. This can be done before converting or after by simply re-entering the text in the cell.

For example, you can enter “1/2 cup blueberries”, “60 g blueberries”, “20 blueberries”, “10 oz blueberries”, or even “1 large bowl blueberries”.

Screenshot of a table with converted Foods data types.

Get started with smart templates

We've created these handy smart templates that use the power of Excel and the Foods data type so you can start tracking your way to a balanced diet:

Practice healthy eating

Make your own recipe book and enter ingredients to get a better understanding of the nutritional breakdown of your favorite meals.

Try the recipe analyzer

Screenshot of the Recipe Analyzer smart template.

Maintain a balanced diet

Set personal dietary and nutrition goals, keep track of the foods you eat, and see the calories, carbs, protein, and fats that you consume.

Try the nutrition tracker

Screenshot of the Nutrition Tracker smart template.

See also

Linked data types FAQ and tips

What linked data types are available in Excel?

How to write formulas that reference data types

FIELDVALUE function

#FIELD! error

Need more help?

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

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×