You teach Quran memorization to a group of students and want to know, for each one, how much they have memorized, where they have reached, when they last reviewed, and whose review is overdue. The free Quran memorization and review tracker does that in Excel, Google Sheets or online.
The problem it solves
New memorization is usually written in a follow-up notebook, but review is what gets lost. Weeks later you cannot quickly tell who has not reviewed for a while, how many faces a student memorized this month, or exactly where they stopped. You count lines by hand and rely on memory for who dropped off, so the alert comes late.
How the sheet solves it, step by step
- In Settings write today's date, the number of days after which a review counts as late, and your circle or group names.
- In Students write a first name or a code and pick the group.
- In Recitations write one row per session: date, student and type (new memorization or review).
- Type the position as text in "from" and "to", such as "Baqarah 1" and "Baqarah 10", then the number of faces as a number you count yourself, and pick a rating from the list.
- The sheet calculates totals, last memorization, last review and days overdue, and shows the alert.
- Open Follow-up and Summary for the results.
What each sheet does
Settings holds today's date (type =TODAY() to update daily), the late-review days, the number of faces per page (set it to match your mushaf; it is only used to show the equivalent in pages) and the group list.
Students is the individual summary: total memorized and reviewed in faces, session count, last memorization and last review dates, days overdue, the last position reached and how many times the rating was "repeat". Overdue students are shaded red and those with no review yellow.
Recitations is the entry log, one session per row. A check column warns about an unknown student or a missing date or number of faces.
Follow-up lists overdue students from the most overdue, with their group and last memorization position. Summary shows sessions, totals, the last seven days, alert counts, rating distribution and a table per group.
Why it matters
- You see overdue review before it fades, not weeks later.
- You know what each student memorized and reviewed without counting by hand.
- You set the overdue days to match your own circle's plan.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not from real statistics. The names are made-up first names and the positions only show the format. It has six students in two groups and 24 sessions: 28 faces of new memorization and 23 of review. Today in the sheet is 1 November 2026 and the limit is 14 days.
"Ahmed" memorized 9 faces and reviewed 8, with his last review 3 days ago, so no alert. "Yousef" last reviewed 31 days ago and tops the list; "Mohamed" 20 days ago; "Omar" 15 days ago, third. "Ali" reviewed exactly 14 days ago, so he is not late because the alert needs more than the limit. "Ziad" has no review yet and shows "no review recorded". Two sessions are rated "repeat", one for Yousef and one for Ali. The total memorized is 28 faces, or 14 pages if two faces make a page, as in the sample settings.
An important note
The number of faces is a figure you enter. The sheet has no mushaf table and does not convert verses into faces. Write only a first name or a code for each student, with no sensitive personal details. The sheet organizes your follow-up; judging the recitation remains yours.
The online version
Open the page and the sheet is already filled with the example. Edit any cell and watch the results change, add a student or a session with a simple form, and import or export .xlsx. Your data stays in your browser on your device.
Who it suits
It suits a Quran teacher in a circle, school or mosque, and a supervisor who wants one view across several groups. For marks try the Al-Azhar student grades sheet, and for homework the homework and behavior tracker.
Bottom line
Make review show up before it is forgotten: a session per row, totals per student and a list of who is late. Open the sheet on the example, then clear the sample numbers and add your students.