Wolfram Knowledge about Chemicals in Microsoft Excel
Chemical entities have a constant composition and cannot be broken into smaller entities without breaking bonds.
A few example entities...
| L-lysine | ||||
| acetic acid | ||||
| benzene | ||||
| water | ||||
| methane | ||||
| ammonia | ||||
| carbon dioxide | ||||
| hydrogen sulfide | ||||
| D-(+)-glucose | ||||
| sodium hydroxide |
You can access the following properties for each entity...
- name
- IUPAC name
- alternate names
- formula string
- Hill formula string
- molar mass
- molecular mass
- relative molecular mass
- formal charges
- net ionic charge
- edge types
- element types
- H‐bond acceptor count
- H‐bond donor count
- isomers
- non-hydrogen count
- rotatable bond count
- tautomer count
- topological polar surface area
- vertex types
- Ka
- isoelectric point
- pKa
- pH
- pKa of side‐chain
- molar heat of combustion
- molar heat of fusion
- molar heat of vaporization
- density
- dielectric constant
- dipole moment
- electron affinity
- Henry law constant
- Hildebrand solubility parameter
- speed of light
- mean free path
- molar volume
- partition coefficient (XLogP)
- proton affinity
- refractive index
- resistivity
- solubility
- surface tension
- molar thermal conductivity
- van der Waals constants
- vapor density
- vapor pressure
- autoignition point
- boiling point
- critical pressure
- critical temperature
- flash point
- melting point
- DOT hazard class
- drug interactions
- lower explosive limit
- NFPA fire rating
- nfpa hazards
- NFPA health rating
- NFPA reactivity rating
- odor threshold
- odor
- RTECS classes
- upper explosive limit
- Beilstein number
- CAS number
- PubChem CID number
- EGEC number
- DOT numbers
- EU number
- gmelin number
- InChI identifier
- isomeric SMILES identifier
- MDL number
- NSC number
- RTECS number
- SMILES identifier
- non-standard isotope count
- + 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.
Explore Chemicals in Wolfram|Alpha
