Skip to main content
If you already have a list of teammate birthdays or work anniversaries in a spreadsheet, CSV import lets you add them to your Cake Day roster in one step. Members imported via CSV are set to Active immediately — Cake Day doesn’t send them an opt-in DM.
CSV import is available on Starter, Growth, and Pro plans. It is not available on the Free plan. Upgrade your plan to unlock it.

​
How to import

1

Open the Roster page

Go to cakeday.io/app/roster and click Import CSV.
2

Get the CSV template

Click Download template to get a pre-formatted CSV file with the correct column headers. You can also prepare your own file — see the column reference below.
3

Fill in your data

Open the file in your spreadsheet app and fill in each member’s details. At minimum, each row needs a slack_user_id. See the column reference below for all available fields.
4

Upload and confirm

Upload your completed CSV file and review the preview. Cake Day shows you how many rows will be added or updated before you commit. Click Import to apply.

​
CSV column reference

​
Important notes

  • Rows without birth_month and birth_day will be added to the roster but won’t receive birthday shoutouts until dates are filled in.
  • Work anniversary shoutouts are only sent when work_start_year, work_start_month, and work_start_day are all present.
  • The import merges with your existing roster — it does not delete existing entries. If a row matches a member already on the roster, their record is updated.
  • Members imported via CSV are set to Active — no opt-in DM is sent. If you want them to confirm or update their own dates, you can still invite them afterward via /cakeday invite @user.