On this page you'll find the best Google Sheets calendar templates, for any purpose.
There are several different types of Google Sheets calendar templates on this page. Whether you are looking for a monthly full-size calendar where you can fill in multiple events for each day, or if you are simply looking for a yearly miniature calendar that shows the entire year on one sheet, you'll find the template that you need!
New calendars have been added to this page, such as the automatic calendars which will allow you to choose any year that you want!
Full-size monthly calendar template for Google Sheets
The calendar templates shown and explained below, have large squares, they have one tab for each month of the year, and they provide a big place for you to fill in your schedule/events.
See below for a breakdown of the different versions that are available in full-size.
There are two different types of the full-size monthly calendar:
Normal version
The normal version of the calendar template has one big square that can be filled in for each day, just like you would expect on an ordinary calendar that you buy from the store.
Note: While typing in a single spreadsheet cell, if you hold the "Ctrl" key and then press "Enter", your cursor will go to a new line within the same cell.
Lined Version
There is also a version of the calendar template that is "Lined", and has 5 rows that can be typed in for each day. This will help you record multiple events/tasks easily, and in a very structured way.
2021 Full-size Monthly Google Sheets calendars
The following templates contain the entire year of 2021:
2021 Normal calendar
2021 Lined calendar
2022 Full-size Google Sheets calendars
The following templates contain the entire year of 2022:
2022 Normal calendar
2022 Lined Calendar
2023 Full-size Google Sheets calendars
The following templates contain the entire year of 2023:
2023 Normal calendar
2023 Lined calendar
Yearly calendar template [Single sheet] for Google Sheets
In this section you will find the yearly single sheet Google Sheets calendar template. This template displays an entire year on one single sheet… and contains three tabs / three full years [currently 2021, 2022, and 2023].
These templates are great for showing seasonal trends and color coding specified days/weeks.
Yearly mini-calendar [2021, 2022, 2023]
There are also automatic calendar templates that you can use, so that you can select any year that you want. There is an automatic temp[late for the full-size calendar, as well as the mini-calendar.
When using the automatic templates, start by setting the "Start Date" on the top right of the sheet. This will determine the month that the calendar starts with [January 1st is the default, but you can start your calendar with other months as well if you want].
If you want, you can also set the "End Date". No matter what the end date is, the calendar will always display an entire year of dates… however, the "end date" does control the highlighting / conditional formatting in the calendar. So all of the days that fall within the date range between the start date and the end date, will be highlighted in yellow color, for both the full-size version as well as the mini-calendar.
Full-Size monthly automatic calendar
This calendar template will allow you to see an entire year on a single sheet, and will let you set the date range / year. The template will automatically fill in the dates, and it will highlight the dates that fall within the date range that you set.
Yearly automatic mini-calendar
Yearly automatic mini-calendar
This calendar template has an entire year, with one month displayed on each tab. You can set the date / range / desired year, and the template will automatically fill in the dates and will also highlight the days that fall within the date range that you specify.
Full-Size monthly automatic calendar
How to type on a new line within the cell [Multiple lines / items in a single cell]
While you are using the calendar templates, it can be very useful to be able to type multiple lines of items / events into a single cell. For example, on the full-size templates with one big square per day, even though there are not multiple cells for each day like in the "Lined" version, you can still type on a new line within a single cell.
To go to the next line within a cell in Google Sheets, follow these steps, while editing a cell [cursor will be blinking] press Ctrl + Enter on the keyboard, and Google Sheets will move the cursor to a new line, within the same cell.
For example, if you want to list two events on the same day, in the same cell, and you want each of those events to be listed on their own line, you would do the following: Type the name "Event 1", and while the cell is being edited [before pressing "Enter", hold the "Ctrl" key on the keyboard and then press "Enter", and Google Sheets will move the cursor to a new line within the same cell. Then type "Event 2". Repeat the process as needed, for as many lines as you need.
How to use open the calendar templates [How to make a copy]
If you are using a desktop computer, after clicking the links to the templates on this page, you'll be taken to a preview of the template, and in the upper-right corner of the screen you will see a blue button that says "Use Template". Click this button, and Google Sheets will automatically make you a copy of the template that you can edit. [You must be logged into your Google account to make a copy]
Although the templates on this page can be accessed with the "Use Template" button, below are instructions for how to make a copy of the template in other cases when you are viewing the sheet in "View Only" mode.
To make your copy of Google Sheets templates in general, follow these steps:
Open the sheet
Click "File" on the top toolbar
Click "Make a copy"
Name your copy, and then click "OK"
Why Google Sheets calendars are so great
Google Sheets is the perfect place to create a calendar, since it is so easy to access, and so easy to enter information into.
For people who already work in spreadsheets a lot, it just makes sense to use a spreadsheet calendar.
Google Sheets calendars make it easy to add notes and events to the calendar very quickly, and there are a tons of different templates to choose from to find the one that suits you best, which of course is what this page is for.
I hope that you enjoy these templates and I hope that they make your life a little bit more organized!
Click here to get your Google Sheets cheat sheet
The content on this page, including the templates, were originally created by SpreadsheetClass.com