Free Employee Birthday Tracker Template for Small Teams
Download a Google Sheets-compatible birthday tracker CSV, record separate reminder and greeting consent, and keep an accurate month-and-day roster.
By Kelasa team ·
Download the free employee birthday tracker CSV and import it into Google Sheets or open it in a spreadsheet app. It includes fictional sample rows, separate opt-ins for private reminders and public greetings, and a month-and-day birthday field. Delete the examples before entering real people. This is a manual roster, not an automated reminder or a live Google Sheet shared by Kelasa.
What the template includes
| Column | How to use it |
| --- | --- |
| Name | Use the name a teammate wants used in a greeting. |
| Birthday (MM-DD) | Enter 03-14 for March 14; do not collect a birth year unless you have a separate need for it. |
| Slack User ID | Optional. Leave blank if you do not need a mention. |
| Private reminder opt-in | Yes only if the person agreed to a coordinator receiving a private prompt. |
| Public greeting opt-in | Yes only if they agreed to a channel announcement. This is separate from the private prompt. |
| Time zone | Optional IANA zone, such as Europe/London, to help decide the appropriate local day. |
| Team | Optional grouping for the person maintaining the roster. |
The three sample names and dates in the CSV are fictitious, including a February 29 example. There are no formulas, integrations, or automatic upcoming-birthday indicators in the file. A spreadsheet containing real dates needs its own access controls; the publicly downloadable sample must never be used to publish your completed roster.
Import into Google Sheets
- Download the CSV above. Open a private Google Sheet and use File → Import → Upload, then select the downloaded file and import the comma-separated data. Google's import instructions describe the import location and separator choices.[1]
- Check the
Birthday (MM-DD)column after import. If a value became a full date or lost its leading zero, change the column to Format → Number → Plain text and re-enter the month/day values. Google documents the cell-format menu.[2] A CSV cannot carry spreadsheet formatting, so inspect the imported cells rather than assuming they stayed as text. - Delete the sample rows. Enter only teammates who have chosen to participate. Keep
MM-DDconsistent, and review any02-29entry with its owner before deciding what to do in non-leap years. - In the Sheet's Share settings, choose Restricted and invite only the people who maintain it. Check the parent folder's permissions too: Google notes that files inherit access from a shared folder.[3]
These are documentation-backed setup steps, not a hands-on import test. The template also works as a plain CSV in other spreadsheet tools, but menu names and date parsing may differ.
Find upcoming birthdays without an automation service
Once the values are text in the same two-digit MM-DD format, sort the birthday column ascending. Starting from today's month and day in the team's chosen time zone, read forward to the end of the list and then wrap to January. This gives the next birthdays without storing birth years. Check both opt-in columns before taking action; a private prompt is not permission for a public post. Assign a backup coordinator and mark greetings sent in a separate private log if duplicates are a concern.
For a personal prompt, see how to set a birthday reminder in Slack. Slack's reminder help documents personal and channel reminders and day-based repeats; this CSV does not create Slack reminders or guarantee annual recurrence.[4] Our guide to tracking employee birthdays in Slack compares a roster, calendar prompts, and app-based options. If you want a technical DIY route, read the Google Sheets-to-Slack walkthrough, which is sample code rather than a tested integration.
Keep the roster accurate and private
Ask whether the person wants a private prompt, a public greeting, both, or neither; update the fields whenever their choice changes. Remove departing teammates, avoid sharing the Sheet in a public channel, and do not put full dates of birth, ages, or private Slack tokens into the CSV. If a date falls on a weekend or public holiday, agree whether to celebrate on that day or the next workday rather than silently shifting it. For February 29, agree on February 28, March 1, or only leap years and document that rule separately. These are editorial workflow recommendations, not claims that the template enforces a policy.
If a human-maintained roster is becoming too much work, explore Kelasa BirthdayBot's overview for a daily Slack celebration digest with a chosen channel, schedule, and workspace time zone. Compare its current setup with your team's consent and privacy requirements; this template does not import directly into Kelasa.
Sources and editorial limits
- [1] Import data into Google Sheets — Google Docs Editors Help
- [2] Edit and format a spreadsheet — Google Docs Editors Help
- [3] Share and manage access to files and folders — Google Drive Help
- [4] Set a reminder — Slack Help Center
The CSV is an original, fictional starter template. It is not a hosted Google Sheet, a tested Slack workflow, a screenshot, or an automated upcoming-birthday dashboard. Check import formatting and permissions in your own workspace before entering real information.