Free Birthday Tracker Template (Spreadsheet + Printable)
A spreadsheet that works in Google Sheets, Excel, or Numbers, plus a one-page printable. The whole birthday system, set up in ten minutes, no signup.
Get the free birthday tracker three ways: make your copy in Google Sheets with one click, download the CSV file for Excel or Numbers, or print the one-page printable with the whole year on a single sheet. No signup, no email gate. Setup instructions below take about ten minutes.
Both are built around the same system: every date in one place, a reminder before the day, and a line of context so you know what to say.
What's in the Template
The spreadsheet has six columns, and each one is doing a job:
| Column | What it's for |
|---|---|
| Name | One row per person. Only people you'd genuinely call or message. |
| Birthday (Month/Day) | No year needed. Nobody's age belongs in a spreadsheet. |
| Relationship | Family, best friend, friend. Helps you sort by closeness later. |
| Remind me (days before) | Your lead time. 7 for people who get gifts, 3 for everyone else. |
| Gift ideas & notes | The hints they drop all year, and one line of life context for the message. |
| Last updated | So future-you knows whether the notes are fresh. |
Three example rows show the system in action: Mom gets seven days of lead time because the gardening gloves need shipping. Sarah gets three days and a note about the sketchbook she mentioned in April. Delete the examples and start typing your people.
The printable version is simpler by design: twelve months on one page, lines for a day and a name. Print it, fill it in pencil, stick it inside a cupboard door. It's for the household, not the phone.
Setting It Up (Ten Minutes)
Get your copy (1 minute)
Google Sheets: make your copy with one click. It lands in your Drive, on your account, with no strings back to us. Excel or Numbers: download the CSV, open it, and save in the native format.
Fill in your people (5 minutes)
Phone contacts, old birthday texts, and the family member who knows all the dates will recover most of them. The full collection method, including what to do about dates stranded on Facebook, is in how to remember birthdays without Facebook. Aim for your real circle: 15 to 40 rows, not 400.
Wire up the reminders (4 minutes)
Here is the honest part: a spreadsheet cannot remind you of anything. It's the memory; you still need the alarm. So for each row, create a recurring annual event in your calendar with an alert set to the "remind me" number you chose. Yes, this is the manual step. It's also the one that makes the whole thing work, because day-of reminders are how birthdays get scrambled.
From then on, maintenance is two habits: when someone drops a gift hint, it goes in their notes column within the hour, and when their reminder fires, you glance at the row before you write. The notes column is what turns "happy birthday" into "happy birthday, how's the new job treating you?"
Where the Template Stops
We made this template genuinely useful, and it has real edges worth naming.
The spreadsheet remembers perfectly and never speaks. Every reminder lives in your calendar as a separate manual step, and every new person means another row plus another calendar event. Notes and dates drift apart over time because they live in two systems. That's not a flaw in spreadsheets; it's what spreadsheets are.
If you reach the point where you want the dates, the notes, and the reminders to be one thing, that's the exact gap Kinu was built to fill: each person holds their own dates and little things, and the gentle reminder arrives with the context attached. The template is the system on manual. Kinu is the same system with the wiring built in, free for your first 10 people on iOS and Android.
Either way, the important part happens today: the dates leave your head.
Spanish versions: plantilla CSV and imprimible.
Frequently Asked Questions
Not ready to download?
Start with the Reconnection Kit.
A 5-minute exercise to find your inner circle and 12 reach-out templates that sound like you. Free, instant download.
Instant download. No spam. Unsubscribe anytime.
Keep reading
ADHD and Friendships: Why Staying in Touch Is Harder (And What Helps)
ADHD makes maintaining friendships uniquely difficult. Here's why 'out of sight, out of mind' happens and practical strategies that work with your brain.
Best Anniversary Reminder Apps (That Are Not Couples Apps)
Half the anniversary app results are couples apps you didn't ask for. The actual reminder tools, for your anniversary and everyone else's.
I'm Bad at Keeping in Touch: A Guide for People Who Care But Forget
You're not a bad friend. You just don't have the infrastructure. A practical guide for people who care deeply but struggle to stay connected.