Wolfram Knowledge about Plants in Microsoft Excel
Plant entities include particular species and higher-order taxonomic groups reflecting USDA reporting conventions.
A few example entities...
| Lonicera maackii f. erubescens | ||||
| hemp | ||||
| cosmos | ||||
| hawthorn | ||||
| draba | ||||
| sensitive plant | ||||
| banana | ||||
| spruce | ||||
| oak | ||||
| tulip | ||||
| nettle | ||||
| Balizia leucocalyx | ||||
| purplestem beggarticks | ||||
| european centaury | ||||
| flowering dogwood | ||||
| paradise plant | ||||
| venus flytrap | ||||
| southern california draba | ||||
| slenderleaf sundew | ||||
| squirting cucumber | ||||
| anchored water hyacinth | ||||
| field horsetail | ||||
| lompoc yerba santa | ||||
| funaria moss | ||||
| Galactia maisiana | ||||
| meadow geranium | ||||
| longbranch frostweed | ||||
| stinkingtoe | ||||
| cindercone isodendrion | ||||
| corkwood | ||||
| arrowleaf falsepickerelweed | ||||
| heartshape false pickerelweed | ||||
| Nitella translucens | ||||
| rice | ||||
| shortleaf pine | ||||
| Ptychomitrium fernandesianum | ||||
| Southern red oak | ||||
| Rosa viscaria | ||||
| Irish potato | ||||
| spanish broom | ||||
| common dandelion | ||||
| diamond burbark | ||||
| lingonberry | ||||
| wine grape | ||||
| corn | ||||
| northern reedgrass | ||||
| slimstem reedgrass | ||||
| Frullania kunzei var. kunzei | ||||
| lanai labordia | ||||
| simpleleaf chastetree |
You can access the following properties for each entity...
- name
- scientific name
- common name
- alternate scientific names
- alternate common names
- image
- mature height
- foliage color
- foliage texture
- flower color
- fruit color
- growth form
- shape and orientation
- category tags
- natural life cycle
- active growth period
- reproductive period
- toxicity
- precipitation range
- optimal temperature range
- minimum tolerable temperature
- minimum frost free days
- minimum precipitation
- maximum precipitation
- moisture use
- maximum pH
- minimum pH
- fertility requirement
- minimum root depth
- minimum planting density
- maximum planting density
- minimum area per plant
- maximum area per plant
- adapted to coarse textured soils
- adapted to fine textured soils
- adapted to medium textured soils
- cold stratification
- drought tolerance
- shade tolerance
- fire tolerance
- pruning tolerance
- salinity tolerance
- anaerobic tolerance
- calcium carbonate tolerance
- USDA geographic distribution
- taxonomic level
- USDA kingdom
- USDA subkingdom
- USDA superdivision
- USDA division
- USDA subdivision
- USDA class
- USDA subclass
- USDA order
- USDA family
- USDA genus
- USDA species
- USDA subspecies
- USDA variety
- USDA forma
- growth rate
- after harvest regrowth rate
- lifespan
- fall conspicuous
- flower conspicuous
- coppice potential
- fruit conspicuous
- known allelopath
- leaf retention
- low growing grass
- resprout ability
- carbon nitrogen ratio
- nitrogen fixation
- foliage porosity summer
- foliage porosity winter
- fruit/seed abundance
- fruit/seed begin period
- fruit/seed end period
- seed count
- seed spread rate
- seedling vigor
- vegetative spread rate
- fruit/seed persistence
- small grain
- propagated by bare root
- propagated by bulbs
- propagated by container
- propagated by corms
- propagated by cuttings
- propagated by seed
- propagated by sod
- propagated by sprigs
- propagated by tubers
- commercial availability
- human palatability
- protein potential
- palatable to browsing animals
- palatable to grazing animals
- berry nut seed product
- christmas tree product
- fodder product
- fuelwood potential
- lumber product
- naval store product
- nursery stock product
- post product
- pulpwood product
- veneer product
- USDA symbol
- wikipedia summary text
- + more
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.
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.
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.
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.
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.
