A good periodic table is a necessary part of every chemist's, or future chemist's, reference materials. After looking around for a useful printable periodic table, I found that most were pretty basic and included only a few properties. So, we set out to create a periodic table using Excel that would include as many of the important chemical and physical properties as we could reasonably fit on a single piece of 8 1/2 x 11" paper.

The resulting Periodic Table of the Elements below includes the Atomic Number, Atomic mass, Symbol, Name, Electronegativity, Density, Ionization energy, Boiling point, Melting point, Electron Configuration, Oxidation States, Ground State Level, and Atomic Radius. If you typically work with a different set of properties, you can download the spreadsheet and add in your own numbers.


Periodic Table Template

for Excel
Periodic Table Template

Download

⤓ Excel
For: Excel 2007 or later

Description

This spreadsheet was used to create the printable periodic table above and also contains a worksheet listing the data for various chemical properties. If you'd like to create your own personal custom periodic table, you can download this Excel file and add your own sets of properties.

Data: The spreadsheet also includes a worksheet that lists the property data for the elements. You can use this data table for creating trend charts or use lookup functions to use the data within calculations.

Tip: You can create your own mini periodic table poster by printing on 11x17 paper.

Updates

5/28/2011: Update (Version 1.1) - Added indicator for radioactive elements, color-coded melting and boiling point data, added the crystal structure (in place of the van der Waals radius), and marked the atomic radius as either the metallic radius (m) or covalent radius (v).

9/7/2016: Updated the Excel file to correctly classify Radon as a gas.

9/29/2022: Fixed note about gas density to read "... g/L or kg/m³ at 0° Celsius for gases"



Disclaimer: The charts, spreadsheets, and information on this page are intended for educational and illustrative purposes only.