Free template
Birthday list template
If you're looking for a birthday list template, chances are a birthday recently caught you off guard — the Facebook notification arrived the morning of, or worse, the day after. A spreadsheet fixes the remembering half of the problem well: every birthday in one place, sortable by month, with the gift idea you had in March still attached when October arrives. What it can't fix is the noticing half — a sheet doesn't ring. That's why this template includes a reminder lead-time column: it tells you how many days ahead each person deserves, so you can transfer the dates into your calendar app with the right head start, or import the CSV into Endearist and let the reminders come to you. Either way, the list is the foundation; build it once, on a quiet evening, and you'll never again type "happy belated" with that small sting of guilt.
Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.
What each column means
| Column | How to use it | Example |
|---|---|---|
| Name | One row per person — friends' kids get their own rows too; their birthdays often matter twice over. | Marcus Webb |
| Birthday | Always YYYY-MM-DD — it's the only format that sorts correctly and that formulas can compute with. Unknown year: enter 1900. | 1979-11-03 |
| Relationship | How the person relates to you — brother, coworker, godchild. Helps you triage when three birthdays land in one week. | Brother-in-law |
| Turning this year | Compute it with a formula instead of typing: =YEAR(TODAY())-YEAR(B2). Milestone birthdays (40, 50, 60) then jump out on their own. | 47 |
| Gift ideas | Capture ideas the moment the person mentions something — in July for November. This column is the real treasure of the list. | Keeps mentioning Japanese chef knives; done with gin |
| Reminder lead (days) | How many days ahead you want the nudge: 1 for a congratulations message, 14 if a gift needs buying or shipping. | 14 |
| Congratulate via | Call, card, message, or in person — the medium says more than the words. For the most important people, call. | Phone call |
| Notes | Anything particular about the day: never celebrates, hates surprises, shares the date with their daughter. | Always celebrates the weekend after |
How to use this template
- Gather every birthday in one sweep
Work through your phone contacts, chat profiles, old calendars, and — once — the birthday overview of your social networks, entering everything into the sheet. The sweep takes one evening and is the moment the list becomes complete; everything afterwards is just maintaining individual rows.
- Lock in the date format with validation
Format the birthday column as a date (YYYY-MM-DD) and add data validation that accepts only valid dates. Entries like "Nov 3rd" or "11/3 maybe" look harmless but break every sort and every age formula — validation catches them at typing time.
- Sort by month and day, not by year
To answer "whose birthday is next?", add a helper column with =TEXT(B2,"MM-DD") and sort by that. Sorting on the raw birthday orders people by birth year instead — putting the oldest person at the top rather than the next date on the calendar.
- Move the dates into your calendar with lead time
A spreadsheet won't nudge you on its own. So create a yearly recurring calendar event for each person — with as many days of warning as the lead-time column says. For gift birthdays that means two weeks out; for message-only birthdays, the day before is enough.
- Feed the gift-ideas column all year round
The best gift idea never arrives right before the birthday — it slips out casually in a conversation months earlier. Make it a habit to drop those moments straight into the gift-ideas column; half a sentence is plenty. Come December, the list repays you with ready answers instead of panic buys.
Mistakes to avoid
- Relying on social networks to remember
Facebook and friends only show the birthdays people entered and chose to share — and ever more people stop doing exactly that, or leave the platform entirely. Rely on the feed and you'll forget precisely the people who deliberately live offline. Your own list has no privacy settings to outsmart you.
- Guessing the birth year instead of leaving it out
A guessed year comes back to bite you: the age formula confidently outputs "turning 45", you congratulate someone on the wrong milestone, and it gets awkward. If you don't know the year for sure, enter 1900 as a placeholder and ignore the age column for that person — an honest gap beats false precision.
- Day-of reminders with zero lead time
A reminder on the morning of the birthday is fine for a text — useless for a package, a card that needs postage days, or making plans. The result is yet another rushed gift card. Differentiate the lead time per person: your five most important people need two weeks of runway, everyone else a day.
- Never pruning dead entries
Coworkers from eight years ago, the landlord from your old city — lists grow but never shrink on their own. Every row you don't actually congratulate dilutes the list and numbs you to its reminders. Walk through it once a year and delete what no longer applies.
Frequently asked questions
- How do I make a birthday list in Excel?
- Download the CSV and open it in Excel. Format the birthday column as a date in YYYY-MM-DD, freeze the header row, and add a helper column =TEXT(B2,"MM-DD") so you can sort by the next upcoming birthday. Fill the turning-age column with =YEAR(TODAY())-YEAR(B2). Then it's just data entry — one evening covers it.
- How do I calculate age from a birth date in a spreadsheet?
- For "turning X this year", =YEAR(TODAY())-YEAR(B2) is enough. The exact current age comes from =DATEDIF(B2,TODAY(),"Y") — that function automatically rounds down while the birthday is still ahead. Both formulas require the birth date to be a real date value in the cell, not text like "Nov 3rd, '79".
- How do I get reminded of birthdays in advance?
- The sheet itself won't remind you — it's the registry, not the alarm. Transfer each birthday into your calendar as a yearly recurring event and set the notification to the lead time from the sheet, say 14 days for gift birthdays. Alternatively, import the list into an app with built-in birthday reminders and skip the manual event creation.
- What do I do when I can't think of a gift?
- The problem rarely happens on the birthday — it happens eleven months earlier, the moment someone casually mentions something and you don't write it down. That's exactly what the gift-ideas column is for: half a sentence in July ("keeps mentioning chef knives") is a finished gift in November. If the column is empty, ask mutual friends — not the internet.
Last updated: 2026-06-10
When the spreadsheet gets too small.
Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.
Start free