Add your prayer times

1. Get your spreadsheet ready

Open Prayer Times, press Import / Export, then press Download sample CSV. Open it in Excel or Google Sheets and copy your times in. You need one row per day and these columns:

• date. Prefer DD/MM/YYYY, for example 05/10/2026 (5 October 2026). DD/MM/YY and YYYY-MM-DD also work. Dates are always read day first.
• fajr, zuhr, asr, maghrib, isha: the start (adhan) times. These must be filled in for every day. sunrise and imsak are optional.
• Jamaat times fajrJamaat, zuhrJamaat, asrJamaat, maghribJamaat, ishaJamaat, if you have them.
• jummahKhutbah and jummahJamaat for Friday, and jummahKhutbah2 and jummahJamaat2 if you have a second Jumu'ah.

Prefer 24-hour times, written HH:MM, like 16:20. 12-hour times with AM/PM are fine, like 4:20 PM. A time without AM/PM is read for that prayer, so Asr 04:20 is imported as 16:20. The column names don't have to match exactly. "Fajr Jamaat" or "Fajr J" is fine, and columns the portal doesn't know, such as "Day", are ignored.

When you're done, save it as a CSV file. In Excel that's File, Save As, then CSV UTF-8. An ordinary Excel file won't upload. If your timetable is in Google Sheets you can skip this and paste the sheet's link instead, as long as the sheet is shared with "Anyone with the link".

2. Upload it

1. 1

   On Prayer Times, press Import / Export

2. 2

   Drop your file in the box, or choose the Google Sheets tab and paste the link

   The portal checks the file straight away and ticks off each check. If something's wrong, it tells you which row.

3. 3

   Press Review

   Check the first ten rows look right. Dates are read day first, so 05/10/2026 is 5 October. If a column has been matched to the wrong thing, change it in the Maps to list. Then press Next.

4. 4

   Choose what happens to times already there

   Pick Preserve manual edits (recommended). That replaces old times but keeps any day you changed by hand. Then press Import.

If your file had jamaat or Jumu'ah times, the portal also sets up your jamaat and Jumu'ah schedules from them. Check them afterwards: see Set your Jumu'ah times.

Start times are worked out from the map position of your masjid. Before you start, open Settings then Masjid Details and check the address. Press Get Coordinates from Address and save.

1. 1

   On Prayer Times, press Set Prayer Times

2. 2

   Choose a calculation method and Asr method

   Most UK masjids use Muslim World League and Hanafi. If your Fajr or Isha is usually a few minutes different, add the difference in Time Adjustments. Press Continue.

3. 3

   Choose how to set jamaat times

   Smart Periods sets jamaat times for you using rules. Manual Entry leaves jamaat times empty for you to type in later.

4. 4

   Set your jamaat rules (Smart Periods only)

   For each prayer choose Fixed Time (the same time every day) or Minutes After the adhan. Give each period a name and dates, for example winter and summer. Fill in your Jumu'ah khutbah and jamaat times too.

5. 5

   Choose Entire Year and the year, then press Generate Prayer Times

   If some of those days already have times, the portal warns you how many will be replaced and how many of them you changed by hand. Press Generate anyway to carry on.

After generating, compare a week against a timetable you know. If something looks wrong, press Undo last change at the top of the page to put things back as they were.

• Your screens. Uploads, the wizard and changes to a single day reach screens within seconds.
• The Community app, for people who follow your masjid.
• Your website, if you use the prayer times widget. It catches up within a few minutes.
• Printed timetables you make in Prayer Calendar.
• The Dashboard, in the band at the top.

Screens keep the next week of times saved on them. A Display Unit carries on showing the right times if the internet goes down for a few days.

When your times will run out in the next 60 days, the Dashboard's Needs you list tells you, with a button to add more. It also warns you three weeks before the clocks change, so you can check your jamaat times for the new season.

The Prayer Times page shows a warning at the top if any of the next three months are missing.