Free Excel Templates for Umrah & Hajj Agencies

One row per pilgrim with the passport details every later list is built from.

What’s inside: Passport number and expiry, date of birth, nationality and contact details — and it imports straight into Ziyara, so nothing is typed twice.

A hotel-ready rooming list for Makkah or Madinah, one row per bed.

What’s inside: Room-type and gender drop-downs, a red warning when a room holds more pilgrims than its type allows, an orange one when a room mixes genders, and live headcounts.

A group passenger manifest in the column order airlines ask for.

What’s inside: Names as in the passport, date of birth, nationality, passport details, ticket and seat — and passport expiry turns red when it is less than six months after the flight date.

The pricing method from our guides as a working spreadsheet.

What’s inside: Hotel costs split by room occupancy, fixed costs per pilgrim, buffer and margin, the selling price per room type and a break-even table for smaller groups.