Periodic Table of Elements (Downloadable) and How to Read It - Compute Expert

Periodic Table of Elements (Downloadable) and How to Read It


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Periodic Table of Elements (Downloadable) and How to Read It





In this article, you can see and download a periodic table of elements in excel and/or PDF files. You can also learn how to read and optimally use the table and how to create the table in excel yourself.

Excel is very flexible software and we can program it into many things. One useful thing we can make from it is the periodic table of elements. As long as you master all the functions you need, you can create a neat, customized periodic table for yourself quickly.

Want to learn from the periodic table, download it, and/or understand how to read it in the right way? Stay tuned!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






Our Periodic Table of Elements Content

Here is a snapshot of the periodic table of elements we have created for you.

Periodic Table of Elements (Downloadable) and How to Read It and How to Learn from It - Screenshot of the Periodic Table of Elements from Compute Expert

If you download the excel file of this periodic table of elements, you can edit the table display to your preference.

Below is the list of the chemical elements that have a place in the periodic table.

Atomic NumberElement SymbolElement NameClassification
1HHydrogenHalogen
2HeHeliumNoble Gas
3LiLithiumAlkali Metal
4BeBerylliumAlkali Earth Metal
5BBoronMetalloid
6CCarbonNonmetal
7NNitrogenNonmetal
8OOxygenNonmetal
9FFluorineHalogen
10NeNeonNoble Gas
11NaSodiumAlkali Metal
12MgMagnesiumAlkali Earth Metal
13AlAluminiumPost-Transition Metal
14SiSiliconMetalloid
15PPhosphorusNonmetal
16SSulfurNonmetal
17ClChlorineHalogen
18ArArgonNoble Gas
19KPotassiumAlkali Metal
20CaCalciumAlkali Earth Metal
21ScScandiumTransition Metal
22TiTitaniumTransition Metal
23VVanadiumTransition Metal
24CrChromiumTransition Metal
25MnManganeseTransition Metal
26FeIronTransition Metal
27CoCobaltTransition Metal
28NiNickelTransition Metal
29CuCopperTransition Metal
30ZnZincTransition Metal
31GaGalliumPost-Transition Metal
32GeGermaniumMetalloid
33AsArsenicMetalloid
34SeSeleniumNonmetal
35BrBromineHalogen
36KrKryptonNoble Gas
37RbRubidiumAlkali Metal
38SrStrontiumAlkali Earth Metal
39YYitriumTransition Metal
40ZrZirconiumTransition Metal
41NbNiobiumTransition Metal
42MoMolybdenumTransition Metal
43TcTechnetiumTransition Metal
44RuRutheriumTransition Metal
45RhRhodiumTransition Metal
46PdPalladiumTransition Metal
47AgSilverTransition Metal
48CdCadmiumTransition Metal
49InIndiumPost-Transition Metal
50SnTinPost-Transition Metal
51SbAntimonyMetalloid
52TeTelluriumMetalloid
53IIodineHalogen
54XeXenonNoble Gas
55CsCesiumAlkali Metal
56BaBariumAlkali Earth Metal
57LaLanthanumLanthanide
58CeCeriumLanthanide
59PrPraseodymiumLanthanide
60NdNeodymiumLanthanide
61PmPromethiumLanthanide
62SmSamariumLanthanide
63EuEuropiumLanthanide
64GdGadoliniumLanthanide
65TbTerbiumLanthanide
66DyDysprosiumLanthanide
67HoHolmiumLanthanide
68ErErbiumLanthanide
69TmThuliumLanthanide
70YbYtterbiumLanthanide
71LuLutetiumLanthanide
72HfHafniumTransition Metal
73TaTantalumTransition Metal
74WTungstenTransition Metal
75ReRheniumTransition Metal
76OsOsmiumTransition Metal
77IrIridiumTransition Metal
78PtPlatinumTransition Metal
79AuGoldTransition Metal
80HgMercuryTransition Metal
81TlThalliumPost-Transition Metal
82PbLeadPost-Transition Metal
83BiBismuthPost-Transition Metal
84PoPaloniumMetalloid
85AtAstatineHalogen
86RnRadonNoble Gas
87FrFranciumAlkali Metal
88RaRadiumAlkali Earth Metal
89AcActiniumActinide
90ThThoriumActinide
91PaProctactiniumActinide
92UUraniumActinide
93NpNeptuniumActinide
94PuPlutoniumActinide
95AmAmericiumActinide
96CmCuriumActinide
97BkBerkeliumActinide
98CfCaliforniumActinide
99EsEinsteniumActinide
100FmFermiumActinide
101MdMendeleviumActinide
102NoNobeliumActinide
103LrLawrenciumActinide
104RfRutherfordiumActinide
105DbDubniumActinide
106SgSeaborgiumActinide
107BhBahriumActinide
108HsHassiumActinide
109MtMeitneriumActinide
110DsDarmstadtiumActinide
111RgRoentgeniumActinide
112CnCoperniciumActinide
113NhNihoniumPost-Transition Metal
114FlFleroviumPost-Transition Metal
115McMoscoviumPost-Transition Metal
116LvLivermoriumPost-Transition Metal
117TsTennessineHalogen
118OgOganessonNoble Gas





Periodic Table of Elements Download (Excel xlsx/PDF)

You can find the link to download the excel and PDF version of the table below.

If you want to edit the display of our periodic table to your preference, you should download the excel file. After you edit it in the excel file, you can export it to PDF or print it directly if you want.

We provide the table PDF in A3 and A4 versions here. If you intend to print the table to one of those papers, then download the PDF version you need.

Excel xlsx
PDF (A3)
PDF (A4)



How to Read a Periodic Table of Elements

A periodic table of elements places and groups the elements which existence we have identified based on their nature. You may notice some gaps that the periodic table of elements has in the middle. That is because we place the transition metals group there which nature is quite different from other elements.

The atomic number for each element (the number at the top of each element symbol in the table) represents the number of protons that element has. For example, as Nickel’s atomic number is 28 and Cobalt’s is 27, that means Nickel has more protons than Cobalt.

In the table, the elements are divided into periods (rows) and groups (columns). The elements that are in the same period have the same number of orbitals. The number of orbitals ranges from 1 (which the elements in the top period have) to 7 (which elements in the bottom period have).

The elements in the same group, on the other hand, have the same number of electrons in their outer shell. They also have similar physical properties and similar reactions to the elements in another group.

The relative position of one element to another in the periodic table of elements also has meanings. The more right an element location is in the periodic table, the larger ionization energy the element has.

It will also be more nonmetal in nature and has more negative electron affinity. Meanwhile, the more above an element is in the periodic table, the larger its electronegativity is.

Furthermore, the more right and above an element position is, the larger the atomic radius the element has. That is because the larger the element’s atomic number is, the more electrons it has. That means it will have a larger electron trajectory and therefore, a larger atomic radius.



Elements Grouping and Classification in a Periodic Table of Elements

As you can see in one of our periodic table of elements legend, the table divides the elements into ten groups. They are the alkali metals, alkali earth metals, transition metals, post-transition metals, metalloids, nonmetals, halogens, noble gases, lanthanides, and actinides.



The members of these ten groups and their general characteristic in brief are:
  • Alkali metals (Li, Na, K, Rb, Cs, Fr): extremely reactive and will burst into flame when contacting water
  • Alkali earth metals (Be, Mg, Ca, Sr, Ba, Ra): reactive but not as reactive as alkali metals
  • Transition metals (Sc, Ti, V, Cr, Mn, Fe, Co, Ni, Cu, Zn, Y, Zr, Nb, Mo, Tc, Ru, Rh, Pd, Ag, Cd, Hf, Ta, W, Re, Os, Ir, Pt, Au, Hg, Rf, Db, Sg, Bh, Hs, Mt, Ds, Rg, Cn): malleable, shiny, and are a good conductor
  • Lanthanides (La, Ce, Pr, Nd, Pm, Sm, Eu, Gd, Tb, Dy, Ho, Er, Tm, Yb, Lu): have a silver color and tarnish when contacting air
  • Actinides (Ac, Th, Pa, U, Np, Pu, Am, Cm, Bk, Cf, Es, Fm, Md, No, Lr): radioactive
  • Post-transition metals (Al, Ga, In, Sn, Tl, Pb, Bi, Nh, Fl, Mc, Lv): have characteristics similar to transition metals but softer and are a worse conductor
  • Metalloids (B, Si, Ge, As, Sb, Te, Po): have conductor/semiconductor properties
  • Nonmetals (C, N, O, P, S, Se): are a poor conductor
  • Halogens (F, Cl, Br, I, At, Ts): quite reactive chemically
  • Noble gases (He, Ne, Ar, Kr, Xe, Rn, Og): colorless, odorless, and nonreactive

