Skip to main content

How to create a calendar in Google Sheets

Google Sheets offers quick spreadsheet tools to get organized fast, all natively part of Google Drive so you can easily share documents, collaborate on projects, and check on updates that others have made. That makes Sheets a great place to keep a calendar, such as a work calendar for a team to access or a calendar for school group projects.

Difficulty

Easy

Duration

15 minutes

What You Need

  • Google account to access Google Sheets

However, building out the rows and columns for a calendar manually is way too tedious for the average user. Fortunately, Google Sheets has templates and tools that make the process much easier. Here’s what you can do to quickly set up the right calendar for your needs.

How to make a calendar in Google Sheets

Remember, you will need to have a Google account to access Google Sheets and Google Drive. Google accounts universally apply across everything from Gmail to YouTube, so if you’ve ever signed onto a Google service, that’s the account that you’ll want to use. We advise using a desktop computer to set this up for the first time.

Step 1: Log into Google Sheets. You can visit the Google Sheets About page for a login option if necessary, or just head to Google Drive and choose the Sheets option from the top-right menu.

Go to Sheets Option on Google site.
Image used with permission by copyright holder

Step 2: Look at the top of Sheets, where it gives you a couple of different examples of Sheets that you can start. In this section, select Template gallery.

Choose Template Gallery in Sheets.
Image used with permission by copyright holder

Step 3: Now a list of the templates available for Google Sheets will appear. If you scroll through the sections, you’ll see a number of calendar template options for different purposes. Annual calendar and Schedule are two of the most versatile options, but there are also options for Shift schedules and Project timelines if you want. We’re going with Annual calendar for this example. Simply select the template you want to proceed.

Templates in Google Sheets.
Image used with permission by copyright holder

Step 4: With the calendar template open, it’s a good idea to immediately save it with a name that’s clearly recognizable, like “2023 Annual Calendar for Medical Checkups” or whatever else you need. The calendar itself will be set for the current year and day, so you’ll want to adjust those labels too, if necessary. Just replace the formula with “2023” for a new year or whatever other label you want.

Change Year in Google Sheets Calendar.
Image used with permission by copyright holder

Step 5: If you’re not a big fan of the color or style of the calendar, take a look at the tabs along the bottom. Here, you’ll see an option to Customize your calendar. This will give you instructions to check out the Theme section in Format, where you can choose from a number of different themes and select them.

Format in Google Sheets.
Image used with permission by copyright holder

Step 6: Now let’s talk about filling in the calendar you created. After the Customize Sheet, you’ll see other tabs, one for each month. Now, you could print these all out in a bundle and fill them in by hand, but if you’re like many of us, you may want to keep this calendar digital and easy to update by others. That means filling each of the boxes with event details on your computer.

There’s just one problem: By default, text wrapping is set to allow text to continue right to left until it overreaches into the boxes for other dates. To change this, select the Ellipses icon on the right of the Sheets toolbar.

Change Text Wrapping Google Sheets.
Image used with permission by copyright holder

Step 7: Now, select the middle icon that says Text wrapping when you hover a cursor over it. Select the icon with an arrow swerving between two lines. Now the text will wrap more appropriately around the date box, and you can make event notes.

Fixed Text Wrapping in Google Sheets.
Image used with permission by copyright holder

Step 8: Space is still limited for each day, however. If you need more room for extra detail, then you can right-click on a day and select Comment to create a comment for that box. This allows you to make a longer comment, add a link to a webpage, and make other useful additions to expand the information available. Multiple people can comment at once and tag each other to more easily communicate this way, too – that’s handy for setting up the details. You can also search in Sheets to find a specific event and save time.

Comment on Google Sheets.
Image used with permission by copyright holder

Step 9: Finally, note that there are also third-party calendar templates for Sheets available. If you don’t like Google’s own options, we suggest you also look at sites like Smartsheet, which has a very clean option, and The Good Docs, which has a couple of inventive options.

Interested in learning some more Google Sheets tricks? Check out our beginner’s guide, or take a look at specific skills like how to search for data inside Sheets.

Editors' Recommendations

Tyler Lacoma
Former Digital Trends Contributor
If it can be streamed, voice-activated, made better with an app, or beaten by mashing buttons, Tyler's into it. When he's not…
How to convert Google Slides to PDF
Google Slides with a PDF image on a MacBook.

Google Slides is very convenient, but sometimes a PDF is more useful. Luckily, you can save a Google Slides deck as a PDF from both your computer or when you use the smartphone app. The format is more universal. You can easily print a PDF or even throw it into your custom GPT to have conversations based on the contents. The best part is that you can convert any Google Slides file into a PDF easily using these instructions.

Read more
How to fix the ‘Google Drive refused to connect’ message
The Google Drive app logo.

Google Drive is one of the best cloud storage providers, offering its users the flexibility to access data from almost any device, anywhere in the world. However, it can sometimes fail to load and display the error message "Google Drive refused to connect" or "drive.google.com refused to connect."

This error may occur while using any of the Google office apps (like Docs, Sheets, or Slides) while using multiple Google accounts. If you are facing such an issue, we can help. Here's a quick step-by-step guide on how you can tackle this Google Drive connectivity issue.

Read more
Google Sheets vs. Microsoft Excel: Which is better?
Microsoft's PowerPoint on the Vision Pro.

Workplace visualization tools make the world go round, and will definitely liven up your before-lunch presentation. If you’ve got hard numbers to display to the masses, or graph-scribed projections you’re eager to get onscreen, you’ll need a powerful spreadsheet tool like Google Sheets or Excel to get the job done. But which of these two platforms is truly the best option? That depends on a number of things, and we’re not here to dissuade or encourage, but merely to inform.

We actually love Google Sheets and Excel, but for different reasons. One software may not be ideal for A, B, and C, although it may be really good at D, E, and F. Whatever the case may be, we put together this comparison of Google Sheets and Excel, with focus paid to essential categories like application access, data analysis, and charts and graphs. 
The basics
It’s worth stating from the start that both Sheets and Excel are excellent spreadsheet applications. So if you have the opportunity to try them both out, you may have a clear preference from the start. But if you’re doing your research first, just know that you can’t go wrong with either.

Read more