# Quran Hifz Tracker Excel Template (Free)

> A free hifz tracker for Excel: log sabaq, sabqi and manzil, rate each lesson, see progress to a target date and which juz are overdue for revision.

Source: https://softwiro.com/templates/quran-hifz-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Quran Hifz Tracker Template for Excel (Sabaq, Sabqi, Manzil)

A free hifz tracker for teachers, parents and students in a part-time or full-time memorisation programme. List your students with a target in pages and a target date, then log each session: the new lesson (sabaq) with its juz and range, recent revision (sabqi), older revision (manzil), a rating from 1 to 5 and the teacher's note. The sheet adds up each student's pages and juz, compares the pace needed with the pace achieved, flags a student whose older revision has gone unrevised for more than the number of days you choose, and shows which juz have not been seen lately. It works in Excel, LibreOffice and Google Sheets.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-quran-hifz-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-quran-hifz-tracker-blank.xlsx)

Excel file (.xlsx) · 212 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Student | Pages memorised | Target (pages) | % of target | Status |
| --- | --- | --- | --- | --- |
| Amina Rahman | 31.2 | 60 | 52.0% | On pace |
| Yusuf Ahmed | 20.0 | 40 | 50.0% | On pace |
| Maryam Khan | 57.0 | 120 | 47.5% | On pace |
| Ibrahim Patel | 114.0 | 200 | 57.0% | Behind |
| Zainab Ali | 19.3 | 30 | 64.4% | Behind |
| Omar Hassan | 3.2 | 30 | 10.7% | Behind |
| Bilal Mahmood | 194.0 | 604 | 32.1% | Behind |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Students, total pages and juz memorised, share of all targets reached, new pages this week and this month, average rating, students with a revision alert and juz overdue. Tables by status, by group and a progress list, with four charts: % of target by student, pages per week (sabaq, sabqi, manzil), students by status and new pages per month.
- Students: One row per student: group, start date, pages memorised before logging, target pages and target date in white. Grey columns work out pages logged, total, juz, % of target, pages left, days to target, pace needed and achieved in pages per week, projected finish, status, last new lesson, last older revision, days since, revision alert, juz overdue, average rating and sessions.
- Daily Log: One row per session: date, student, sabaq juz and range, sabaq pages and extra lines, sabqi pages, manzil juz and pages, rating, teacher's note. A Check column flags a student not on the list, a missing juz or a rating outside 1 to 5.
- Revision: A grid of students by juz 1 to 30 showing the days since each juz was last seen, red when it is beyond your alert, with the number of juz in the log and the number overdue for each student.
- Totals: Pages per week for the last 8 weeks and per month for the last 6, with sessions and average rating, and a table of each student's pages this week and this month.
- Student Sheet: Pick one student to see their figures, the latest 10 sessions with the teacher's notes, and the 30 juz with last seen date, days since and status, with a chart. Print it or save it as a PDF for a parent.
- Settings: Programme name, the as-of date, the revision alert in days, lines per page, pages per juz, your groups and a rating key.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most free hifz trackers are a grid to tick or a page to print. This one keeps the log you already write in a notebook and does the arithmetic for you: it tells you whether a student is on pace for the target date, and which juz have gone longest without being revised, so the older portions are not forgotten while the new lesson moves forward. It carries no rulings and no opinions, only your records. The sample is eight students and 166 sessions between 5 October and 19 November 2026, so every column and chart is filled before you replace it with your own.

## How do I track hifz progress in Excel?

Keep two things: a list of students with a target, and a log with one row per session. For each session write the date, the student, the new lesson (sabaq) with its range and the pages or lines learned, the recent revision (sabqi) and the older revision (manzil). Total memorised is then the pages the student already had plus every new page in the log. Divide by pages per juz to see juz, and by the target to see the percentage.

In the sample, the eight students have 453.3 pages in total, 22.7 juz, which is 40.9% of the combined targets. Amina Rahman has 31.2 pages, 52.0% of her 60-page target. For pages on a mushaf with a different number of lines, change lines per page and pages per juz on Settings.

## How do I track sabaq, sabqi and manzil?

Sabaq is the new lesson, sabqi is recent revision and manzil is older revision. Put them in separate columns so each total stays separate. Totals adds them week by week and month by month. In the sample week starting 16 November, the students learned 10.0 new pages, and November so far (to the 20th) has 43.9 new pages with an average rating of 3.60.

Type the juz next to the new lesson and next to the manzil. That is what lets the sheet tell which juz were seen recently and which were not.

## How do I make sure old lessons are not forgotten?

Choose how many days is too long on Settings. The sample uses 10. Students shows the last older revision date and the days since. Ibrahim Patel last did a manzil on 3 November, 17 days before the as-of date, so he shows Revise now. Omar Hassan has no older revision logged at all, so he shows No revision logged. Together that is 2 students with an alert.

Revision goes further than that: for each student it shows the days since every juz was last seen as a new lesson or a manzil. In the sample, 10 juz across the programme are beyond 10 days, 4 of them for Bilal Mahmood, who has 8 juz in his log. A juz you have never logged stays blank, so enter a manzil row for what a student memorised before you began.

## How do I know whether a student is on pace for the target date?

Pace needed is the pages left divided by the days to the target date, times 7. Pace achieved is the new pages from the last 28 days divided by 4. If achieved is at least needed the status is On pace, otherwise Behind. Amina needs 1.54 pages a week and is doing 1.60, so she is on pace; Ibrahim needs 3.14 and is doing 1.50, so he is behind. The projected finish date assumes the recent pace continues. It is arithmetic on your log, not a prediction about a person.

## How to use it

1. On Settings type the programme name, an "as of" date (normally today), the number of days after which revision is flagged, the lines on a page of your mushaf and the pages in a juz. Type your class or group names.
2. On Students list each student with a group, start date, pages already memorised before you began logging, a target in pages and a target date.
3. On Daily Log add one row per session: date, student, the juz and range of the new lesson (sabaq) with pages or extra lines, recent revision (sabqi) pages, older revision (manzil) juz and pages, a rating from 1 to 5 and the teacher's note.
4. Students shows each student's total, juz, percentage of target, pace needed against pace achieved, projected finish and revision alerts. Revision shows how many days since each juz was last seen.
5. Open Dashboard for the whole programme, Totals for weekly and monthly pages, and Student Sheet to pick one student for a report to print or send to a parent.
6. Each day move the "as of" date on Settings forward. Check the Check column on Daily Log: it flags a student not on the list, a missing juz or a rating outside 1 to 5.

**Before you start:**

- New pages for a session = pages + lines / lines per page (Settings). Type whole pages in one column and any extra lines in the other, or lines alone.
- Total memorised = pages memorised before logging + all new pages logged. Juz = total / pages per juz. The sheet does not contain the mushaf: you type pages, it adds them up.
- Pace needed = pages left / days to the target date x 7. Pace achieved = new pages in the 28 days up to the "as of" date / 4. Status: Target met; On pace when achieved is at least needed; Behind otherwise; Past target date when the date has gone.
- Revision coverage looks at the juz you type in Sabaq juz and Manzil juz. A juz counts as seen on the date of its latest new lesson or older revision with pages above zero. Days since seen = as-of date - that date. A juz not yet in the log is left blank, so log a manzil row for juz memorised before you started.
- Revision alert on Students: Revise now when the last older revision (manzil) was more than the alert days ago; No revision logged when there is none. Sabqi does not reset it.
- Capacity: 40 students, 600 log rows. Weekly and monthly totals use weeks starting on Monday. The hidden columns AJ to BM on Revision and columns P to U on Daily Log are helpers: do not delete them.
- Use first names or a code for children, and keep the file somewhere only the teachers and parents concerned can open. This sheet records and adds up; it makes no judgement about a student.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-quran-hifz-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-quran-hifz-tracker-blank.xlsx)

Excel file (.xlsx) · 212 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## 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 edited by one teacher at a time | Each teacher logs in and works on the same data at once |
| You send the Student Sheet to parents as a PDF | Parents open their own page and see progress when it changes |
| You check the alert column yourself | Reminders reach the teacher or the parent on their phone |
| Juz and ranges are typed by hand | Pick the surah and ayah range from a list and have the pages filled in |
| A new file each term | Years of history for every student in one place |

### Extra features in the app

- A login for every teacher, so each sees only their own students
- A parent view with progress, teacher's notes and revision due
- Reminders when a student's older revision becomes overdue
- Lesson recordings or audio notes saved next to the log entry
- Attendance and fees for the programme in the same place
- Printed progress reports and certificates made automatically

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

## Frequently asked questions

### Is there a free hifz tracker in Excel?

Yes, this one is free. You log each session and the sheet works out pages, juz, percentage of target, pace and revision alerts for every student.

### What do sabaq, sabqi and manzil mean in the sheet?

Sabaq is the new lesson, sabqi is recent revision and manzil is older revision. Each has its own column in Daily Log and its own total on Totals.

### Can one sheet track a whole class?

Yes. It holds 40 students and 600 log rows. Use the group column for classes or teachers and Dashboard to compare them. For a larger school, start a new file each term.

### Can I use it for one child at home?

Yes. List one student, log each lesson, and use Student Sheet as the summary. The pace and revision alert work the same way.

### Does it work in Google Sheets?

Yes. It uses ordinary formulas that Excel, LibreOffice and Google Sheets all calculate. Upload the file to Google Drive and open it with Google Sheets.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Schools and students

## More free templates

- Gradebook Template for Excel (Weighted Categories, Letter Grades)
- College Application Tracker Spreadsheet for Excel (Deadlines, Checklist, Aid)
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)
- Homework and behavior tracker for teachers (Excel)
- School bus subscriptions tracker (Excel)
- Complete nursery management sheet
- Private school management sheet
- Lending library management sheet
- Graduation project manager sheet: tasks, team, phases and deliverables
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)
- Weighted Grade Calculator for Excel (Gradebook with Categories)
- Breakeven ROAS Calculator for Excel
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Construction Project Tracker for Excel
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
