Wolfram Computation Meets Knowledge

Wolfram Knowledge about Foods in Microsoft Excel

Food entities are classified with over 10,000 attributes and have detailed information for over 150 nutrients.

A few example entities...

Beef, chuck for stew, separable lean and fat, select, cooked, braised
Cereals ready-to-eat, GENERAL MILLS, BASIC 4
Cheese, cottage, creamed, large or small curd
Lamb, New Zealand, imported, rack - fully frenched, separable lean only, raw
Peppers, sweet, green, canned, solids and liquids
Pretzels, soft
Soup, black bean, canned, condensed
Soup, tomato bisque, canned, prepared with equal volume water
Turkey, retail parts, breast, meat only, cooked, roasted
Veal, shoulder, blade chop, separable lean and fat, cooked, grilled

You can access the following properties for each entity...

  • calories, total
  • calories from fat
  • calories from carbohydrates
  • calories from protein
  • carbohydrates, total
  • carbohydrates, total, % daily value
  • fat, total
  • fat, total, % daily value
  • protein, total
  • protein, total, % daily value
  • fiber, total
  • fiber, total, % daily value
  • sugar, total
  • saturated fat, total
  • saturated fat, total, % daily value
  • trans fat, total
  • vitamin A
  • vitamin A, % daily value
  • vitamin C
  • vitamin C, % daily value
  • vitamin D
  • vitamin D, % daily value
  • vitamin B12
  • vitamin B12, % daily value
  • cholesterol
  • cholesterol, % daily value
  • sodium
  • calcium
  • calcium, % daily value
  • iron
  • iron, % daily value
  • magnesium
  • magnesium, % daily value
  • UPC
  • absolute mass
  • absolute volume
  • default item size mass
  • default serving size mass
  • default serving size volume
  • name
  • image
  • + more
  • - less

Note: Wolfram entities represent physical entities as well as mathematical and other scientific concepts. Each entity type has a unique set of properties. Wolfram entity types and properties correspond to "data types" and "fields" in Excel.

How to Use Wolfram Data in Excel

Note: This is now available with a Microsoft 365 Family or Personal subscription.

1

Highlight data and click the Automatic button

Select cells or columns in a table with the text to convert, then select the Automatic button in the Data Types gallery of the Data tab. Wolfram's natural language understanding will recognize the entities and convert them.

2

Browse associated data

Select the Insert Data button that appears to browse a list of all available properties. Select one to insert data into your workbook. When you have data in a table, Excel will automatically fill the table for you. Wolfram has hundreds of expertly curated entities in Excel, encompassing the sciences, arts, culture, and more.

3

Automatically get data

Once converted to an entity, you can use key Excel features to work with data pulled from Wolfram. Sort and Filter data, or create formulas that reference an entity's properties and values.

4

Browse more information

Selecting the icon of a converted cell opens a card where you can find detailed data from Wolfram. This means you don't need to leave Excel to accomplish your goals.

Compute with Food data in the Wolfram Language