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.


Printable Periodic Tables

The following two PDF files can be downloaded and printed on normal 8 1/2 x 11" paper (in landscape orientation) - perfect for including in a 3-ring binder. You will need to use a nice laser printer because the text is quite small. You may print and distribute as many paper copies of these periodic tables as you want to, as long as they are printed as-is. Note that photocopies don't turn out well. You should print directly from the original PDF.

categories: Education

Periodic Table Template

for Excel
Periodic Table of Elements
For: Excel 2007 or later

Other Versions

Template Details

License: Private Use
(not for distribution or resale)

"No installation, no macros - just a simple spreadsheet" - by and Brent Weight


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.

5/28/11: 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).

Sharing/Citing Our Periodic Table

If you like the design of our periodic table of elements, you are welcome to link to this page using the URL below.


Periodic Table Resources

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


Follow Us On ...

Master Excel - Spreadsheet Tips Workbook