Home Islamic Prayers Tracker in Excel for Muslims


Dear Muslim Brothers and Sisters,

Ideally speaking, we, the Muslims, should not maintain such trackers as 5 times prayers is compulsory on us and we should be performing each prayer on time without any reminder. However, being too weak in our Imaan (Faith) we miss a lot of prayers on daily basis. 

Hence, I created this "Prayers Tracker"  and I personally experienced it helping me remind myself again and again to pray on time, perform the missing prayers (Qaza) and improve my stats (as shown in the automatic Summary Sheets). This is why I want to share this excel file with you as well.
The only thing you have to do is to enter your prayer in the first sheet. Rest of the graphs are created automatically.

Sheet-1: Enter Your Prayers:




Summary-1 Sheet: This automatic sheet will show total numbers of prayers (performed and remaining) for each day and each month








Summary-2 Sheet: This sheet shows Performed and remaining prayers for different months. Chose the month and graph will be displayed automatically.







Summary-3 Sheet: This sheet shows percentage of prayers performed and remaining. This sheet is also automatic.







Summary-4 Sheet: This sheet shows Prayer-specific statistics for each month. Chose the prayer and the graph will be displayed automatically.







Summary-4 Sheet: This sheet shows high-level numbers/stats. (Automatic)


If you want to get a copy of this excel file, please drop me an email at mjunaidtahir@gmail.com and I shall respond back within 48 hours insha-Allah.

Note: please let me know if you want me to send you an A4 printing pdf file which you can print and distribute to your family members, friends and colleagues. Please help spread this message as it will act as Sadqa-e-Jaria for you, insha-Allah.
Share To:
Axact

DailyTenMinutes
Islamic

Post A Comment:

