# Periodic table Excel sheet (free): lookup and quiz

> Free Excel periodic table with all 118 elements in Arabic and English, element lookup, molar mass calculator, trends, a 38-question quiz and review dates.

Source: https://softwiro.com/blog/periodic-table-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Periodic table in Excel (free): lookup, molar mass calculator and quiz

All 118 elements with Arabic names, a colour-coded table, a molar mass calculator and a self-test with review dates.

15 November 2026 5 min read

## In short

- All 118 elements with Arabic and English names, standard atomic mass, group, period, block, category and state in one table.
- Type a symbol, number or name and the element card appears and its place is highlighted in the coloured table.
- The molar mass calculator multiplies each element's mass by its atom count: H₂O gives 18.015 g/mol, with each element's share.
- A 38-question quiz marks itself, and the progress sheet proposes the next review date from your score.
- A general summary, not an official syllabus for a particular grade; check your school textbook.

You want to study the periodic table without flipping through textbook pages, to get the molar mass of any compound in seconds, and to test yourself before the exam. The free [periodic table sheet](https://softwiro.com/templates/periodic-table) puts it all in one file: all 118 elements with Arabic and English names, a colour-coded table, lookup by symbol, a molar mass calculator and a 38-question quiz. It is a general summary, not an official syllabus for any particular grade; check your school textbook.

## The problem it solves

The textbook table is one crowded page, while the exam asks for scattered things: an element's symbol, its atomic number, its group and period, its category, its state, then a molar mass inside a problem. You jump between the table, a list of masses and a calculator, and you slip on a symbol or a sum. The sheet keeps this data in one place: you read it, search it, calculate with it and test yourself on it.

## How the sheet works, step by step

1. Open الجدول الدوري (Periodic table) to see the elements by group (1 to 18) and period (1 to 7), coloured by category. The lanthanides and actinides sit in two rows below the table.
2. In بحث عن عنصر (Element lookup) type a symbol, atomic number or name; the element card appears and its place is highlighted in the table.
3. In الكتلة المولية (Molar mass) type each element's symbol and its number of atoms; the molar mass and each element's share come out.
4. Read اتجاهات الجدول (Trends) to see how atomic radius and electronegativity change across a period and down a group.
5. Answer اختبار ذاتي (Self-test); a tick or a cross appears and the score shows at the top.
6. Log what you reviewed and your score in المتابعة (Progress), and the sheet proposes the next review date.

## What is in each sheet

- Periodic table: the table in ten category colours, with the chosen element highlighted.
- Element lookup: a full card, searched by symbol, number or name.
- Elements: 118 rows with atomic number, symbol, both names, atomic mass, group, period, block (s, p, d, f), category and state.
- Molar mass: six symbol-and-count pairs, mass percentages, and a gram-to-mole conversion.
- Common compounds: 17 compounds with their molar masses; the list holds 30.
- Trends: the trends table, data for periods 2 and 3, and two charts.
- Self-test: 38 questions with a hidden answer key.
- Progress and Summary: review dates, counts of categories and states, and your result per topic.

## Walk-through on the sample numbers (sample data)

These numbers come from the sample copy inside the sheet, what you see before typing anything.

- Looking up Fe: iron, atomic number 26, atomic mass 55.845, group 8, period 4, d-block, transition metal, solid at room temperature.
- Molar mass of water H₂O: 2 × 1.008 = 2.016 for hydrogen and 1 × 15.999 = 15.999 for oxygen, so the total is 18.015 g/mol. Hydrogen is 11.2% and oxygen 88.8%.
- Grams to moles: 90 g of water is 90 ÷ 18.015 = 4.9958 mol. Half a mole weighs 9.0075 g.
- Compounds in the list: calcium carbonate CaCO₃ is 100.086, glucose C₆H₁₂O₆ is 180.156, sodium chloride is 58.44.
- Trends: in period 2 electronegativity rises from 0.98 for lithium to 3.98 for fluorine, an increase of 3.00. Radius in group 1 goes from 145 pm for lithium to 260 pm for caesium.
- The table in numbers: 118 elements, 84 with a standard atomic mass and 34 with no stable isotope (mass in brackets). By state: 11 gases, 2 liquids, 84 solids and 21 of uncertain state.
- The sample quiz: 34 of 38 questions answered, 28 correct, a score of 73.7%. In Progress, three topics are due for review on 2026-11-15, with an average score of 66.7%.

## Common mistakes

- Mixing up symbols: Co is cobalt and CO is carbon monoxide. Capital first letter, small second.
- Forgetting the atom count: water is 18.015, not 17.007 (hydrogen counted once); multiply each mass by its number of atoms.
- Confusing atomic mass with atomic number: the first is a mass in u (iron 55.845), the second is the number of protons (iron 26).
- Treating a bracketed mass as a standard one: [209] for polonium is a mass number of one isotope; use it knowingly if you must.
- Comparing with a book that rounds masses: if your book takes O = 16 and H = 1, water is 18 there and 18.015 here. The difference is rounding, not method.

## When to move from the sheet to a system

The sheet is enough for a student or teacher who studies and reviews alone. If you want to follow dozens of students across classes, with a large question bank and a board showing the class's weak topics, you need a program with a login for each user, and Softwiro can [build one your way](https://softwiro.com/contact). To organise your study time further, see the [study planner](https://softwiro.com/templates/study-planner) and the [science rules summary](https://softwiro.com/templates/science-rules).

## Next step

Download the sheet, open «بحث عن عنصر» and type the symbols of three elements you do not know by heart, then compute the molar mass of a compound from your current lesson in «الكتلة المولية», take the quiz once and log your score in «المتابعة». That gives you your first written review date.

## FAQ

**Does this sheet match my grade's syllabus?** It is a general summary, not an official syllabus for any particular grade; check your school textbook, since the order or classification of some elements can differ between books.

**Why are some masses in brackets?** The element has no stable isotope, so a mass number of one of its longest-lived isotopes is written instead of a standard atomic mass.

**How does the quiz mark answers?** Numbers have a small tolerance, and for text the case of English letters does not matter.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: the periodic table (1/3)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-1.jpg)[![Cheat sheet: the periodic table (2/3)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-2.jpg)[![Cheat sheet: the periodic table (3/3)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/periodic-table/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Does this sheet match my grade's syllabus?

It is a general summary, not an official syllabus for any particular grade; check your school textbook. The order or classification of some elements can differ between books, and your book may round masses (H = 1, O = 16), so molar mass answers can differ in the second decimal.

### Why are some atomic masses in brackets?

The element has no stable isotope, so it has no standard atomic mass. A mass number of one of its longest-lived isotopes is written in brackets instead, such as [209] for polonium. The sheet has 34 such elements.

### How do I compute a compound's molar mass?

In the Molar mass sheet type each element's symbol and its number of atoms next to it (water: H and 2, then O and 1). The sheet multiplies and adds, giving 18.015 g/mol, and shows each element's percentage.

### How does the quiz mark my answers?

Numeric answers have a tolerance written in the sheet (0.05 for molar masses). For text the case of English letters is ignored, so au is accepted for gold's Au. Pick category, state and trend answers from the drop-down list.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
