Sunday, February 16, 2020

Import Calendar Dates You Can Do

Do you create numerous calendar events? Are you a "calendar" person?

Google Calendar is my lifeline. I depend on it every day. I also see how powerful Google Calendars are for larger purposes ... buildings, staffs, communities, large groups, etc. But the problem is, creating calendar events on a large scale can take large amounts of time. It can open the door for errors.

Awhile back, I searched and searched and found a few helpful resources. I found an article or two, a couple of videos ... but what I really wanted was a template that was ready-to-go and "easy" to use. What I had found was the "theory" behind using a Google Sheet and importing it to Google Calendar. Since I couldn't find a template, I made one and today I want to share that out.

It is a basic, simple, and straight-forward idea. Take a Google Sheet, format it correctly, load in your dates (& as much info as you want to), save as a csv, and upload to the correct Google Calendar. Voilá!

I have used this method for athletic calendars very successfully. I've also recently shared this idea with my district for our yearly calendar. I see this as very helpful. Each building can have its own tab. Tabs can be duplicated - or individual rows can be copied over - for events that need to be on multiple calendars.

To be 100% honest, the first time you create a large number of events, you are not going to "save" a ton of time, but the benefits come in when you have repeating events or you use the same large number of events over and over. For example, a weekly repeating meeting ... create the dates on 2 rows, then use the "magic" of selecting them both & pulling down on the "blue box" to keep that repeating time frame. And if you are like many schools, you probably use "comparable dates" year after year ... and that is where I see a Sheet saving time. [Also, one person can create the district-level events and they be copied over to each building, or use the calendar layering ability to have them all show at the same time.]

Included with the template is a tab for directions. I also tucked in "notes" on each of the column headers to help guide you when you are actually creating your events. I've tried to create this to be something ANYone can do, but if you get stuck or you need help, feel free to reach out!

And finally, at the bottom of the instructions tab, I added a couple of tips on ways you could go further. Interested in an automatic creation of events from your Sheet? Yep - it's possible ... check out the "How to automatically add a schedule from Google Sheets into Calendar" video. Maybe one day, I'll tackle that, too! 

Here is a sneak peak at the template ↬

Link to "template/preview" option (allows for quick copy)

Link to "View only". Please use the "File --> Make a copy" option to make your own copy.

You can also find this on my "Templates for Teachers" website. Feel free to check this one out, along with the 70+ other templates my colleague Beth Kingsley & I have created and shared out.

Looking for Sheets or Calendar ideas/tips/tricks? Check out my Wakelet collections: 
Google Sheets Wakelet
Google Calendar Wakelet

And, as always, have a question or comment? I'd love to hear from you! Feel free to comment below, email me at, or find me on Twitter @kiefersj.

No comments:

Post a Comment