We can group these ten again into three big groups if we want. These three big groups are metals, metalloids, and nonmetals.

Each of these three big groups has different traits generally. Those traits for each big group are:
  • Metals (alkali metals, alkali earth metals, lanthanides, actinides, transition metals, and post-transition metals):
    • A good heat and electricity conductor
    • Malleable and ductile
    • Solid at room temperature
  • Metalloids (metalloids):
    • Have physical properties more like nonmetals
    • Under certain circumstances, several metalloids can conduct electricity
  • Nonmetals (nonmetals, halogens, and noble gases):
    • A poor heat and electricity conductor
    • Not malleable and not ductile
    • Many are gases at room temperature

You can easily see the elements groupings according to the ten groups and three big groups in their periodic table placement.


Tips to Use/Learn This Periodic Table of Elements

Need to learn the details of the elements in the periodic table? Here are some tips you can apply to get the most of our periodic table of elements.
  • Print the PDF A4 version of our periodic table and put it somewhere you can easily take. Moreover, print the PDF A3 version too and place it in a strategic place you can easily see. That way, you will grow more accustomed to the table content and able to learn it wherever whenever you want
  • Make rhymes, songs, stands, or sentences for the elements sequence in each period and group in the table. By doing that, you should memorize the element members of each period and group much easier
  • Break the table into sections and repeat the memorization of each section separately. Do it until you can recite them easily before you group the sections again into one

Hope these tips can help you learn more easily!


How to Create the Table in Excel

Want to learn how to create a periodic table of elements in excel? It is very simple and you should be able to do it if you have mastered the basic functions in excel!

You just need to understand how to insert and resize font, shapes, rows, and columns in excel. You should also be able to copy, color, and merge cells. As you may infer from our periodic table display, we created the table partly by doing these things.

For the periodic table legends, we created them in the second sheet. We didn’t create them directly in the first sheet since the cells form there seem to won’t display the legends neatly. Therefore, we copy the legends we created in the second sheet and paste them as pictures in the first sheet.

For the table background, we color it white since we want it not to be transparent. You may also notice that we inserted rows and columns in between the elements there. This is so we can separate those elements location clearly.


How to Modify this Table in Its Excel Template

Want to modify the display of our periodic table of elements in its excel file? You should be able to do most things we did to create the table beforehand!



You may want to change the color, font, or cell details of the table. You can do that easily by mastering the ways to alter the worksheet display in excel.

If you need to change the display/content of the table legends, you can do that in the second sheet. Do the modifications you want and then copy-paste them as pictures in the first sheet after you finish.


Multiplication Exercise/Game

Have learned from the periodic table of elements and the contents of this article? Want to test your knowledge by doing some related exercise? Try to answer the five questions below!
  1. What are the metalloid and noble gas elements?
  2. What is the group of hydrogen, magnesium, and gold in the periodic table of elements?
  3. What is the meaning of the left-to-right position of the elements in the periodic table?
  4. What are the differences between metals, metalloids, and nonmetals and what are their element groups?
  5. What is the meaning of the atomic number that each element has in the periodic table?

If you don’t know the answers, check your periodic table and learn from this article content again!



Additional Note

To retrieve the information about an element from our periodic table in excel, you can use the HLOOKUP or INDEX MATCH. You may want to create a separate table first though that contains all the elements information you need. This is so you can retrieve the information you need later much easier.



Excel tutorials you may want to learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert