Google Sheets calendar template

How to open it in Google Sheets

What's in the file

About the holidays

Frequently asked questions

Your events (0 of 200 max)

Preview

Free template

Choose the year, the months and whether weeks start on Sunday or Monday, mark US federal holidays, add your own events, check the calendar here and download it as an .xlsx workbook to import into Google Sheets.

Optional: add birthdays, deadlines or days off. They appear in the preview and in the file.

calendar-2026-01-to-2026-12.xlsx

Downloads as an .xlsx workbook, built in your browser: nothing you type is sent anywhere or saved.

Day cells look as in the file: up to four lines a day, long names shortened with “…”. “+N more, see list” points to the Holidays & events sheet in the download, which has every name in full.

Highlighted days are US federal holidays on the dates federal employees observe them (OPM).

Google Sheets can import .xlsx files (File › Import). The steps from Google's help page:

On your computer, open or create a spreadsheet in Google Sheets.
At the top, click File › Import.
Choose the .xlsx file you downloaded.
Select an import option, for example “Create new spreadsheet” or “Insert new sheets”.
Click Import.

Calendar: one sheet per month (named like “Jan 2026”) or one “Calendar” sheet with the months stacked. Each month has a title, a weekday header and six week rows; under each day number there is a cell for your notes, where holidays and your events are already written, one line each and up to four a day (longer names are shortened with “…”; a busier day ends with “+N more, see list”). Weekends are shaded and holidays highlighted.
Holidays & events: every holiday and event in the calendar with its date, weekday, full name and type, sorted by date.
How to use: short notes on typing in the calendar and importing it into Google Sheets.

Day numbers are typed values, not formulas. Each month is set to print on its own landscape page.

The holidays are the US federal holidays from the OPM holiday schedules for 2025–2030, on the observed dates: when a holiday falls on a Saturday, most federal employees get the Friday before; on a Sunday, the Monday after (for example, Independence Day 2026 is observed on Friday, July 3). The names are the ones OPM uses, such as “Washington’s Birthday”. Inauguration Day is not included, because it applies only to federal employees in the Washington, DC area. To mark other days off, add them as your own events.

Planning a project rather than a calendar? The Excel project management template builds a task plan with a Gantt chart.

Need a week of time slots instead? The Weekly schedule template lays out time blocks or employee shifts by day and hour.

1New Year’s Day

19Birthday of Martin L…

Is this Google Sheets calendar template free?: Yes. Choose your months above and press Download .xlsx. The file is built in your browser, so nothing you type is sent to us or saved.
How do I get it into Google Sheets?: Open or create a spreadsheet in Google Sheets, click File > Import, choose the downloaded .xlsx file, select an import option such as “Create new spreadsheet” and click Import.
Can I make a yearly calendar or just one month?: Both. Pick any first month and 1 to 12 months; the range can run into the next year. Choose one sheet per month, or one sheet with the months stacked.
Which holidays does it mark?: US federal holidays from the OPM schedule for 2025–2030, on the dates federal employees observe them. Inauguration Day, which applies only in the Washington, DC area, is not included. For other years the holiday option is off.
Can I add my own events?: Yes, up to 200 events with a label of up to 60 characters. They appear under the day number in the file, with the holidays, and in full in the Holidays & events sheet. A day cell has room for four lines: a long name is shortened with “…”, and a day with more than four entries shows three and “+N more, see list”.