Ramadan Tracker — Microsoft Excel A free, easy-to-use Excel workbook to track your prayers, Zakat, Qur'an, good habits, and ...

Ramadan Tracker — Microsoft Excel

A free, easy-to-use Excel workbook to track your prayers, Zakat, Qur'an, good habits, and the last ten nights of Ramadan — all in one file, no macros, no setup.

Ramadan Tracker for Microsoft Excel — Mandatory Prayers, The Power Night, Charity Tracking, Habits Development, Deeds Tracking, Zakat Management

Ramadan asks a lot of us at once — five daily prayers plus Taraweeh, Zakat calculations, Qur'an goals, good habits to build, bad ones to leave behind, and the extra focus the last ten nights deserve. This workbook brings all of that into a single Excel file you can open, fill in, and glance at every day. It's built to be genuinely easy to use: every status you log is a simple dropdown, every total and percentage calculates itself, and the charts update automatically as you go.

Download the Workbook

Free to use. No sign-up, no macros, works in any modern version of Excel.

⬇ Download Ramadan Tracker (.xlsx)

What's Inside

Intro

A short reflection on what Ramadan is about, with a Qur'an reference to set the tone.

Mandatory Prayers

All 30 days × 5 daily prayers, with Jamat / Alone / Qaza / NA tracking and a live summary chart.

Voluntary Prayers

Tahajjud, Ishraq, Chasht and Awwabeen tracked separately — bonus worship, never counted against you.

Zakat Management

Enter what your Zakat is due on, get the 2.5% calculated automatically, and log payments as you give.

Qur'an

Recitation, translation, tafseer, and memorization — organized by Surah, with progress charts for each.

Habits Development (To Do / To Stop)

Set a target for good habits to build and bad ones to leave behind, and watch your consistency add up.

Deeds & Charity Tracking

Daily charity, mosque help, and other good deeds — simple to log, simple to see your progress.

The Power Night (Laylat al-Qadr)

A dedicated space for the last ten nights — extra Qur'an, dhikr, charity and prayer, night by night.

Why You'll Like Using It

✓ No macros — opens safely in any version of Excel, nothing to "enable content" for.
✓ Dropdown lists for every entry — no free typing, no inconsistent data.
✓ Every total, percentage, and chart updates itself the moment you fill in a cell.
✓ Color-coded automatically, so a glance at the sheet tells you how you're doing.
✓ Works completely offline — your data stays in your own file, on your own device.

Ready to Start?

Grab your copy and fill in today's prayers in under a minute.

⬇ Download Ramadan Tracker (.xlsx)

Prefer an Online Version?

If you'd like advanced analytics, theme customization, and a more versatile, interactive design — with everything updating live in your browser — try the full online tool instead: