Free template
Birthday list: ready-to-use Excel and printable
Choose the file you will actually use: a ready-to-use Excel workbook with 50 prepared rows, or a blank printable year list. The workbook calculates the next birthday, days remaining, and age at the next birthday when the birth year is known.
My list starts without example people. Example contains fictional entries; Read me explains the inputs and limits. The CSV below contains only the seven input fields, without formulas. None of the files sends messages or notifications.
Ready-to-use workbook or printable
50 prepared rows, an example sheet, and instructions. Next birthdays, days remaining and ages are calculated. Unknown birth years stay blank.
See an excerpt from the example sheet
| Name | Month | Day | Birth year |
|---|---|---|---|
| Naomi (fictional) | 11 | 5 | blank |
| Alex (fictional) | 2 | 29 | blank |
Fictional entries from Example. My list starts empty. Only some columns are shown here.
29 February uses 1 March in non-leap years. The PDF contains twelve months and blank lines, not personal data.
No sign-up, macros or automated messages. The file sends no notifications. Opening it in Google Sheets uploads it to Google. The CSV alternative below contains no formulas.
A CSV file with no sign-up. Import the columns as text using the instructions below. Downloading alone does not import anything.
UTF-8 with BOM · comma delimiter · header, fictional example row and one empty row. This CSV contains no formulas or automatic reminders.
What the CSV columns mean
| Column | How to use it | Example |
|---|---|---|
| Name | Use a name that helps you recognize the person. The example person is fictional. | Sam (fictional) |
| Month | Month as a number from 1 to 12. The workbook has a separate input field for this. | 12 |
| Day | Day as a number. The workbook checks whether the day and month form a valid date. | 31 |
| Birth year (optional) | Enter a birth year only when you know it. Otherwise leave it blank; the workbook will not show an age. | 1992 |
| Gift idea | An optional note you write yourself. Nothing triggers an automatic purchase or recommendation. | A book from their wish list |
| Lead time (days) | Days you would like for preparation. The workbook calculates a date, but sends no reminder. | 7 |
| Greeting channel | Note an appropriate way to get in touch. The file does not connect to email, calendars or messengers. | Personal message |
Import the CSV as text
Excel: Data → From Text/CSV. Choose UTF-8 and comma, then Transform Data. Disable automatic type detection or remove the Changed Type step. Select every column and set its data type to Text before loading.
Google Sheets: File → Import → Upload. Choose comma and turn off “Convert text to numbers, dates, and formulas” before importing. If that option is missing, use an importer with text-column controls. This uploads the file to Google; you can use Excel for a local file.
How to use this template
- Start with the empty sheet
Open the XLSX file and choose My list. It has 50 prepared rows. Inspect the separate Example sheet without bringing fictional people into your own list.
- Enter only the details you know
Fill the white input cells for name, month and day. The birth year is optional. Tinted columns contain formulas. Invalid input produces a check message rather than an apparently valid upcoming date.
- Sort by the next upcoming date
Use the table filter and sort by Days remaining rather than the month name. A birthday today has a value of zero. A 29 February birthday uses 1 March in non-leap years.
- Choose the printable or CSV deliberately
The PDF contains twelve months with blank writing lines for day and name and can be reused every year. The CSV contains input fields only. It does not automatically import into the workbook or a calendar tool.
Mistakes to avoid
- Inventing an unknown birth year
A placeholder year creates a false age. Leave the workbook birth year blank when you do not know it. Day and month are enough for the next birthday; the age is deliberately omitted.
- Overwriting formulas with inputs
Enter your details only in the white fields. The supplied file has 50 prepared rows. Adding more rows requires extending formulas, the table range and validation rules, then checking the results.
- Confusing a file with a reminder service
The list shows dates when the workbook is opened and recalculated. It sends no push notification. Use a dedicated tool for calendar entries and check its import and notification settings separately.
Frequently asked questions
- What happens when the birth year is unknown?
- Leave the year blank. The workbook calculates the next date from the day and month but does not show an age. No invented year is needed.
- What is already set up in the workbook?
- 50 input rows, formulas for upcoming birthdays and days remaining, a check column, and separate example and instruction sheets. The CSV does not contain these formulas.
- How does the list handle 29 February?
- It uses 29 February in leap years and 1 March otherwise. This is an explicit planning convention in the template, not a claim about when someone wants to celebrate.
- Do I need an account or an upload?
- No sign-up is required for the downloads. Opening a local file requires no upload to Endearist. Importing it into Google Sheets does upload it to Google. The workbook contains no macros.
Last updated: 2026-10-08
Endearist is in development.
Join the launch list: one email when it opens. Platforms, plans and capabilities need their own approval; signup creates no app access or purchase.
Join the launch list