26 comments:

  1. Waseem WaqarJanuary 2, 2017 at 3:56 PM

    جزاك الله خيرا

    ReplyDelete
  2. سليمان حميد‎January 2, 2017 at 3:56 PM

    Thanks alot.

    ReplyDelete
  3. Showkat AhmadJanuary 2, 2017 at 3:57 PM

    Thank you

    ReplyDelete
  4. Tasawar MukhtarJanuary 2, 2017 at 3:57 PM

    great work. thanks sir

    ReplyDelete
  5. Naveed Habib KhanJanuary 2, 2017 at 5:42 PM

    Jazak Allah

    ReplyDelete
  6. Furqan UllahJanuary 3, 2017 at 7:27 AM

    Assalamu alaikum. junaid tahir bhai i truly appreciate your this effort.
    I have shared your prayer excel spreadsheet with all my students in college but this time again I request you to send me A4 printing pdf file so that I may use it and share with my students and family members. Thanks bhai, you will be always in my prayers. Allah bless you.

    ReplyDelete
  7. Shihas AshrafJanuary 3, 2017 at 7:27 AM

    Assalamualaikkum..
    thank u very much brother..

    ReplyDelete
  8. Muzafferuddin ahmedJanuary 3, 2017 at 8:24 AM

    Nice effort. May Allah reward you.

    ReplyDelete
  9. Bhagaspati Sukma BkJanuary 3, 2017 at 5:19 PM

    Thanks :) May Allah bless you with Happintess and Grace your home with Warmth and Peace

    ReplyDelete
  10. ZAID HUSSAINJanuary 3, 2017 at 5:20 PM

    Dear Tahir,

    Jazak-Allah for sharing tracker sheet, its helping a lot.

    Thanks

    ReplyDelete
  11. HAFIZ DAUD NASEERJanuary 3, 2017 at 5:21 PM

    thanks
    jazakumAllha

    ReplyDelete
  12. Muhammad RizwanJanuary 4, 2017 at 6:30 PM

    Dear Mr. Junaid,

    I am pleased to see your excel sheet about prayer. its useful to make sure our prayer are continue in good manner. if missing prayer shows status poor it feel us by heart. same as our school result show low marks in the sheet. Appreciated Your nice efforts to put in practical manner.

    Best Regards,
    Rizwan
    Dammam-KSA

    ReplyDelete
  13. Fahad Bin ZiaJanuary 5, 2017 at 9:01 PM

    Assalamo Alikum,
    Kindly send me the Prayers Tracker excel sheet for properly know how much namaz I lost.

    ReplyDelete
  14. Abdul Khaliq ChaudariJanuary 5, 2017 at 9:04 PM

    Appreciate your accomplishment. Please forward a copy of the Excel file. Jazako mullaho khaira.
    Best regards,

    ReplyDelete
  15. Fahad Bin ZiaJanuary 6, 2017 at 10:15 AM

    Dear Mr. Junaid,
    It is excellent and awesome. I start using it from today. Thanks a lot and I appreciate you for this effort.

    Best Regards,
    Fahad Bin Zia
    Team Lead - Development Unit

    ReplyDelete
  16. Sus Hossam MustafaJanuary 8, 2017 at 8:36 AM

    my name is Mustafa and I am from Egypt
    I am very glad to see this excel .. thank you very much .. and please send me the A4 printing pdf file .. may Allah bless you and all of these Hasanat will be in your Mizan insha'Allah ..

    thanks a lot my friend

    ReplyDelete
  17. KKJanuary 27, 2017 at 8:13 AM

    Thank you dear , may Almighty Allah reward you , and accept all our good deeds,, JazakkAllah

    ReplyDelete
  18. Furqan UllahJanuary 19, 2018 at 9:14 AM

    Assala mu Alaikum Dear Junaid Tahir Brother,

    I am really impressed by your efforts of making such a nice tool that I have no such words to express my feelings but I pray five times a day for you and your family to have the best of both the worlds. Actually, i am a lecturer in Higher Education Department and really share your this tool with my students positively as you send me new versions. Thanks to ALLAH that I got such tool from you and May Allah bestow his mercy upon you and your family...

    ReplyDelete
  19. Asadullah MustafaJanuary 24, 2018 at 8:19 AM

    AOA Junaid,
    Hope you are doing well & I applaud you for this pious job of Namaz Excel sheet
    Kindly Share with me also, sent email to you.
    I shall be looking forward to your reply
    Regards

    ReplyDelete
  20. Azzar RahmanSeptember 1, 2018 at 6:30 PM

    asalam o alikum i need that excel file for prayer

    ReplyDelete
  21. ShafinSeptember 1, 2018 at 6:30 PM

    As-Salamu Alaykum,
    Brother, I just completed your article and it's great.

    " Islamic: Track your Prayers with this Simple Excel File"

    I need the Excel File.

    Thanks and jazakAllah,
    Shafin

    ReplyDelete
  22. Jamshaid UL HassanSeptember 1, 2018 at 6:31 PM

    Assalam o Alaikum brother,
    I reached & found your post regarding prayer attendance. So could you pl. share same excel files with me.

    ReplyDelete
  23. Syed MuzammilSeptember 1, 2018 at 6:32 PM

    Asalamualikum brother i want to track my namaz in excel sheet..can you send me that sheet if it is possible .

    ReplyDelete
  24. Huzaifa WastiSeptember 1, 2018 at 6:32 PM

    Salam,
    Hope you are doing well. I was wondering if I can get the excel prayer tracker template. thank you.

    ReplyDelete
  25. Muhammad Waqas AhmadFebruary 25, 2019 at 8:32 AM

    Hi Junaid,



    I hope you are doing great.




    While searching for online qaza namaz tracker, I saw your post.




    It looks good effort.




    Kindly share the excel so I can use.




    Thanks and Jazakaalh.

    Regards

    ReplyDelete
  26. Zeeshan SarfrazFebruary 26, 2019 at 7:42 AM

    Asslam O Allikum Dear Brother,
    I hope you are fine and enjoying the blessings of Allah Almighty, please mail me the prayer tracker template in excel. Thanks M Zeeshan Sarfraz

    ReplyDelete

Subscribe to: Post Comments (Atom)