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

Note: Chemistry data types are 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 Chemistry data type

  1. In a cell, enter the name of a chemical element, chemical compound, isotope, mineral or chemical formula. For example, you might enter “Hydrogen”, “Water”, or “H2O”. If you're entering multiple, make sure each is in its own cell in a column.

  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 Chemistry.

  4. Excel will convert the text to a Chemistry data type that matches our online sources. You’ll know it’s converted if the Chemistry data type  The Chemistry data type icon.   icon 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.

    Tips: 

    Screenshot of the data card for Hydrogen.

  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 Chemistry 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.

  • When entering chemical formulas to convert to the Chemistry data type, casing matters. If you don’t get results the results you’re looking for, check your letter casing. For example, “Co” represents “cobalt” and “CO” represents carbon monoxide.  .

  • For elements on the periodic table, you may have to choose between a data type that represents a Chemical Compound and one that represents a Chemical Element:

    • Chemical compounds are represented by this The Chemistry data type icon. icon and has information like Structure, Phase Diagram, Identifiers, and more.

    • Chemical elements are represented by this Symbol for Chemical Element icon and has information like Atomic Size, Periodic Table Properties, Isotopes, and more.

Screenshot of the Periodic Table smart template.

See the Chemistry data type in action

Check out our interactive Periodic Table to learn about the elements with the power of linked data types in Excel.

Try the Periodic table 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?

Any additional feedback? (Optional)

Thank you for your feedback!

×