This Ramadan planner spreadsheet plans the household side of the month: the meals, the guests, the shopping and the cooking ahead. Enter each night’s menu and guests once, and the workbook scales every iftar dish to that night’s head count (suhoor dishes to your household alone), builds a store-section shopping list for any 10-day block net of what’s on hand, schedules what to cook and freeze by its cook-by date, and flags any hosting night still missing a needed course. Goals, daily reflections, a giving plan, an Eid countdown and a kids’ chart sit in the same file. It works in Excel, LibreOffice and Google Sheets (a one-click copy), with an undated printable planner too.
A printable Ramadan planner gives you boxes to fill in. It can’t tell you how much rice fourteen people need, which night nobody is bringing dessert, or what has to go into the freezer this week. Those are the jobs this workbook calculates.
A Ramadan meal planner that knows who’s coming
On the 30-Day Plan you pick each night’s suhoor and iftar dishes - starter, main, side, dessert and drinks - from drop-downs fed by your own Dish Library. Mark a night as hosting, list the guest families on the Hosting Roster, and the head count fills itself in: your household plus every guest who hasn’t said No. Suhoor scales to the household alone. A small table at the bottom shows how the cooking is shared across the household.
Every dish scaled to the night’s head count
Pick any night on the Quantity Calculator and every iftar dish is scaled to the head count (suhoor to your household) plus your buffer (10% in the sample), with each ingredient’s amount, unit and store section listed underneath. Expecting more people than planned? Type a what-if head count and see the amounts change without touching the plan.
The workbook starts with 36 dishes from many kitchens, 167 per-person recipe lines and 87 ingredients. The per-person amounts are home-cook starting estimates, so adjust them to how your family eats, and add your own dishes and recipes.
A shopping list built from the plan
The Shopping List adds up every ingredient the plan needs for the block you choose - Days 1-10, 11-20, 21-30 or any days you like - subtracts what you have on hand, and sorts what’s left into 12 store sections in the order you walk the store. Paper plates, candles and anything else no recipe covers go in the extras rows.
Freezer prep-ahead, on a schedule
Mark a dish as freezer-friendly in the Dish Library and give it a lead time. Prep-Ahead then lists every time it appears on the plan with a cook-by date - the serve date minus the lead days - soonest first, with a status of Cook now, This week or In the freezer, and the month’s total servings so you know how big a batch to make.
An iftar hosting roster with a course check
Each guest family gets a row: the night, how many people, which course they’re bringing and whether they’ve confirmed. For every hosting night the roster checks each course you need against the host’s own plan and the guests bringing something, and flags anything left as MISSING - on the night itself, on the 30-Day Plan and on the Dashboard.
The whole month at a glance
The Dashboard reads every other tab: today’s day of the month, days to Eid, tonight’s menu and head count, hosting nights and guests, nights with a missing course, ingredients to buy, freezer dishes to cook now, and the progress on goals, reflections, giving, Eid tasks and the kids’ stars.
Goals, reflections, giving and an Eid countdown
- Goals - the household’s own goals with a daily tick grid, plus a Quran tracker for each reader: tick off each of the 30 juz as it is finished.
- Reflections - a few lines a day for each person in the household, counted on the Dashboard.
- Giving Plan - what you plan to give to each cause against what you’ve given, toward a target you set. It is a record only, with no obligation calculations.
- Eid Countdown - 20 pre-filled tasks, each set a number of days before Eid, with its target date, days left and status.
- Kids’ Chart - a star for every good deed, day by day, toward a star goal and a family reward you choose.
Undated, so it works every year
Type the month’s Day 1 date and its length once in Setup, and every date in the workbook follows, Eid included. Nothing is pre-set for a particular year or a particular tradition: the timings, the menu and the practices are your family’s own. The workbook gives no religious rulings and no prayer times.
A printable planner, too
The download includes 14 undated print-and-fill pages in Letter and in A4 - a 30-day overview, a meal plan page, shopping by store section, a hosting night sheet, freezer prep-ahead, goals and the Quran tracker, three daily reflection pages, a giving record, the Eid countdown, the kids’ good-deeds chart, table cards and dish labels, and door signs - plus a worked example filled in for a fictional household.
Try the free version first
The free iftar hosting night sheet is one hosting night: list who’s coming and what each family brings, and see which course is still uncovered. No email, no signup. The full planner adds the 30-day plan, the quantity calculator, the shopping list, freezer prep and the family tabs.
Own it, don’t rent it
This is a file you keep: no account, no subscription, and nothing that stops working when the month ends. It opens in Excel, in LibreOffice, and as a native Google Sheet through a one-click copy link to a Sheet that is already built, so there is nothing to import. The sample household in the workbook and on these images is fictional - clear its entries and the As-of date on Setup (it pins “today” to the sample’s Day 12), then start your own plan, as the 12-page Start Here guide shows.
